Oracle9i Database Performance Tuning 1Z0-033 eLearning Course
Oracle9i Database Performance Tuning 1Z0-033 eLearning Course Series (18 hours)
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.
Self-Paced eLearning Course Benefits
- 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. Oracle9i Database Performance Tuning 1Z0-033:1 Performance Tuning Overview (Time: 1 hours)
This eLearning 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.
Course Objectives
|
2. Oracle9i Database Performance Tuning 1Z0-033:2 Sizing the Buffer Cache (Time: 1 hours)
This eLearning course discusses issues related to using the buffer cache, which holds blocks of memory while Oracle processes perform operations on them.
Course Objectives
|
3. Oracle9i Database Performance Tuning 1Z0-033:3 Sizing Other SGA Structures (Time: 1 hours)
This eLearning 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.
Course Objectives
|
4. Oracle9i Database Performance Tuning 1Z0-033:4 Monitoring and Detecting Lock Contention (Time: 1 hours)
This eLearning course discusses lock contention strategies and how to handle problems and errors that arise from locking.
Course Objectives
|
5. Oracle9i Database Performance Tuning 1Z0-033:5 Using Oracle Blocks Efficiently (Time: 1 hours)
This eLearning course discusses the performance implications of space management, and how the use of blocks can make a difference in space management.
Course Objectives
|
6. Oracle9i Database Performance Tuning 1Z0-033:6 Diagnostic and Tuning Tools (Time: 1 hours)
This eLearning 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.
Course Objectives
|
7. Oracle9i Database Performance Tuning 1Z0-033:7 Database Configuration and I/O Issues (Time: 1 hours)
This eLearning course discusses how to configure the Oracle9i database and balance input/output (I/O) in order to prevent contention.
Course Objectives
|
8. Oracle9i Database Performance Tuning 1Z0-033:8 Optimizing Sort Operations (Time: 1 hours)
This eLearning 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.
Course Objectives
|
9. Oracle9i Database Performance Tuning 1Z0-033:9 Tuning Oracle Shared Server (Time: 1 hours)
This eLearning course discusses the Oracle Shared Server environment, which allows for multiple user processes to share a limited number of server processes.
Course Objectives
|
10. Oracle9i Database Performance Tuning 1Z0-033:10 Application Tuning (Time: 1 hours)
This eLearning course discusses the Oracle9i Database Administrator's involvement in application tuning, with an emphasis on stored structures, indexes, materialized views, and query rewrites.
Course Objectives
|
11. Oracle9i Database Performance Tuning 1Z0-033:11 SQL Statement Tuning (Time: 1 hours)
This eLearning course discusses various tools that Oracle Database Administrators can use to tune SQL statements.
Course Objectives
|
12. Oracle9i Database Performance Tuning 1Z0-033:12 Sizing the Shared Pool (Time: 1 hours)
This eLearning 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.
Course Objectives
|
13. Oracle9i Database Performance Tuning 1Z0-033:13 Diagnosing Contention for Latches (Time: 1 hours)
This eLearning 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).
Course Objectives
|
14. Oracle9i Database Performance Tuning 1Z0-033:14 Tuning the Operating System and Using Resource Manager (Time: 1 hours)
This eLearning course discusses the similar responsibilities of Database Administrators and System Administrators, as well as their relation to tuning an Operating System (OS).
Course Objectives
|
15. Oracle9i Database Performance Tuning 1Z0-033:15 Practice Exam 1 (Time: 1 hours)
This eLearning 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.
Course Objectives
|
Course Topics
|
16. Oracle9i Database Performance Tuning 1Z0-033:16 Practice Exam 2 (Time: 1 hours)
This eLearning 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.
Course Objectives
|
Course Topics
|
17. Oracle9i Database Performance Tuning 1Z0-033:17 Practice Exam 3 (Time: 1 hours)
This eLearning 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.
Course Objectives
|
Course Topics
|
18. Oracle9i Database Performance Tuning 1Z0-033:18 Practice Exam 4 (Time: 1 hours)
This eLearning 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.
Course Objectives
|
Course Topics
|
of Live Online Training:
Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.