Catalog

Toll-free in USA 1-877-545-5763

Oracle9i Database Performance Tuning 1Z0-033

Total Items: 18

Total Time: 18 hour(s)

Audience: This series is for anyone who wants to achieve Oracle9i 1Z0-033 certification.

Description: 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.

Features

Flash-based instructional demonstrations applying course concepts.
Instructional audio with graphics highlighting key points.
Exercises allow learners to practice in the actual application being studied.
A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
Search text enables learners to rapidly search all text within a course to easily retrieve information required.
Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
A skill assessment generates a customized learning path based on the results of a pre-test.
A glossary provides a reference for definitions of unfamiliar terms.
Bookmarking tracks the learner's progress in a course.

Includes:

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Performance Tuning Overview

Course Code: l_3301

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

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Sizing the Buffer Cache

Course Code: l_3302

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

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Sizing Other SGA Structures

Course Code: l_3303

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

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Monitoring and Detecting Lock Contention

Course Code: l_3304

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

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Using Oracle Blocks Efficiently

Course Code: l_3305

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

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Diagnostic and Tuning Tools

Course Code: l_3306

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)

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Database Configuration and I/O Issues

Course Code: l_3307

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

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Optimizing Sort Operations

Course Code: l_3308

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

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Tuning Oracle Shared Server

Course Code: l_3309

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

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Application Tuning

Course Code: l_3310

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

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: SQL Statement Tuning

Course Code: l_3311

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

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Sizing the Shared Pool

Course Code: l_3312

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

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Diagnosing Contention for Latches

Course Code: l_3313

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

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Tuning the Operating System and Using Resource Manager

Course Code: l_3314

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

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Practice Exam 1

Course Code: or3351

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.

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Practice Exam 2

Course Code: or3352

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Practice Exam 3

Course Code: or3353

Time: 1 hour(s)

Oracle9i Database Performance Tuning 1Z0-033: Practice Exam 4

Course Code: or3354