
Oracle: Performance Tuning (1Z0-033)
VTC author, <a href=\'http://www.vtc.com/modules/products/authorInfo.php?author=146\' target=\"_blank\">Gavin Powell</a>, covers material in the 1Z0-033 Oracle 9i tuning certification examination, including the basics of performance tuning and tuning tools. Memory tuning covers the shared pool, the database buffer cache and other buffers. From an I/O perspective, topics covered are physical file structures of the database, tablespaces, datafiles and at the block level. Also covered are sorting, locking, latches and wait events, shared or dedicated server processes, statistics, SQL code tuning and resource management. There is also brief coverage of tuning in the operating system, plus specialized objects use. To begin learning today, simply click on one of the <b>Oracle Performance Tuning (1Z0-033)</b> lessons.
Course content
Introduction5 lessons
What is Performance Tuning?9 lessons
- Who Tunes and What Do They Tune?2:061 credit or ad
- The Different Stages of Tuning4:091 credit or ad
- Development/Testing/Production4:021 credit or ad
- Statistics and Performance Evaluation3:301 credit or ad
- Goal Oriented Tuning5:061 credit or ad
- Common Problems pt. 13:161 credit or ad
- Common Problems pt. 24:371 credit or ad
- Performance Versus Integrity1:531 credit or ad
- Oracle Enterprise Manager (OEM)2:541 credit or ad
Performance Tools10 lessons
- The Alert Log4:371 credit or ad
- Process Trace Files4:251 credit or ad
- User Trace Files1:331 credit or ad
- Setting Up Tracing4:521 credit or ad
- TKPROF3:021 credit or ad
- Manually Collecting Statistics1:451 credit or ad
- STATSPACK and Collecting Statistics1:331 credit or ad
- Collecting Statistics in OEM4:221 credit or ad
- Introducing the Wait Event Interface4:341 credit or ad
- What to Tune5:121 credit or ad
Tuning the Shared Pool9 lessons
- The Shared Pool2:511 credit or ad
- Shared Pool Efficiency5:281 credit or ad
- Shared Pool and Reserved Shared Pool4:141 credit or ad
- Library and Dictionary Cache Hit Ratios4:531 credit or ad
- Pinning Objects in the Shared Pool4:431 credit or ad
- The Large Pool1:541 credit or ad
- Caching Cursors2:181 credit or ad
- OEM and the Shared Pool2:091 credit or ad
- Performance Views0:561 credit or ad
The Database Buffer Cache13 lessons
- Database Buffer Cache Efficiency3:191 credit or ad
- OLTP Versus Data Warehouse2:561 credit or ad
- Configure the Database Buffer Cache3:581 credit or ad
- Examine the Database Buffer Cache3:191 credit or ad
- The Buffer Cache Hit Ratio3:191 credit or ad
- Processes and the Buffer Cache4:561 credit or ad
- How to Tune Buffer Cache4:481 credit or ad
- How Else to Tune Buffer Cache3:291 credit or ad
- Free List Contention5:071 credit or ad
- Multiple Database Writers and Slaves3:391 credit or ad
- Monitor Buffer Cache and Subset Pools4:321 credit or ad
- OEM and the Database Buffer Cache4:361 credit or ad
- Performance and Metadata Views0:301 credit or ad
Other Buffers10 lessons
- Tuning the Redo Log Buffer2:461 credit or ad
- Sizing the Redo Log Buffer3:481 credit or ad
- The Java Pool2:251 credit or ad
- Configuring Automatic PGA Memory3:281 credit or ad
- Configuring Manual PGA Memory4:111 credit or ad
- Tuning PGA Memory3:061 credit or ad
- Changing SGA Memory Online2:021 credit or ad
- SGA_MAX_SIZE4:111 credit or ad
- Changing Non SGA Memory Online2:151 credit or ad
- Performance Views3:551 credit or ad
Tuning I/O: Physical File Structures14 lessons
- Datafiles/Tablespaces/Objects2:161 credit or ad
- Control Files and Recoverability2:471 credit or ad
- Distribution of Database Files4:501 credit or ad
- Dividing Data Across Tablespaces3:051 credit or ad
- Oracle Partitioning1:151 credit or ad
- Tablespace Storage Structures4:171 credit or ad
- Dictionary Managed Tablespaces4:221 credit or ad
- Locally Managed Tablespaces1:481 credit or ad
- Finding Tablespace Problems5:181 credit or ad
- Redo and Archive Log Files pt. 13:561 credit or ad
- Redo and Archive Log Files pt. 22:561 credit or ad
- Physical Structures in OEM1:321 credit or ad
- Performance Views5:521 credit or ad
- Metadata Views1:051 credit or ad
Tuning I/O at the Block Level8 lessons
- Segments3:151 credit or ad
- Extents and Blocks2:441 credit or ad
- The High Water Mark1:261 credit or ad
- Reclaiming Unused Space1:151 credit or ad
- Row Chaining and Row Migration5:211 credit or ad
- Reorganizing Indexes3:191 credit or ad
- Detecting Problems With Indexes4:071 credit or ad
- Metadata Views1:421 credit or ad
Tuning Sorts8 lessons
- How Does Sorting Work?3:161 credit or ad
- Which SQL Code Causes Sorting?1:521 credit or ad
- Demonstrating SQL Code Sorting5:321 credit or ad
- Sorting in Memory and on Disk2:251 credit or ad
- Analyzing Sorting4:471 credit or ad
- Minimizing Sorting3:041 credit or ad
- Sorting in OEM4:541 credit or ad
- Performance Views5:201 credit or ad
Locking Issues9 lessons
- Locking Levels3:041 credit or ad
- Types of Contention pt. 12:301 credit or ad
- Types of Contention pt. 23:511 credit or ad
- Types of Locks3:371 credit or ad
- Detecting Lock Contention2:061 credit or ad
- How to Avoid Locking4:481 credit or ad
- Lock Monitoring and Removal in OEM3:391 credit or ad
- Performance and Metadata Views pt. 14:491 credit or ad
- Performance and Metadata Views pt. 21:431 credit or ad
Latches and Wait Events21 lessons
- What is a Latch?1:301 credit or ad
- Different Types of Latches3:291 credit or ad
- Shared Pool Latches pt. 13:181 credit or ad
- Shared Pool Latches pt. 22:341 credit or ad
- Database Buffer Cache Latches pt. 13:231 credit or ad
- Database Buffer Cache Latches pt. 23:111 credit or ad
- Database Buffer Cache Latches pt. 33:341 credit or ad
- Redo Log Latches2:201 credit or ad
- Session Connection Latches1:531 credit or ad
- Latch Spins, Misses and Sleeps3:281 credit or ad
- Latch Miss Rate2:131 credit or ad
- Latch Miss Total Time3:301 credit or ad
- What is a Wait Event?2:201 credit or ad
- Event Types and TIMED_STATISTICS2:061 credit or ad
- Idle Wait Events1:471 credit or ad
- Querying Significant Wait Events3:391 credit or ad
- Wait Events in an Active Database4:431 credit or ad
- Analyzing Significant Wait Events5:171 credit or ad
- The Wait Event Interface5:551 credit or ad
- The Wait Event Interface in OEM5:231 credit or ad
- Performance Views3:041 credit or ad
Shared Servers and Dedicated Servers6 lessons
Statistics14 lessons
- What are Statistics?2:041 credit or ad
- The Importance of Realistic Statistics3:401 credit or ad
- Statistics and OPTIMIZER_MODE2:261 credit or ad
- Statistics and CURSOR_SHARING3:461 credit or ad
- CBO Parameters pt. 13:101 credit or ad
- CBO Parameters pt. 24:051 credit or ad
- CBO Parameters pt. 32:481 credit or ad
- Gathering Statistics using ANALYZE4:511 credit or ad
- Histograms and the ANALYZE Command4:281 credit or ad
- Gathering Statistics using DBMS_STATS3:521 credit or ad
- Gathering Statistics using OEM2:221 credit or ad
- What is STATSPACK?3:181 credit or ad
- Installing and Using STATSPACK4:431 credit or ad
- Metadata Views1:351 credit or ad
Applications and Specialized Objects13 lessons
- Database Type Requirements4:001 credit or ad
- Oracle Special Storage Structures pt. 13:521 credit or ad
- Oracle Special Storage Structures pt. 24:501 credit or ad
- Applying Storage Structures5:101 credit or ad
- Creating BTree and Bitmap Indexes Syntax4:451 credit or ad
- Creating BTree and Bitmap Indexes Examples2:491 credit or ad
- Creating Index Organized Tables3:201 credit or ad
- Creating Clusters2:131 credit or ad
- Creating Materialized Views3:391 credit or ad
- Oracle Partitioning Methods Syntax4:241 credit or ad
- Oracle Partitioning Methods Examples pt. 15:101 credit or ad
- Oracle Partitioning Methods Examples pt. 22:241 credit or ad
- Metadata Views2:051 credit or ad
SQL Code Tuning31 lessons
- Building Efficient SQL Code1:561 credit or ad
- Tuning Query Clauses pt. 14:311 credit or ad
- Tuning Query Clauses pt. 23:321 credit or ad
- Tuning Query Clauses pt. 34:461 credit or ad
- Comparisons3:081 credit or ad
- Joins5:081 credit or ad
- Other Factors pt. 13:571 credit or ad
- Other Factors pt. 23:401 credit or ad
- SQL Code Execution Process3:501 credit or ad
- The Optimizer and What It Does3:021 credit or ad
- The Internal Machinations of the Optimizer pt. 14:161 credit or ad
- The Internal Machinations of the Optimizer pt. 24:291 credit or ad
- Hints4:581 credit or ad
- Types of Hints1:351 credit or ad
- Influence the Optimizer pt. 13:491 credit or ad
- Influence the Optimizer pt. 24:551 credit or ad
- Alter Table Scans1:041 credit or ad
- Alter Index Scans pt. 13:571 credit or ad
- Alter Index Scans pt. 24:011 credit or ad
- Modify Joins pt. 13:531 credit or ad
- Modify Joins pt. 25:011 credit or ad
- Perform SQL in Parallel2:401 credit or ad
- Change Queries and Subqueries2:011 credit or ad
- Finding Queries with Problems0:561 credit or ad
- EXPLAIN PLAN and the PLAN_TABLE4:491 credit or ad
- Autotrace in SQL*Plus0:271 credit or ad
- SQL Trace and TKPROF pt. 13:241 credit or ad
- SQL Trace and TKPROF pt. 23:401 credit or ad
- Finding Bad Queries in OEM1:591 credit or ad
- Plan Stability and Stored Outlines4:131 credit or ad
- Performance and Metadata Views2:211 credit or ad
Resource Management5 lessons
The Operating System7 lessons
- Basic Operating System Tuning4:321 credit or ad
- Virtual Memory/Paging/Swapping3:351 credit or ad
- What Determines I/O Distribution?1:581 credit or ad
- Database Function and Methods of Distribution1:561 credit or ad
- Oracle Database File Types Distribution4:591 credit or ad
- Database Block Size3:201 credit or ad
- Resource Consumption in OEM1:281 credit or ad