Oracle 10g New Features for Administrators Training Course – ORA512
This class will introduce the experienced Oracle DBA to the new features contained in Oracle Database 10g. As students are introduced to the various new features, labs will reinforce the material presented in this course. Once this Oracle course is completed, the student will have gained the foundational knowledge to begin to administer Oracle 10g databases.
Oracle 10g New Features for Administrators Training Course – ORA512 Request a Class Date
This class will introduce the experienced Oracle DBA to the new features contained in Oracle Database 10g. As students are introduced to the various new features, labs will reinforce the material presented in this course. Once this Oracle course is completed, the student will have gained the foundational knowledge to begin to administer Oracle 10g databases.
Course ID: ORA512
Duration: 5 days
Audience: Database administrators, application developers, and system administrators.
Topics Learned in Oracle 10g New Features for Administrators Course:
- The Different Editions of Oracle Database 10g
- Oracle Database Installation New Features
- The SYSAUX Tablespace
- 10g Upgrade Paths and Methods
- Database Upgrade Assistant (DBUA)
- Manual Upgrade
- Preparing to Upgrade to Oracle10g
- Rolling Back to a Previous Version
- Steps to Roll Back
Database Extraction and Loading New Features
- Cross-Platform Transportable Tablespaces
- Transporting a Tablespace Between Platforms
- Converting the Byte Format
- New Oracle Database External Table Features
- External Table Creation in Parallel
- The Oracle Data Pump Architecture
- Configuring the Database to Use Data Pump
- Using the expdp and impdp Tools
- Import and Export Via the Oracle Data Pump
- Using Interactive Mode
Tuning and Management
- Basic Initialization Parameters
- Automatic Shared Memory Management
- Configuring Automatic Shared Memory
- FLUSHING the Buffer Cache
- New 10.2 Tuning and Management Features
- Automatic Statistics Collection
- Automatic Undo Management and Tuning
- Guaranteed Undo Retention
- Automatic Checkpoint Tuning
- Using the DBMS_SQLTUNE Package
- SQL Trace and DBMS_MONITOR
Oracle10g Advisor Framework and Advisors
- The Advisor Framework
- Automatic Workload Repository
- Managing AWR
- Automatic Database Diagnostic Monitor
- SQL Tuning Advisor
- SQL Access Advisor
- Segment Advisor
- Undo Advisor
OEM: The Database Control
- Introducing Oracle Enterprise Manager
- Oracle Database Control Home Page
- Starting and Using Database Control
- Database Control Performance Page
- Administration and Maintenance Home Pages
- Determine Which Database Features are in Use
- MMON
- Configuring Server-Generated and Threshold-Generated Alerts
- Automating Routine Administrative Tasks
- Default User Tablespaces
- Rename Tablespaces
- Temporary Tablespace Groups
- Bigfile Tablespaces
- Dropping Empty Datafiles
- Drop Database Command
- Shared Server Changes
New Segment Features
- New Table Monitoring Behaviors
- Hash-Partitioned Global Indexes
- Skipping Unusable Indexes
- New Partitioned Index Management Features
- Sorted Hash Clusters
- Shrinking Segments Online
- Estimating Segment Resource Requirements
- Materialized Views
New Security Features
- Fine-Grained Auditing
- Virtual Private Database
- Column-Level VPD
- Column-Level VPD Example
- The DBMS_ CRYPTO Package
- Transparent Data Encryption
Availability and Recovery – RMAN
- Introducing the Flash Recovery Area
- Configuring and Managing the Flash Recovery Area
- RMAN Flash Backup and Recovery
- RMAN Backup Compression
- DROP DATABASE and UNREGISTER DATABASE
- CATALOG and UNCATALOG Commands
- Other RMAN New Features
Availability and Recovery – Flashback Database
- Incremental Backup Changes
- Flashback Database
- FLASHBACK TABLE
- Flashback Drop
- Flashback Versions
- Flashback Transactions
- Simplified Recovery Through Resetlogs
The Scheduler
- Scheduler – Introduction
- Architecture of the Scheduler
- Job Class and Windows
- Privileges Needed for Scheduler Components
- Creating Jobs, Programs, and Schedules<