 |
9i DBA Fundamentals |
 |
Oracle9i Database Administration Fundamentals I |
 |
Oracle9i Database Administration Fundamentals II |
 |
Oracle9i Database: New Features for Administrators |
COURSE OBJECTIVES |
 |
Using Database Control to simplify database management |
 |
Proactively monitoring the database |
 |
Increasing data availability by using improved point in time recovery features |
 |
Implementing Automatic Storage Management |
 |
Managing Metric Baselines |
 |
Using Oracle Secure Backup |
 |
Simplifying Instance Configuration |
 |
Using Data Pump Export and Import |
 |
Configuring the Scheduler |
 |
Using the Automatic Workload Repository |
 |
Managing Services |
 |
Creating Bigfile Tablespaces |
 |
Creating Hash-Partitioned Global Indexes |
 |
Creating Compressed Backup sets in RMAN |
 |
Configuring Flashback Database |
 |
Creating the SYSAUX Tablespace |
COURSE CONTENTS |
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 |
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 |