|
|
Oracle9i Database Performance Tuning 1Z0-033
Join over 1 million people who learn
online, with these complete interactive computer training
courses.
|
See
How It Works
|
| This online course includes: |
Time Needed |
| Performance Tuning Overview |
1 hour |
| Sizing the Buffer Cache |
1 hour |
| Sizing Other SGA Structures |
1 hour |
| Monitoring and Detecting Lock Contention |
1 hour |
| Using Oracle Blocks Efficiently |
1 hour |
| Diagnostic and Tuning Tools |
1 hour |
| Database Configuration and I/O Issues |
1 hour |
| Optimizing Sort Operations |
1 hour |
| Tuning Oracle Shared Server |
1 hour |
| Application Tuning |
1 hour |
| SQL Statement Tuning |
1 hour |
| Sizing the Shared Pool |
1 hour |
| Diagnosing Contention for Latches |
1 hour |
| Tuning the Operating System and Using Resource Manager |
1 hour |
| Practice Exam 1 |
1
hour |
| Practice Exam
2 |
1
hour |
| Practice Exam
3 |
1 hour |
| Practice Exam
4 |
1 hour |
| Estimated time needed to complete entire
course |
18
hours |
|
Receive your login ID to take the training courses online,
as many times as you wish, for 1 year.
Click
here for group orders.
| Buy this entire
online training course with one easy payment of $67 |
|
OR
| Buy the Technical
Pack, and receive this course
plus many more, for only $197
|
 |
|
Benefits |
- Unlimited access for
1 year
- Learn anytime,
anywhere
- You control the pace
- Start & stop
wherever you want
- No books to read
- No software needed
- Value Packs include
Free online tech support
- Double
guarantee
|
- 100% Money back
guarantee
- One time payment No
monthly fee
- Use the course index
for review anytime
- Answer course
questions with at least 70% accuracy and print
your own certificates of
completion to prove that you have mastered each training course.
- Free status reports
for company managers
|
|
|
Requirements |
All you need is a PC with Windows,
the Microsoft Internet Explorer (browser)
and an Internet connection.
Note: The online computer training is designed to
work only with Internet Explorer. Prices shown are per
user. |
|
What
You will Learn |
|
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.
Certification:
The test that this series prepares
students to take is a part of earning the Oracle9i Database
Administrator Certified Professional certification.
|
|
Topic
Details |
- 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
- Use
the buffer cache
- Identify
tuning issues with the buffer cache
- Monitor
buffer cache usage
- Describe
table caching
- Describe
latch and freelist contention
- Size
the redo log buffer
- Size
the Java pool
- Control
Java session memory
- Configure
I/O slaves
- Configure
multiple database writer (DBWn) processors
- 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
- 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
- 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)
- Distribute
files across devices
- Describe
tablespace usage and detect improper tablespace
usage
|
- Describe
how checkpoints work
- Monitor
and tune checkpoints and redo logs
- 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
- 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
- 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
- Describe
how the Optimizer is used
- Plan
stability
- Describe
stored outlines
- Use
SQL trace and TKPROF
- Collect
statistics
- Describe
histograms
- Copy
statistics between databases
- Describe
the shared pool
- Describe
library cache tuning
- Describe
reuse statements
- Use
reserved space
- Describe
keeping large objects
- Describe
data dictionary cache tuning
- Describe
the purpose of latches
- Describe
latch request types
- Diagnose
latch contention
- Tune
resources
- 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
- Complete the
practice exam questions
|
|
|
