• GSA SCHEDULE
Call 877-932-8228
for GSA Pricing.
GS-35F-0556S
• CLIENT LOCATIONS
Scottsdale, AZ
Phoenix, AZ
Los Angeles, CA
Sacramento, CA
San Diego, CA
San Francisco, CA
San Jose, CA
Santa Clara, CA
Milpitas, CA
Colorado Springs, CO
Denver, CO
Hartford, CT
Washington, DC
Jacksonville, FL
Atlanta, GA
Chicago, IL
Indianapolis, IN
Muncie, IN
Boston, MA
Cambridge, MA
Baltimore, MD
Ann Arbor, MI
Detroit, MI
St. Louis, MO
Charlotte, NC
Winston-Salem, NC
Lincoln, NE
Madison, NJ
Princeton, NJ
Trenton, NJ
Albany, NY
Buffalo, NY
Rochester, NY
New York City, NY
Syracuse, NY
Las Vegas, NV
Cleveland, OH
Columbus, OH
Dayton, OH
Oklahoma City, OK
Portland, OR
Philadelphia, PA
Pittsburgh, PA
Rapid City, SD
Memphis, TN
Nashville, TN
Austin, TX
Dallas, TX
Fort Worth, TX
Houston, TX
San Antonio, TX
Arlington, VA
Virginia Beach, VA
Seattle, WA
Milwaukee, WI
Toronto, Canada
◊ ONLINE ORACLE9I DATABASE PERFORMANCE TUNING 1Z0-033 TRAINING
Overview |
Catalog |
Benefits |
FAQs |
Try Free Course |
Buy |
Log in |
Support
Online Training
Only $42.95
12-month subscription
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.
Oracle9i Database Performance Tuning 1Z0-033 Series (18 hours)
ONLINE TRAINING FEATURES
- Learn online with these interactive online courses.
- Affordable Pricing (Only $42.95 for the complete series)
- A full year to complete the courses
- Retake the courses as many times as you like
- Measure your progress with assessment tests after each course
- Earn completion certificates after passing each assessment test
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
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
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
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.
Objectives
- Complete the practice exam questions
