The eLearning Center for Gatlin Education Services

This study guide will prepare you to take one of the two required Oracle9i tests to be certified as an Oracle Certified Professional, Oracle9i Database Administrator. Questions are presented in the same style and cover the same topics as the actual exam. Students will test their knowledge, then receive comprehensive information about the question topic and the possible answers that were presented. This series has more courses coming soon. Please check back later for even more information on this topic.

1. Performance Tuning Overview
Time: 1 hours
This course provides an overview of Oracle9i performance tuning, with an emphasis on job roles, problems, and considerations. It also discusses tuning during development phases, as well as performance and safety tradeoffs.
Objectives

• Define job roles in relation to Oracle9i database tuning
• Describe tuning during development phases
• Describe Service Level Agreements (SLAs)
• List appropriate tuning goals
• Describe common tuning problems
• Describe tuning considerations during development and production
• Identify performance and safety tradeoffs

2. Sizing the Buffer Cache
Time: 1 hours
This course discusses issues related to using the buffer cache, which holds blocks of memory while Oracle processes perform operations on them.
Objectives

• Use the buffer cache
• Identify tuning issues with the buffer cache
• Monitor buffer cache usage
• Describe table caching
• Describe latch and freelist contention

3. Sizing Other SGA Structures
Time: 1 hours
This course discusses System Global Area (SGA) structures, such as the redo log buffer, the Java pool, and the Java session memory. It also examines other topics, such as I/O slaves and database writer processors.
Objectives

• Size the redo log buffer
• Size the Java pool
• Control Java session memory
• Configure I/O slaves
• Configure multiple database writer (DBWn) processors

4. Monitoring and Detecting Lock Contention
Time: 1 hours
This course discusses lock contention strategies and how to handle problems and errors that arise from locking.
Objectives

• Describe the levels of locking
• Describe the causes of contention
• Detect locking contention
• Resolve contention
• Prevent locking problems
• Identify Oracle errors that arise from deadlocks

5. Using Oracle Blocks Efficiently
Time: 1 hours
This course discusses the performance implications of space management, and how the use of blocks can make a difference in space management.
Objectives

• Describe extents and Oracle blocks
• Describe space usage and the high water mark
• Determine the high water mark
• Recover space from sparsely populated segments
• Describe chaining and migration of Oracle blocks
• Describe index migration
• Monitor indexes

6. Diagnostic and Tuning Tools
Time: 1 hours
This course discusses the tools used for performance tuning and diagnostics, such as the Alert Log file, trace files, dictionary and dynamic performance views, and the Statspack.
Objectives

• Discuss the Alert Log file
• Describe background trace files and user trace files
• Describe dictionary views and dynamic performance views
• Describe the aspects of the Statistics Package (Statspack)

7. Database Configuration and I/O Issues
Time: 1 hours
This course discusses how to configure the Oracle9i database and balance input/output (I/O) in order to prevent contention.
Objectives

• Distribute files across devices
• Describe tablespace usage and detect improper tablespace usage
• Describe how checkpoints work
• Monitor and tune checkpoints and redo logs

8. Optimizing Sort Operations
Time: 1 hours
This course discusses various methods of using and tuning sort operations in the Oracle9i Database, with an emphasis on the sorting process and sort area parameters.
Objectives

• Describe the sorting process and sort area parameters
• Describe tuning sort operations and operations that cause sorting
• Create and monitor temporary tablespaces
• Reduce sort operations

9. Tuning Oracle Shared Server
Time: 1 hours
This course discusses the Oracle Shared Server environment, which allows for multiple user processes to share a limited number of server processes.
Objectives

• Identify issues associated with managing users in a shared server environment
• Diagnose and resolve performance issues with Oracle Shared Server processes
• Configure the Oracle Shared Server environment to optimize performance

10. Application Tuning
Time: 1 hours
This course discusses the Oracle9i Database Administrator's involvement in application tuning, with an emphasis on stored structures, indexes, materialized views, and query rewrites.
Objectives

• Identify the role of a Database Administrator in tuning applications
• Describe storage structures
• Describe indexes and index organized tables
• Describe materialized views and query rewrites
• Tune OLTP, DSS, and hybrid systems

11. SQL Statement Tuning
Time: 1 hours
This course discusses various tools that Oracle Database Administrators can use to tune SQL statements.
Objectives

• Describe how the Optimizer is used
• Plan stability
• Describe stored outlines
• Use SQL trace and TKPROF
• Collect statistics
• Describe histograms
• Copy statistics between databases

12. Sizing the Shared Pool
Time: 1 hours
This course discusses how Oracle9i Database Administrators can adequately size the shared pool in order to cache and reload SQL, PL/SQL, and data dictionary information.
Objectives

• Describe the shared pool
• Describe library cache tuning
• Describe reuse statements
• Use reserved space
• Describe keeping large objects
• Describe data dictionary cache tuning

13. Diagnosing Contention for Latches
Time: 1 hours
This course discusses the use of latches, which are locking mechanisms that serialize access to shared data structures and shared memory allocations in the System Global Area (SGA).
Objectives

• Describe the purpose of latches
• Describe latch request types
• Diagnose latch contention
• Tune resources

14. Tuning the Operating System and Using Resource Manager
Time: 1 hours
This course discusses the similar responsibilities of Database Administrators and System Administrators, as well as their relation to tuning an Operating System (OS).
Objectives

• Describe different system architectures
• Identify the primary steps of OS tuning
• Describe paging and swapping
• Describe CPU tuning guidelines
• Distinguish process and threads
• Use the Resource Manager

15. Practice Exam 1
Time: 1 hours
This course presents questions that will help you prepare for the Oracle9i Database Performance Tuning 1Z0-033 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Objectives

• Complete the practice exam questions

Topics

• Practice exam

16. Practice Exam 2
Time: 1 hours
This course presents questions that will help you prepare for the Oracle9i Database Performance Tuning 1Z0-033 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Objectives

• Complete the practice exam questions

Topics

• Practice exam

17. Practice Exam 3
Time: 1 hours
This course presents questions that will help you prepare for the Oracle9i Database Performance Tuning 1Z0-033 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Objectives

• Complete the practice exam questions

Topics

• Practice exam

18. Practice Exam 4
Time: 1 hours
This course presents questions that will help you prepare for the Oracle9i Database Performance Tuning 1Z0-033 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.