Overview/Description To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces Target Audience Anyone wanting to learn about Oracle Database 10g database administration Prerequisites An understanding of database concepts and technologies Expected Duration (hours) 3.0 Lesson ObjectivesOracle Database 10g: Database Interfaces Release 2 identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus. recognize how to use the DESCRIBE, PROMPT, and SELECT commands to work with data. recognize how to...

Overview/Description To discuss how to manage backup and recovery in an Oracle 10g database Target Audience Anyone wanting to learn about Oracle Database 10g database administration Prerequisites An understanding of database concepts and technologies Expected Duration (hours) 4.0 Lesson ObjectivesOracle Database 10g: Managing Backup and Recovery Release 2 recognize the types of database failure that can occur in an Oracle 10g database and identify possible solutions. recognize how to tune instance recovery and configure a database for maximum recoverability. recognize how to multiplex the...

Overview/Description To discuss how to manage undo data and manage lock conflicts in an Oracle database Target Audience Anyone wanting to learn about Oracle Database 10g database administration Prerequisites An understanding of database concepts and technologies Expected Duration (hours) 1.8 Lesson ObjectivesOracle Database 10g: Managing Undo Data and Lock Conflicts Release 2 identify factors to take into consideration when managing undo. recognize how to estimate required tablespace size and resize a tablespace in a given scenario. calculate undo tablespace sizing and resize an undo...

Overview/Description To demonstrate how to control database performance and configure proactive database maintenance Target Audience Anyone wanting to learn about Oracle Database 10g database administration Prerequisites An understanding of database concepts and technologies Expected Duration (hours) 2.7 Lesson ObjectivesOracle Database 10g: Monitoring and Maintenance Release 2 repair invalid and unusable objects. detect and repair unusable indexes. recognize how to monitor performance using dynamic performance views, Enterprise Manager, and optimizer statistics. gather optimizer statistics...