Oracle9i Database Performance Tuning 1Z0-033: 1 Performance Tuning Overview
Description
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
Oracle9i Database Performance Tuning 1Z0-033: 2 Sizing the Buffer Cache
Description
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
Oracle9i Database Performance Tuning 1Z0-033: 3 Sizing Other SGA Structures
Description
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
Oracle9i Database Performance Tuning 1Z0-033: 4 Monitoring and Detecting Lock Contention
Description
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
Oracle9i Database Performance Tuning 1Z0-033: 5 Using Oracle Blocks Efficiently
Description
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
Oracle9i Database Performance Tuning 1Z0-033: 6 Diagnostic and Tuning Tools
Description
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)
Oracle9i Database Performance Tuning 1Z0-033: 7 Database Configuration and I/O Issues
Description
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
Oracle9i Database Performance Tuning 1Z0-033: 8 Optimizing Sort Operations
Description
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
Oracle9i Database Performance Tuning 1Z0-033: 9 Tuning Oracle Shared Server
Description
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
Oracle9i Database Performance Tuning 1Z0-033:10 Application Tuning
Description
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
Oracle9i Database Performance Tuning 1Z0-033:11 SQL Statement Tuning
Description
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
Oracle9i Database Performance Tuning 1Z0-033:12 Sizing the Shared Pool
Description
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
Oracle9i Database Performance Tuning 1Z0-033:13 Diagnosing Contention for Latches
Description
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
Oracle9i Database Performance Tuning 1Z0-033:14 Tuning the Operating System and Using Resource Manager
Description
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
Oracle9i Database Performance Tuning 1Z0-033:15 Practice Exam 1
Description
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
Oracle9i Database Performance Tuning 1Z0-033:16 Practice Exam 2
Description
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
Oracle9i Database Performance Tuning 1Z0-033:17 Practice Exam 3
Description
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
Oracle9i Database Performance Tuning 1Z0-033:18 Practice Exam 4
Description
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