Course Outline
- Overview of Oracle Database 12
Configuring the instance and database
- Balancing user requirements and resources
- Ensuring database availability
Conceptualizing the Oracle 12c architecture
- Processing transactions with the Oracle 12c server
- Identifying types of processes, memory structures and files
- Constructing an Oracle 12
Creating the database
- Automating memory allocation with memory targets
- Establishing network connectivity
- Setting up control files and online redo log files
Starting and stopping the database
- Mounting and opening the database
- Authenticating connections having SYSDBA privilege
- Automating administration with Oracle Enterprise Manager (OEM) Cloud Control 12
Evaluating the OEM architecture
- Navigating the graphical interface
- Comparing command-line and graphical techniques
Maintaining the database with OEM Cloud Control 12c
- Setting thresholds and generating alerts
- Managing privileges and roles
- Evaluating container and pluggable databases
- Flashing Back Oracle 12
Configuring UNDO tablespaces
- Setting UNDO retention targets
- Switching to an alternative UNDO tablespace
Monitoring and reversing changes to data
- Tracking changes to data values with row history
- Backing out user errors with Flashback Table
- Retrieving dropped tables from the recycle bin
- Implementing the Valid Time support feature
- Managing Users and Resources
Establishing user accounts
- Authenticating users with Oracle 12c password validation
- Allocating space quotas and limiting resource usage
Enforcing security
- Granting and revoking system and object privileges
- Simplifying privilege management with roles
- Capturing the use of privileges with dbms_privilege_capture
- Performing Space Management
Building the storage hierarchy
- Configuring tablespaces and datafiles
- Handling sort data with temporary tablespaces
- Creating Oracle Managed Files
Structuring data and index segments
- Managing extents, blocks and large objects (LOB) storage
- Eliminating row migration with PCTFREE and Data Pump
- Conserving storage by compressing table data
- Regaining space by shrinking tables and indexes online
- Partitioning for Performance and Administration
Creating partitioned and subpartitioned tables
- Evaluating range, list and hash partitioning methods
- Administering partitions with merge, split, add and drop
- Deploying partitioned tables based on virtual columns and referenced tables
Maintaining index partitions
- Comparing the performance and maintenance of local and global indexes
- Monitoring index partitions and rebuilding unusable indexes
- Limiting indexing of partitions with partial indexing
- Building a Fault-Tolerant Database
Safeguarding the database
- Role of the redo log and control file
- Ensuring recovery using archiving
- Protecting and tracing the control file
Backing up the database and performing recovery
- Implementing user-managed hot and cold backups
- Restoring and recovering the entire database
- Recovering corrupted tablespaces
- Managing logical errors with flashback transaction back out