Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.
|
Course Outline Introduction - Oracle 10g and Grid Computing
- Database Features
Automatic Shared Memory Management - Manual Memory Allocation
- Setting up Automatic Shared Memory Management
- Non-dynamic SGA Buffers
Tablespace Management - Default Permanent Tablespace
- Rename Tablespace
- SYSAUX Tablespace
Scheduler - Programs
- Schedules
- Jobs
- Job Classes
- Windows
- Data Dictionary Views
Space Management - Segment Advisor
- Improved Segment Size Estimation
- Shrinking Segments
- Undo Advisor
- Automatic Undo Retention Tuning
Improved VLDB Support - Bigfile Tablespaces
- Temporary Tablespace Groups
- Partitioning Enhancements and Index Organized Tables
- Unusable Indexes
- Hash partitioned global indexes
Automated Storage Management - Features
- ASM instances and database instances
- SM Disk groups
- ASM Files
- Data dictionary Views
Security Enhancements - Virtual Private Database Enhancements
- Uniform Audit Trail
- DBMS_CRYPTO
Utilities - Export, Import and Data Pump
- Directories and files
- Example of a Data Pump Job
- Command Line Interactive Jobs
- Object selection
- Data Pump Features
- Data Pump API
- External Tables
- Cross-Platform Transportable Tablespaces
Automatic Workload Repository (AWR) - AWR Features
- Automatic Statistics Collection
- Baselines
- Workload Repository Views
- AWR Reporting
- Feature Usage Metrics
- Active Session History (ASH)
Automatic Database Diagnostic Monitor (ADDM) - Features
- ADDM Reporting
- Server Alerts
- Related Views
- SQL Tuning Advisor
- SQL Tuning Advisor Features
Miscellaneous Tuning Features - Buffer cache flushing
- Optimizer Changes
- Gathering Data Dictionary Statistics
Flashback - Flashback Features
- Enabling Flashback
- Flashback Query
- Additional Query Functions
- Flashback Version Query
- Flashback Transaction Query
- Flashback Table
- Flashback Drop (Recycle Bin)
- Flashback Database
RMAN Enhancements - Flash Recovery Area
- Fast Incremental Backups
- Using Image Copies with Incremental Backups
- Image Copies and the BACKUP Command
- Catalog Maintenance
- Automatic Instance Creation for RMAN TSPITR
- Global Stored Scripts
- Backupset Compression
- Restore Preview
- Limiting Backup Duration
- More Robust Backup and Restore
How to make a booking for the OD10-NF2 course
|
