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
