Oracle 9i Database Performance Tuning 1Z0-033 Training

Summary:

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 Oracle 9i Database Performance Tuning 1Z0-033 online training series provides 18 hours of self-paced courseware. This web-based training provides 1 year of unlimited access to all of the following lessons:

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

Lesson Detail:

Performance Tuning Overview
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.

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

Sizing Other SGA Structures
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.

Monitoring and Detecting Lock Contention
This course discusses lock contention strategies and how to handle problems and errors that arise from locking.

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

Diagnostic and Tuning Tools
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.

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

Optimizing 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.

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

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

SQL Statement Tuning
This course discusses various tools that Oracle Database Administrators can use to tune SQL statements.

Sizing the Shared Pool
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.

Diagnosing Contention for Latches
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).

Tuning the Operating System and Using 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).

Practice Exam 1
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.

Practice exam

Practice Exam 2
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.

Practice exam

Practice Exam 3
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.

Practice exam

Practice Exam 4
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.

Practice exam

Certification:
Oracle 9i Database Performance Tuning 1Z0-033

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

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.

Technical Requirements:

Internet connection
Browser: Internet Explorer, FireFox, Chrome, Safari, Opera or any standards compliant browser.
Authorware and Macromedia Flash player recommended but not required.
JavaScript must be enabled.

What You Get:

You will receive Unlimited Access to all of the Oracle 9i Database Performance Tuning 1Z0-033 training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.

StaffKit is a leader in providing online computer training tutorials and online education. We have customers use our online training courses in over 75 countries. StaffKit has been providing e-learning solutions for 10 years.

Web-Based Training Products:

Oracle 9i Database Performance Tuning 1Z0-033 Online Training Series

Only $59.95

You might also be interested in our Technical Package which includes all of the Oracle 9i Database Performance Tuning 1Z0-033 training courses listed above plus hundreds of hours of related online training courses