VTC Oracle Performance Tuning

achraf.mouni

  • Hero Member
  • *****
    • مشاركة: 2439
    • مشاهدة الملف الشخصي
    • البريد الالكتروني
في: كانون الثاني 15, 2009, 07:45:18 صباحاً
السلام عليكم ورحمة الله

يسعدنى ان اقدم لكم الاسطوانتين  الكاملتين من شركة VTC Oracle Performance Tuning (1Z0-033
كل اللى موجود على  النت هى الاسطوانة الثانية فقط ولكن الان اقدم لكم الاسطوانة الاولى بالاضافة الى  الاسطوانة الثانية
هذه بعض المعلومات عن الاسطوانات

Duration: 11 hrs / 194 lessons

Introduction
Welcome  (00:55)
Prerequisites for this Course (05:52)
About this Course pt. 1  (04:28)
About this Course pt. 2 (02:40)
Oracle Tuning ********ation  (01:05)
What is Performance Tuning?
Who Tunes and What Do They Tune?  (02:06)
The Different Stages of Tuning (04:09)  
Development/Testing/Production (04:02)
Statistics and Performance  Evaluation (03:30)
Goal Oriented Tuning (05:06)
Common Problems pt. 1  (03:16)
Common Problems pt. 2 (04:37)
Performance Versus Integrity  (01:53)
Oracle Enterprise Manager (OEM) (02:54)
Performance Tools  
The Alert Log (04:37)
Process Trace Files (04:25)
User Trace Files  (01:33)
Setting Up Tracing (04:52)
TKPROF (03:02)
Manually  Collecting Statistics (01:45)
STATSPACK and Collecting Statistics (01:33)  
Collecting Statistics in OEM (04:22)
Introducing the Wait Event  Interface (04:34)
What to Tune (05:12)
Tuning the Shared Pool
The  Shared Pool (02:51)
Shared Pool Efficiency (05:28)
Shared Pool and  Reserved Shared Pool (04:14)
Library and Dictionary Cache Hit Ratios (04:53)  
Pinning Objects in the Shared Pool (04:43)
The Large Pool (01:54)  
Caching Cursors (02:18)
OEM and the Shared Pool (02:09)
Performance  Views (00:56)
The Database Buffer Cache
Database Buffer Cache Efficiency  (03:19)
OLTP Versus Data Warehouse (02:56)
Configure the Database Buffer  Cache (03:58)
Examine the Database Buffer Cache (03:19)
The Buffer Cache  Hit Ratio (03:19)
Processes and the Buffer Cache (04:56)
How to Tune  Buffer Cache (04:48)
How Else to Tune Buffer Cache (03:29)
Free List  Contention (05:07)
Multiple Database Writers and Slaves (03:39)
Monitor  Buffer Cache and Subset Pools (04:32)
OEM and the Database Buffer Cache  (04:36)
Performance and Metadata Views (00:30)
Other Buffers
Tuning  the Redo Log Buffer (02:46)
Sizing the Redo Log Buffer (03:48)
The Java  Pool (02:25)
Configuring Automatic PGA Memory (03:28)
Configuring Manual  PGA Memory (04:11)
Tuning PGA Memory (03:06)
Changing SGA Memory Online  (02:02)
SGA_MAX_SIZE (04:11)
Changing Non SGA Memory Online (02:15)  
Performance Views (03:55)
Tuning I/O: Physical File Structures  
Datafiles/Tablespaces/Objects (02:16)
Control Files and Recoverability  (02:47)
Distribution of Database Files (04:50)
Dividing Data Across  Tablespaces (03:05)
Oracle Partitioning (01:15)
Tablespace Storage  Structures (04:17)
Dictionary Managed Tablespaces (04:22)
Locally  Managed Tablespaces (01:48)
Finding Tablespace Problems (05:18)
Redo and  Archive Log Files pt. 1 (03:56)
Redo and Archive Log Files pt. 2 (02:56)  
Physical Structures in OEM (01:32)
Performance Views (05:52)  
Metadata Views (01:05)
Tuning I/O at the Block Level
Segments  (03:15)
Extents and Blocks (02:44)
The High Water Mark (01:26)  
Reclaiming Unused Space (01:15)
Row Chaining and Row Migration (05:21)  
Reorganizing Indexes (03:19)
Detecting Problems With Indexes (04:07)  
Metadata Views (01:42)
Tuning Sorts
How Does Sorting Work? (03:16)  
Which SQL Code Causes Sorting? (01:52)
Demonstrating SQL Code Sorting  (05:32)
Sorting in Memory and on Disk (02:25)
Analyzing Sorting (04:47)  
Minimizing Sorting (03:04)
Sorting in OEM (04:54)
Performance Views  (05:20)
Locking Issues
Locking Levels (03:04)
Types of Contention  pt. 1 (02:30)
Types of Contention pt. 2 (03:51)
Types of Locks (03:37)  
Detecting Lock Contention (02:06)
How to Avoid Locking (04:48)
Lock  Monitoring and Removal in OEM (03:39)
Performance and Metadata Views pt. 1  (04:49)
Performance and Metadata Views pt. 2 (01:43)
Latches and Wait  Events
What is a Latch? (01:30)
Different Types of Latches (03:29)  
Shared Pool Latches pt. 1 (03:18)
Shared Pool Latches pt. 2 (02:34)  
Database Buffer Cache Latches pt. 1 (03:23)
Database Buffer Cache  Latches pt. 2 (03:11)
Database Buffer Cache Latches pt. 3 (03:34)
Redo  Log Latches (02:20)
Session Connection Latches (01:53)
Latch Spins,  Misses and Sleeps (03:28)
Latch Miss Rate (02:13)
Latch Miss Total Time  (03:30)
What is a Wait Event? (02:20)
Event Types and TIMED_STATISTICS  (02:06)
Idle Wait Events (01:47)
Querying Significant Wait Events  (03:39)
Wait Events in an Active Database (04:43)
Analyzing Significant  Wait Events (05:17)
The Wait Event Interface (05:55)
The Wait Event  Interface in OEM (05:23)
Performance Views (03:04)
Shared Servers and  Dedicated Servers
Tuning Oracle Net Services (02:33)
Shared Versus  Dedicated Servers (02:14)
Shared Server Configuration (03:20)
Oracle Net  Manager in OEM (01:23)
Wait Events and Performance Views pt. 1 (04:13)  
Wait Events and Performance Views pt. 2 (05:23)
Statistics
What are  Statistics? (02:04)
The Importance of Realistic Statistics (03:40)  
Statistics and OPTIMIZER_MODE (02:26)
Statistics and CURSOR_SHARING  (03:46)
CBO Parameters pt. 1 (03:10)
CBO Parameters pt. 2 (04:05)  
CBO Parameters pt. 3 (02:48)
Gathering Statistics using ANALYZE (04:51)  
Histograms and the ANALYZE Command (04:28)
Gathering Statistics using  DBMS_STATS (03:52)
Gathering Statistics using OEM (02:22)
What is  STATSPACK? (03:18)
Installing and Using STATSPACK (04:43)
Metadata Views  (01:35)
Applications and Specialized Objects
Database Type Requirements  (04:00)
Oracle Special Storage Structures pt. 1 (03:52)
Oracle Special  Storage Structures pt. 2 (04:50)
Applying Storage Structures (05:10)  
Creating BTree and Bitmap Indexes Syntax (04:45)
Creating BTree and  Bitmap Indexes Examples (02:49)
Creating Index Organized Tables (03:20)  
Creating Clusters (02:13)
Creating Materialized Views (03:39)
Oracle  Partitioning Methods Syntax (04:24)
Oracle Partitioning Methods Examples pt.  1 (05:10)
Oracle Partitioning Methods Examples pt. 2 (02:24)
Metadata  Views (02:05)
SQL Code Tuning
Building Efficient SQL Code (01:56)  
Tuning Query Clauses pt. 1 (04:31)
Tuning Query Clauses pt. 2 (03:32)  
Tuning Query Clauses pt. 3 (04:46)
Comparisons (03:08)
Joins (05:08)  
Other Factors pt. 1 (03:57)
Other Factors pt. 2 (03:40)
SQL Code  Execution Process (03:50)
The Optimizer and What It Does (03:02)
The  Internal Machinations of the Optimizer pt. 1 (04:16)
The Internal  Machinations of the Optimizer pt. 2 (04:29)
Hints (04:58)
Types of Hints  (01:35)
Influence the Optimizer pt. 1 (03:49)
Influence the Optimizer  pt. 2 (04:55)
Alter Table Scans (01:04)
Alter Index Scans pt. 1 (03:57)  
Alter Index Scans pt. 2 (04:01)
Modify Joins pt. 1 (03:53)
Modify  Joins pt. 2 (05:01)
Perform SQL in Parallel (02:40)
Change Queries and  Subqueries (02:01)
Finding Queries with Problems (00:56)
EXPLAIN PLAN  and the PLAN_TABLE (04:49)
Autotrace in SQL*Plus (00:27)
SQL Trace and  TKPROF pt. 1 (03:24)
SQL Trace and TKPROF pt. 2 (03:40)
Finding Bad  Queries in OEM (01:59)
Plan Stability and Stored Outlines (04:13)  
Performance and Metadata Views (02:21)
Resource Management
The  Oracle Resource Manager (00:45)
Resource Manager Components (01:26)  
Resource Plan Directives (02:40)
Create Groups and Plans and Allocate  (02:45)
Metadata and Performance Views (01:02)
The Operating System  
Basic Operating System Tuning (04:32)
Virtual Memory/Paging/Swapping  (03:35)
What Determines I/O Distribution? (01:58)
Database Function and  Methods of Distribution (01:56)
Oracle Database File Types Distribution  (04:59)
Database Block Size (03:20)
Resource Consumption in OEM (01:28)  
Conclusion
Wrapping it All Up! (04:44)
Credits
About the Author  (01:14)

روابط التحميل:
http://www.technolib.net/2008/09/09...-complete-2cds/