Oracle9i Database Performance Tuning 1Z0-033 - Online Course

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. Practice exams are also included, which will allow you to answer questions in the same format that the test will use on exam day, and will provide in-depth instructional feedback on each question to thoroughly cover every subject you'll need to master.

This series is for anyone who wants to achieve Oracle9i 1Z0-033 certification. This online course contains 14 lessons and 4 practice exams and should take approximately 18 hours to complete.

Lesson 1: Performance Tuning Overview (1.0) hour

Performance Tuning Overview teaches you how to 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, and identify performance and safety tradeoffs. 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.

Lesson 2: Sizing the Buffer Cache (1.0) hour

Sizing the Buffer Cache teaches you how to use the buffer cache, identify tuning issues with the buffer cache, monitor buffer cache usage, describe table caching, and describe latch and freelist contention. This course discusses issues related to using the buffer cache, which holds blocks of memory while Oracle processes perform operations on them.

Lesson 3: Sizing Other SGA Structures (1.0) hour

Sizing Other SGA Structures teaches you how to size the redo log buffer, size the Java pool, control Java session memory, configure I/O slaves, and configure multiple database writer (DBWn) processors. 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.

Lesson 4: Monitoring and Detecting Lock Contention (1.0) hour

Monitoring and Detecting Lock Contention teaches you how to describe the levels of locking, describe the causes of contention, detect locking contention, resolve contention, prevent locking problems, and identify Oracle errors that arise from deadlocks. This course discusses lock contention strategies and how to handle problems and errors that arise from locking.

Lesson 5: Using Oracle Blocks Efficiently (1.0) hour

Using Oracle Blocks Efficiently teaches you how to 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, and monitor indexes. This course discusses the performance implications of space management, and how the use of blocks can make a difference in space management.

Lesson 6: Diagnostic and Tuning Tools (1.0) hour

Diagnostic and Tuning Tools teaches you how to discuss the Alert Log file, describe background trace files and user trace files, describe dictionary views and dynamic performance views, and describe the aspects of the Statistics Package (Statspack). 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.

Lesson 7: Database Configuration and I/O Issues (1.0) hour

Database Configuration and I/O Issues teaches you how to distribute files across devices, describe tablespace usage and detect improper tablespace usage, describe how checkpoints work, and monitor and tune checkpoints and redo logs. This course discusses how to configure the Oracle9i database and balance input/output (I/O) in order to prevent contention.

Lesson 8: Optimizing Sort Operations (1.0) hour

Optimizing Sort Operations teaches you how to describe the sorting process and sort area parameters, describe tuning sort operations and operations that cause sorting, create and monitor temporary tablespaces, and reduce sort operations. 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.

Lesson 9: Tuning Oracle Shared Server (1.0) hour

Tuning Oracle Shared Server teaches you how to identify issues associated with managing users in a shared server environment, diagnose and resolve performance issues with Oracle Shared Server processes, and configure the Oracle Shared Server environment to optimize performance. This course discusses the Oracle Shared Server environment, which allows for multiple user processes to share a limited number of server processes.

Lesson 10: Application Tuning (1.0) hour

Application Tuning teaches you how to 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, and tune OLTP, DSS, and hybrid systems. This course discusses the Oracle9i Database Administrator's involvement in application tuning, with an emphasis on stored structures, indexes, materialized views, and query rewrites.

Lesson 11: SQL Statement Tuning (1.0) hour

SQL Statement Tuning teaches you how to describe how the Optimizer is used, plan stability, describe stored outlines, use SQL trace and TKPROF, collect statistics, describe histograms, and copy statistics between databases. This course discusses various tools that Oracle Database Administrators can use to tune SQL statements.

Lesson 12: Sizing the Shared Pool (1.0) hour

Sizing the Shared Pool teaches you how to describe the shared pool, describe library cache tuning, describe reuse statements, use reserved space, describe keeping large objects, and describe data dictionary cache tuning. 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.

Lesson 13: Diagnosing Contention for Latches (1.0) hour

Diagnosing Contention for Latches teaches you how to describe the purpose of latches, describe latch request types, diagnose latch contention, and tune resources. 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).

Lesson 14: Tuning the Operating System and Using Resource Manager (1.0) hour

Tuning the Operating System and Using Resource Manager teaches you how to describe different system architectures, identify the primary steps of OS tuning, describe paging and swapping, describe CPU tuning guidelines, distinguish process and threads, and use the Resource Manager. This course discusses the similar responsibilities of Database Administrators and System Administrators, as well as their relation to tuning an Operating System (OS).

4 Practice Exams

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.