| |
Oracle Performance Tuning OCP
Preparation Training Course
A three day on-site Oracle Certified Professional Performance
Tuning class
Test 1Z0-033
© 2007 by Burleson Consulting
* Learn Global Oracle Tuning.
* See External Environmental Tuning
* Understand SQL and PL/SQL Tuning.
* Employ Object & Network Tuning.
* Review OCP Performance Tuning Final Exam.
|
|
The primary goal
is this course is to prepare the students to pass the Oracle9i OCP
performance tuning exam. This Oracle9i OCP course is an intensive
5-day hands-on course is designed to provide Oracle professionals
with an in-depth understanding of the performance tuning features of
Oracle9i, specific Oracle concepts and knowledge required for the
OCP exam, and tips and techniques for passing the Oracle9i OCP exam
on your first attempt.
Hands-on
exercises are used to demonstrate each feature and the student will
gain first-hand experience in the key Oracle tuning concepts
required to pass the Oracle9i OCP exam. In addition, this course
provides sample OCP exam questions and an opportunity to access your
overall knowledge of Oracle performance tuning concepts.
 |
|
Oracle Performance Troubleshooting
with Dictionary Internals SQL & Tuning Scripts
Robin SchumacherISBN:
0-9727513-4-3 |
This Oracle OCP
performance tuning exam review training is designed for the
practicing Oracle professional but it is useful to anyone interested
in learning Oracle performance tuning. This includes Oracle
developers, Oracle DBAs, Oracle web developers and any computer
professional who needs to understand how Oracle databases are tuned
for optimal performance. The course assumes a basic knowledge of
Oracle DBA management and administration, relational database
concepts, SQL syntax, and basic Oracle architecture.
|
This Oracle
OCP training was designed by Mike Ault and Donald K. Burleson.
Author or more than 30 database books, Burleson was chosen by Oracle
Press to write five authorized editions, including Oracle
High-Performance SQL tuning. Burleson has over a decade of
real-world DBA experience in Oracle features and shares his Oracle
secrets in this intense hands-on Oracle tuning training.
Mike Ault is
an acknowledged leader in Oracle database administration and author
of more than 20 bestselling Oracle administration books. Holder of
five Oracle Masters Certificates, Mike Ault wrote the book on Oracle
Database Administration and has assisted tens of thousands of
students in wining their Oracle OCP certification.
Because of his exceptional skills at helping Oracle professionals
pass the OCP exams, Ault was chosen by Coriolis Press to author the
popular EXAM CRAM series for Oracle OCP certification. In this
intense hands-on Oracle OCP Backup & Recovery training, Ault shares
his proven secrets for passing the Oracle Certified Professional OCP
exam.
Learning Objectives:
The primary
objective of this Oracle9i OCP training is to provide each student
with the knowledge and testing secrets for passing the Oracle9i OCP
performance tuning exam. The student will gain confidence in their
Oracle performance tuning knowledge and learn the tricks and traps
of the Oracle9i OCP performance tuning exam.
Using a proven
training combination of intense instruction, hands-on practicum and
numerous Oracle9i sample exams, the student should have a firm
understanding of Oracle9i performance tuning.
Oracle9i
Performance Tuning OCP Preparation Training Course
A three day on-site Oracle Certified Professional Performance
Tuning class
Test 1Z0-033
Copyright © 2007 by Burleson Consulting
Syllabus
Day 1: Global Oracle Tuning
External Environmental Tuning
Monitoring the server environment (vmstat, glance, top)
Understanding RAM swapping (page-in, scan rate)
Understand CPU dispatching queues
Detecting network bottlenecks (netstat)
Oracle certification exam questions on external tuning
Database Instance Tuning
Using the V$ Tables
Using the DBA, ALL and USER views
Interpreting a STATSPACK report - Important Statistics
Evaluating database wait events
Memory Tuning
Buffer cache tuning
Shared pool tuning
Log buffer tuning
Tuning checkpoints
Using Oracle Real Application Clusters
Oracle OCP test questions on instance tuning
Day 2: SQL and PL/SQL Tuning
SQL Statement Tuning
Use of TKPROF
Use of Explain Plan
Use of AUTOTRACE
Understand cost-based optimizer internals
The value of CBO statistics with dbms_stats
Optimal table join order (ordered hint)
Using clustering_factor
Optimal index choices
Defining materialized views
Defining function-based indexes
When to define histograms
Reading
Explain Plans
Use of HINTS
Proper use of Indexes
Removing unnecessary large-table full-table scans
SQL tuning questions on OCP exam
PL/SQL Tuning
Measuring PL/SQL performance
Using bulk collect
Using ref cursors
Compiling PL/SQL
Pinning PL/SQL in SGA memory
Oracle OCP PL/SQL optimization exam questions
Day 3: Object & Network Tuning
Object Tuning
Setting INITTRANS for high concurrent transactions
Optimizing FREELISTS and FREELIST GROUPS
Using PCTFREE and PCTUSED
Avoiding migrated/chained rows
Performing online reorganizations with the dbms_redefinition
package
Using ASSM (bitmap freelists)
OCP questions on table and index tuning
Network Tuning
Tuning on
the OS side (TCP
packet sizing and bulking)
Monitoring distributed Oracle databases
Tuning Oracle*Net (SDU, TUD, tcp.nodelay)
OCP test questions on network tuning
OCP Performance Tuning Final Exam Review
Full sample OCP Tuning exam questions
OCP testing techniques for success
Testing tips and secrets
|
