|
Provided by: 123-CBT Computer Based Training Oracle8i Performance Tuning Managing Memory Disk I O |
 |
Course Overview
This course is the second in a three-part Oracle8i Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log buffer. Finally, participants will identify database configuration and I/O issues, including tablespace usage and guidelines.
Learn To:
- Identify application tuning issues that will impact database performance.
- Identify the contents and functions of the shared pool.
- Identify how the Buffer Cache is managed and tuned.
- Learn how to tune the Redo Log Buffer.
- Learn about database configuration and I/O issues.
Content Emphasis
Skills-Based
Audience
Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and Oracle8i Performance Tuning: Strategies and Techniques (63331). This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA) Track Exam 4, 1Z0-024.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Tuning SQL
Duration: 1.5 - 2 Hour(s)- Explain the plan for a query by using the EXPLAIN PLAN statement.
- Inspect the performance of a plan by setting up trace at the session level.
- Match the TKPROF options with their respective descriptions.
- Generate an execution plan at the system level for a SQL statement by using AUTOTRACE.
- Identify the characteristics of optimizer modes.
- Set the optimizer mode at the session level by using the OPTIMIZER_MODE parameter.
Unit 2: Tuning the Shared Pool
Duration: 1.5 - 2 Hour(s)- Select the contents of the library cache.
- Identify the contents of the data dictionary cache.
- Select the functions of the Multithreaded Server Connection.
- Identify the goals for tuning the library cache.
- View the sizes of all SGA structures by using the V$SGASTAT view.
- Determine the percentage of parse calls that find a cursor to share by using the GETHITRATIO column of the V$LIBRARYCACHE view.
- Determine the reloads-to-pins ratio by using the V$LIBRARYCACHE view.
- Compute the amount of sharable memory that has been used by using the V$SQLAREA view.
- Keep a large object in memory by using the KEEP procedure of the DBMS_SHARED_POOL package.
- View the reserved pool space within the shared pool by using the V$SHARED_POOL_RESERVED view.
- Identify the actions for tuning the shared pool reserved space.
- Compute the amount of space used for a test connection in the user global area.
- Match the columns found in the V$ROWCACHE view with their definitions.
- Find the ratio of GETSMISSES to GETS from the V$ROWCACHE view.
- Select the features of configuring the large pool as a separate memory area.
- Determine the size of the free memory allocated to the large pool.
- Determine why the server could not allocate the required memory for the large pool.
Unit 3: Tuning the Database Buffer Cache
Duration: 1 - 2 Hour(s)- Identify the characteristics of the buffer cache.
- Sequence the five steps that the server process performs when managing the buffer cache.
- Identify the events that cause DBWn to write dirty blocks.
- Select the tuning techniques used to improve the performance of the buffer cache.
- Identify the dynamic performance views used to
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
