Profile
e-Catalog
Contact
Search
Cart
|
Profile |
|
Contact |
Search |
Cart |
 |
Oracle8i Database Administration: Exploring the Database Structure |
| Course Status: | Released |
| Course Language: | English |
| Course Duration: | 3 Hours |
| Deployment Options: | Online, Interactive CDs, Network, Downloads, Intranet |
| Audience |
| Database administrators |
| Prerequisites |
| Completion of the Oracle Introduction curriculum |
| Course Aim |
| To introduce the data dictionary and to discuss the maintenance issues associated with redo log files and control files |
| Learning Objectives |
| Describe the structure and purpose of the data dictionary. Identify standard administrative scripts. Distinguish between triggers, functions, procedures, and packages. Explain the use of the control file. Discuss the purpose of online redo log files. Maintain control files and redo log files. Demonstrate the use of the LogMiner utility. |
| Topics Covered |
| The data dictionary - Structure of the data dictionary - Program units - Triggers - Administrative scripts The control file - Maintaining the control file - Managing the control file - Hands-on: Multiplexing a control file Using redo log files - Log groups and members - Log switches and checkpoints - Obtaining information Redo log file maintenance - Maintaining members and groups - LogMiner - Hands-on: Using LogMiner |