Oracle 9i new features for Oracle DBAs

Concentrika poppy

About the course
This course introduces students to the new features in Oracle9i that impact database administration. You will learn how to use Oracle9i capabilities to increase database availability, to simplify database performance monitoring and tuning, and to improve database manageability. The course also covers security changes that students need to understand if .
The course is essentially hands-on and you will expect to acquire a range of skills that will be immediately useful in the work place.

Prerequisites
The course is designed for experienced Oracle version 8 or version 7 database administrators.

Duration

2 days

1. Database administration and administration	Datafiles Shared memory UNDO management Resumable space management Parallelisation Internal and server manager replacements Parameter changes Data dictionary changes Graphical user interface for database management
2. Data management	Datafiles Shared memory UNDO management Resumable space management Parallelisation Internal and server manager replacements Parameter changes Data dictionary changes Graphical user interface for database management
3. Availability and recovery	Flashback query Instance failure recovery RMAN Data guard Log miner Trial recovery
4. Managing large datasets	List partitioning Constraints External tables Parallel direct loads
5. Security	Labels Virtual private database DBMS_OBFUSCATION Advanced replication
6. Performance management	Optimizer Cached execution plans New dynamic performance views