Tuning workshop

Small shared pool Small database buffer cache Small redo log buffer cache Missing indexes Rollback segments and undo tablespace Sort area size incorrectly set Assorted

16p trinh02 28-01-2013 57 6   Download

After completing this lesson, you should be able to do the following: Use the Oracle tuning methodology to diagnose and resolve performance problems Use Oracle tools to diagnose performance problems Understand the goals of the workshop

14p trinh02 28-01-2013 72 5   Download

This workshop covers: Creating tables and sequences Modifying data in the tables Modifying table definitions Creating views Writing scripts containing SQL and iSQL*Plus commands Generating a simple report

14p trinh02 28-01-2013 74 4   Download

Workshop Methodology Group-Oriented and Interactive Structure The workshop is structured to allow individuals to work in groups to perform database backup, restore, and recovery operations. Each group is encouraged to share its approach to resolving database failures with other groups in the class. Intensive Hands-On Diagnosis and Problem Resolution The intent is to provide you with as much hands-on experience as possible to diagnose and work through backup and recovery scenarios.

18p trinh02 28-01-2013 73 3   Download