Creating accounts, managing password profiles, and authenticating via the operating system or password files.
Recovering from the loss of a non-critical file, a multiplexed control file, or an online redo log file. 8. Performance Monitoring and Tuning
Use Oracle VM VirtualBox combined with Oracle Linux to build a test environment. Oracle provides free pre-built developer VMs for quick deployment.
The root container that holds the system metadata and shared background processes. Performance Monitoring and Tuning Use Oracle VM VirtualBox
The workshop moves beyond maintenance into system optimization. Automatic Workload Repository (AWR) & ADDM
+-------------------------------------------------------+ | Oracle Instance | | +-------------------------------------------------+ | | | System Global Area (SGA) | | | | +-----------------+ +-----------------------+ | | | | | Database Buffer | | Redo Log Buffer | | | | | +-----------------+ +-----------------------+ | | | | +-------------------------------------------+ | | | | | Shared Pool | | | | | +-------------------------------------------+ | | | +-------------------------------------------------+ | | +-------------------------------------------------+ | | | Background Processes | | | | [DBWn] [LGWR] [CKPT] [SMON] [PMON] | | | +-------------------------------------------------+ | +-------------------------------------------------------+ | v +-------------------------------------------------------+ | Database Files | | +----------------+ +----------------+ +-----------+ | | | Data Files | | Control Files | | Redo Logs | | | +----------------+ +----------------+ +-----------+ | +-------------------------------------------------------+ Memory Structures
To get the most out of the Oracle 19c Administration Workshop material, learners should complement reading with practical application: and Performance Tuning Basics
DBAs control database availability and operational behavior using command-line utilities. Initialization Parameters Text-based initialization file read only at startup.
Install Oracle Grid Infrastructure for Automatic Storage Management (ASM). DBCA (Database Configuration Assistant) Steps Launch dbca from the command line interface. Select advanced configuration options. Choose Deployment Type as Multitenant architecture. Specify PDB creation naming conventions and counts. Select ASM disk groups for automated storage allocation.
+-------------------------------------------------------+ | Tablespace | | +-------------------------------------------------+ | | | Segment | | | | +-------------------------------------------+ | | | | | Extents | | | | | | [Data Block] [Data Block] [Data Block] | | | | | +-------------------------------------------+ | | | +-------------------------------------------------+ | +-------------------------------------------------------+ | v +-------------------------------------------------------+ | Physical Layer | | [Data File 1] [Data File 2] | +-------------------------------------------------------+ Storage Hierarchy managing password profiles
If you're ready to start your journey, you can explore the official learning paths on Oracle University or look for structured training through partners like CLC Training . Course : Oracle Database 19c: Administration Workshop
Data inside an Oracle database is organized logically into tablespaces and physically into data files.
Moving, cloning, plugging, and unplugging PDBs between different container databases to simplify consolidation and cloud migration. Backup, Recovery, and Performance Tuning Basics