Database Structures in Oracle9i

Overview/Description
To describe how to use an Oracle9i database data dictionary, the control files, and the redo log files

Target Audience


Anyone wanting to learn about Oracle9i database administration

Prerequisites


An understanding of database concepts and technologies

Expected Duration


140 Minutes

Objectives :

Database Structures in Oracle9i

  • describe the contents of an Oracle9i database data dictionary and explain how to use it.
  • query an Oracle 9i database data dictionary to access information about an underlying database.
  • describe the purpose and content of an Oracle9i database control file and explain how to manage it.
  • multiplex an Oracle 9i database control file using the SPFILE.
  • describe the structure of the Oracle9i database redo log files and explain how they work and how to archive them.
  • describe how to manage redo log groups and members and how to obtain information about them.
  • add a new multiplexed log file to an Oracle9i database.


    • Course Number: 58271_eng