Installation
Installation New Feature Support
Performance Enhancements to Installation
Checking the Pre-Install Requirements
Management, File Storage, and Backup and Recovery Options
Passwords
Info about installation directories for the DB and EM
Grid control architectures and installation
Distinction between Grid Control and Database Control
Server Configuration
SYSAUX and DBCA
Using Enterprise Manager: - Command line interfaces: emctl/emca
Database Cloning
Database Feature Usage
Managing Policies
Response File Improvements
Policy Framework
Blackouts
Data Pump, SQL*Loader, and External Tables
Data Pump: General Architecture
Data Pump Direct Path Considerations
Data Pump Utility: Interfaces and Modes
Data Pump Job Monitoring Views
Data Pump Import Transformations
Using EM to Monitor Data Pump Jobs
Loading Data From Flat Files Using EM
External Table Parallel Populate Operation
Database and Tablespace Data Movements
Cross-Platform Transportable Tablespaces
Minimum Compatibility Level
Transportable Tablespace Procedure
Dynamic Performance View Changes
Using Enterprise Manager to Transport Tablespaces
Transportable Database
Transport Tablespace From Backup
Tablespace Repository
Automatic Management
Automatic Database Diagnostic Monitor
Retrieving ADDM Reports Using SQL and EM
Automatic Shared Memory Management (including streams pool)
SGA Advisor
Automatic Optimizer Statistics Collection
Locking Statistics
Automatic Undo Retention Tuning
Automatically Tuned Multiblock Reads
Manageability Infrastructure
Automatic Workload Repository Data
Active Session History
AWR Snapshot Baselines and Purging Policy
Server-Generated Alerts
Metric and Alert Views
Job Scheduler Concepts
DBCA and Automated Tasks
Dictionary Changes
Managing Metric Baselines
The Cyclic Nature of Workloads
Thresholds and Metric Baselines
Enable Metric Baselining
Set Adaptive Alert Thresholds
Create Static Metric Baselines
Metric Baseline and Adaptive Threshold Considerations
Classification of Eligible Metrics
Configure Normalization Metrics
Application Tuning
Automatic Statistics Gathering
Enhanced Query Optimization
Using Enterprise Manager to Gather Dictionary Statistics
Automatic SQL Tuning
SQL Tuning Loop
SQL Tuning Advisor
Concurrency Wait Class: Drill Down
Duplicate SQL page
System Resource Management
Database Resource Manager
Setting Idle Timeouts
Switching Back to the Initial Consumer Group at End of Call
Creating a Mapping Using Database Control
Using the RATIO Allocation Method
Monitoring the Resource Manager Using EM
Switching Plans at Scheduler Window Boundaries
Automating Tasks with the Scheduler
Privileges for Scheduler Components
Creating a Scheduler Job
Creating a Job Class
Creating a Window
Managing Jobs, Programs, Schedules, Windows, and Priority
Job chains
Using events
Space Management
Tablespace Space Usage Monitoring
Shrinking Segments
Automatic Segment Advisor
Fast Ramp-Up
Sorted Hash Cluster
Segment Metadata Dump and Verification
Improved VLDB Support
Create and maintain bigfile tablespaces
Interpret ROWIDs referencing bigfile tablespaces
Create temporary tablespace groups
Create list-partitioned index-organized tables
Create hash-partitioned global indexes
Partitioned IOT Enhancements
Skipping Unusable Indexes
Bitmap Index Storage Enhancements
Backup and Recovery Enhancements
New Backup and Recovery Strategy
Flash Backup and Recovery
Best Practices for the Database and Flash Recovery Area
Backup Maintenance
Implementing Fast Recovery
Automated Instance Creation and TSPITR
RMAN Command Changes
Setting Duration and Throttling Option
Oracle Backup
Installation
Implement the Oracle suggested strategy
RMAN and Oracle Backup
Database Backup/restore to tape
Install Oracle Backup (CLI)
Flashback Any Error
Flashback Database
Flashback Drop
Recycle Bin
Resource optimized DROP TABLE...PURGE for partitioned tables
Flashback Versions Query
Guaranteed Undo Retention
SCN and Time Mapping Enhancements
Restore Point Usage
General Storage Enhancements
SYSAUX Tablespace and Occupants
Tablespace Rename
Default Permanent Tablespace
Designating a Default Permanent Tablespace
Copying Files Using the Database Server
Redo Logfile Size Advisor
Dropping an Empty Data File
Automatic Storage Management
ASM: Key Features and Benefits
ASM Instance Creation
Accessing an ASM Instance
Starting Up and Shutting Down an ASM Instance
ASM Disk Group
ASM Files
Migrate Your Database to ASM
ASM and XML DB
Maintaining Software
Oracle Database 10g Upgrade Paths
Pre-Upgrade Utility Enhancements
DBUA Advantages
New Post-Upgrade Status Utility
Recompiling Invalid Objects
Performing the Manual Upgrade
OPatch Utility
Support for ASM only upgrade
Security
Virtual Private Database enhancements
Policy Types
Enhanced Enterprise User Auditing
Transparent Data Encryption
Enhanced Proxy Capabilities
Username and Password in Wallet
OS Audit in XML format
Connect role change
Services
Traditional Workload Dispatching
Grid Workload Dispatching
High Availability of Services in RAC
Service Aggregation and Tracing
The trcsess Utility
Session-Based and End-to-End Tracing
Using Enterprise Manager to Enable Statistics Aggregation
Using Enterprise Manager to Enable and View SQL Tracing
Miscellaneous New Features
Transaction Monitoring
Configurationless Client Connect
Resumable Space Allocation Enhancements
Implicit Conversion Between CLOB and NCLOB
UTL_MAIL and UTL_COMPRESS Package
LogMiner Enhancements
Asynchronous COMMIT
Direct Attach to SGA for Statistic Collection
Oracle DBA Course - 3
