Using Globalization Support
- Date times with Time zones
- Specifying Language-Dependent Behavior
- Locale Variants
- Linguistic Sorting
- Case and Accent Insensitive Sorts
- Linguistic Comparisons
- Obtaining Information about the Current NLS Configuration
Securing the Oracle Listener
- Listener Password Authentication
- Controlling Database Access
- Securing the EXTPROC Service Entry
Configuring Recovery Manager
- Using a Flash Recovery Area with RMAN
- Setting Parameters for RMAN
- Starting RMAN
- Configuring Persistent Settings for RMAN
- Control File Auto backups
- Retention Policies
Using Recovery Manager
- Issuing Recovery Manager Commands
- Parallelization of Backup Sets
- Compressed Backups
- Copying the Whole Database
- Making Incremental Backups
- Block Change Tracking
- Incrementally Updating Backups
- Monitoring RMAN Backups
Diagnostic Sources
- The Alert Log
- Viewing Alerts with EM
- Alerts Notification
- Editing Thresholds
- Trace Files
Recovering from non-critical losses
- Creating New Temporary Tablespace
- Recreating Redo Log Files
- Recovering an Index Tablespace
- Read-Only Tablespace Recovery
- Loss of Password Authentication File
Database Recovery
- Recovery Steps
- User-Managed Recovery Procedures: RECOVER Command
- Types of incomplete recovery
- Incomplete Recovery Best Practices
- Recovery Using EM
- Simple Recovery Through RESETLOGS
- Point-in-time recovery using RMAN
Flashback database
- When to Use Flashback Technology
- Configuring Flashback Database
- Monitoring Flashback Database
- Best Practices for the Database and Flash Recovery Area
- Flash Recovery Area Space Usage
- Flashback Database Examples
Recovering from User Errors
- Recycle Bin
- Flashback Dropped Tables Using EM
- Querying Dropped Tables
- Flashback Versions Query
- Flashback Transaction Query
- Using Flashback Versions Query and Flashback Transaction Query
- Flashback Table
- Using EM To Flashback Tables
Dealing with Database Corruption
- What is block corruption?
- Interpreting DBVERIFY
- The ANALYZE command
- How to Handle Corruptions
- The DBMS_REPAIR Package
- Block Media Recovery (BMR)
- Detecting Database Corruptions Using DBVERIFY
- Using RMAN to Repair Corrupt Blocks
Automatic Database Management
- Automatic Optimizer Statistics Collection
- Workload Repository
- Database Control and Advisors
- Using the SQL Tuning Advisor
- Using the SQL Access Advisor
- Automatic Undo Retention Tuning
Monitoring and Managing Storage
- Redo Log file Size Advisor
- Resumable Statements
- Tablespace Space Usage Monitoring
- Accessing the Segment Advisor
- Shrinking Segments Using SQL
- Segment Resource Estimation
- Monitoring Index Space
- Identifying Unused Indexes
Automatic Storage Management
- ASM Concepts
- ASM General Architecture
- Creating an ASM instance
- Creating tablespaces that use ASM storage
- Viewing ASM information
- Migrating a tablespace to use ASM storage
Monitoring and Managing Memory
- Oracle Memory Structures
- Automatic PGA Memory Management
- Using the Memory Advisor
- Using Automatic Shared Memory Management to avoid long running query issues
Managing Resources
- Creating a New Resource Plan
- Creating Resource Consumer Groups
- Assigning Users to Resource Consumer Groups
- Adaptive Consumer Group Mapping
- Using Sub-Plans to limit CPU Utilization
- Administering the Resource Manager
- Resource Plan Directives
Automating Tasks with the Scheduler
- Creating a Scheduler Job
- Using Scheduler Programs
- Creating and Using Schedules
- Creating a Job Class
- Prioritizing Jobs within a Window
- Viewing Job Execution Details
- Creating a job that runs a program outside of the database