|
Oracle: Performance Tuning (1Z0-033) Tutorials Online |
![]() |
|
Description
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. |
01 Introduction
0101 Welcome
0102 Prerequisites for this Course
0103 About this Course pt. 1
0104 About this Course pt. 2
0105 Oracle Tuning Documentation
02 What is Performance Tuning?
0201 Who Tunes and What Do They Tune?
0202 The Different Stages of Tuning
0203 Development/Testing/Production
0204 Statistics and Performance Evaluation
0205 Goal Oriented Tuning
0206 Common Problems pt. 1
0207 Common Problems pt. 2
0208 Performance Versus Integrity
0209 Oracle Enterprise Manager (OEM)
03 Performance Tools
0301 The Alert Log
0302 Process Trace Files
0303 User Trace Files
0304 Setting Up Tracing
0305 TKPROF
0306 Manually Collecting Statistics
0307 STATSPACK and Collecting Statistics
0308 Collecting Statistics in OEM
0309 Introducing the Wait Event Interface
0310 What to Tune
04 Tuning the Shared Pool
0401 The Shared Pool
0402 Shared Pool Efficiency
0403 Shared Pool and Reserved Shared Pool
0404 Library and Dictionary Cache Hit Ratios
0405 Pinning Objects in the Shared Pool
0406 The Large Pool
0407 Caching Cursors
0408 OEM and the Shared Pool
0409 Performance Views
05 The Database Buffer Cache
0501 Database Buffer Cache Efficiency
0502 OLTP Versus Data Warehouse
0503 Configure the Database Buffer Cache
0504 Examine the Database Buffer Cache
0505 The Buffer Cache Hit Ratio
0506 Processes and the Buffer Cache
0507 How to Tune Buffer Cache
0508 How Else to Tune Buffer Cache
0509 Free List Contention
0510 Multiple Database Writers and Slaves
0511 Monitor Buffer Cache and Subset Pools
0512 OEM and the Database Buffer Cache
0513 Performance and Metadata Views
06 Other Buffers
0601 Tuning the Redo Log Buffer
0602 Sizing the Redo Log Buffer
0603 The Java Pool
0604 Configuring Automatic PGA Memory
0605 Configuring Manual PGA Memory
0606 Tuning PGA Memory
0607 Changing SGA Memory Online
0608 SGA_MAX_SIZE
0609 Changing Non SGA Memory Online
0610 Performance Views
07 Tuning I/O: Physical File Structures
0701 Datafiles/Tablespaces/Objects
0702 Control Files and Recoverability
0703 Distribution of Database Files
0704 Dividing Data Across Tablespaces
0705 Oracle Partitioning
0706 Tablespace Storage Structures
0707 Dictionary Managed Tablespaces
0708 Locally Managed Tablespaces
0709 Finding Tablespace Problems
0710 Redo and Archive Log Files pt. 1
0711 Redo and Archive Log Files pt. 2
0712 Physical Structures in OEM
0713 Performance Views
0714 Metadata Views
08 Tuning I/O at the Block Level
0801 Segments
0802 Extents and Blocks
0803 The High Water Mark
0804 Reclaiming Unused Space
0805 Row Chaining and Row Migration
0806 Reorganizing Indexes
0807 Detecting Problems With Indexes
0808 Metadata Views
09 Tuning Sorts
0901 How Does Sorting Work?
0902 Which SQL Code Causes Sorting?
0903 Demonstrating SQL Code Sorting
0904 Sorting in Memory and on Disk
0905 Analyzing Sorting
0906 Minimizing Sorting
0907 Sorting in OEM
0908 Performance Views
10 Locking Issues
1001 Locking Levels
1002 Types of Contention pt. 1
1003 Types of Contention pt. 2
1004 Types of Locks
1005 Detecting Lock Contention
1006 How to Avoid Locking
1007 Lock Monitoring and Removal in OEM
1008 Performance and Metadata Views pt. 1
1009 Performance and Metadata Views pt. 2
11 Latches and Wait Events
1101 What is a Latch?
1102 Different Types of Latches
1103 Shared Pool Latches pt. 1
1104 Shared Pool Latches pt. 2
1105 Database Buffer Cache Latches pt. 1
1106 Database Buffer Cache Latches pt. 2
1107 Database Buffer Cache Latches pt. 3
1108 Redo Log Latches
1109 Session Connection Latches
1110 Latch Spins, Misses and Sleeps
1111 Latch Miss Rate
1112 Latch Miss Total Time
1113 What is a Wait Event?
1114 Event Types and TIMED_STATISTICS
1115 Idle Wait Events
1116 Querying Significant Wait Events
1117 Wait Events in an Active Database
1118 Analyzing Significant Wait Events
1119 The Wait Event Interface
1120 The Wait Event Interface in OEM
1121 Performance Views
12 Shared Servers and Dedicated Servers
1201 Tuning Oracle Net Services
1202 Shared Versus Dedicated Servers
1203 Shared Server Configuration
1204 Oracle Net Manager in OEM
1205 Wait Events and Performance Views pt. 1
1206 Wait Events and Performance Views pt. 2
13 Statistics
1301 What are Statistics?
1302 The Importance of Realistic Statistics
1303 Statistics and OPTIMIZER_MODE
1304 Statistics and CURSOR_SHARING
1305 CBO Parameters pt. 1
1306 CBO Parameters pt. 2
1307 CBO Parameters pt. 3
1308 Gathering Statistics using ANALYZE
1309 Histograms and the ANALYZE Command
1310 Gathering Statistics using DBMS_STATS
1311 Gathering Statistics using OEM
1312 What is STATSPACK?
1313 Installing and Using STATSPACK
1314 Metadata Views
14 Applications and Specialized Objects
1401 Database Type Requirements
1402 Oracle Special Storage Structures pt. 1
1403 Oracle Special Storage Structures pt. 2
1404 Applying Storage Structures
1405 Creating BTree and Bitmap Indexes Syntax
1406 Creating BTree and Bitmap Indexes Examples
1407 Creating Index Organized Tables
1408 Creating Clusters
1409 Creating Materialized Views
1410 Oracle Partitioning Methods Syntax
1411 Oracle Partitioning Methods Examples pt. 1
1412 Oracle Partitioning Methods Examples pt. 2
1413 Metadata Views
15 SQL Code Tuning
1501 Building Efficient SQL Code
1502 Tuning Query Clauses pt. 1
1503 Tuning Query Clauses pt. 2
1504 Tuning Query Clauses pt. 3
1505 Comparisons
1506 Joins
1507 Other Factors pt. 1
1508 Other Factors pt. 2
1509 SQL Code Execution Process
1510 The Optimizer and What It Does
1511 The Internal Machinations of the Optimizer pt. 1
1512 The Internal Machinations of the Optimizer pt. 2
1513 Hints
1514 Types of Hints
1515 Influence the Optimizer pt. 1
1516 Influence the Optimizer pt. 2
1517 Alter Table Scans
1518 Alter Index Scans pt. 1
1519 Alter Index Scans pt. 2
1520 Modify Joins pt. 1
1521 Modify Joins pt. 2
1522 Perform SQL in Parallel
1523 Change Queries and Subqueries
1524 Finding Queries with Problems
1525 EXPLAIN PLAN and the PLAN_TABLE
1526 Autotrace in SQL*Plus
1527 SQL Trace and TKPROF pt. 1
1528 SQL Trace and TKPROF pt. 2
1529 Finding Bad Queries in OEM
1530 Plan Stability and Stored Outlines
1531 Performance and Metadata Views
16 Resource Management
1601 The Oracle Resource Manager
1602 Resource Manager Components
1603 Resource Plan Directives
1604 Create Groups and Plans and Allocate
1605 Metadata and Performance Views
17 The Operating System
1701 Basic Operating System Tuning
1702 Virtual Memory/Paging/Swapping
1703 What Determines I/O Distribution?
1704 Database Function and Methods of Distribution
1705 Oracle Database File Types Distribution
1706 Database Block Size
1707 Resource Consumption in OEM
18 Conclusion
1801 Wrapping it All Up!
19 Credits
1901 About the Author
sku |
|
