(703)246-9100 Northern Virginia
(804)285-5830 Central Virginia
(757)420-3810 Tidewater Area
(800)294-7497 Toll Free
(804)285-3722 Fax
|
(703)246-9100 Northern Virginia (804)285-5830 Central Virginia (757)420-3810 Tidewater Area (800)294-7497 Toll Free (804)285-3722 Fax |
ORACLE8i DBA II - FAST TRACK
Duration: 5 days
Develop the advanced skills to effectively administer an Oracle Server Database
Course Description:
This course prepares students for administering an Oracle8i Server Database. The course covers the advanced options of the Oracle8i Server architecture, managing system resources and tuning the Oracle8i database.
Participants will learn…
How to administer an Oracle8i Server database
To take full advantage of the features of the Oracle8i Server
To configure and tune the database
How to do backup and recovery
To configure networking
Who Needs to Attend:
Application Developers and Designers, Managers, Database Administrators, Systems Administrators, Network Managers and Technical Support Personnel
Prerequisites:
Oracle Foundation Classes, Oracle DBA I or equivalent experience is required
NOTE: As this course is combination of several courses, for more detail please see the individual outlines:
PERFORMANCE and TUNING for DBA’s, BACKUP and RECOVERY and NETWORKING for DBA’s.
Course Content:
PERFORMANCE and TUNING
Duties of the DBA
SQL statement processing
Introduction to database tuning
Advanced performance design
PL/SQL support and packages for the DBA
Day in the life of a DBA
BACKUP and RECOVERY
Duties of the DBA
Introduction to backup and recovery
Backup and recovery
Export and Import
Advanced recovery (incomplete recovery
PL/SQL support and packages for the DBA
Day in the life of a DBA
NETWORKING
Duties of the DBA
Networking connectivity
Oracle snapshot refresh process using AQ and database links
Advanced Oracle Enterprise Manager (OEM)
PL/SQL support and packages for the DBA
Day in the life of a DBA
Course Labs:
Tuning Tables and Indexes
Tuning Using STATSPACK
Tuning Memory
Tuning Contention
NOARCHIVELOG mode
ARCHIVELOG mode
Complete Recovery
Incomplete recovery
Export then Import
Log Miner
Lab RMAN
Configure Net8 Client
Configure Net8 Listener
Configure Network
Implement MTS