هذه بعض المعلومات عن الاسطوانات
Duration: 11 hrs / 194 lessons
Introduction
Welcome (00:55)
Prerequisites for this Course (05:52)
About this Course pt. 1 (04:2
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:2
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:1
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:5
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:4
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:4
The Java Pool (02:25)
Configuring Automatic PGA Memory (03:2
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:4
Finding Tablespace Problems (05:1
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:4
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:1
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:2
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:4
Gathering Statistics using ANALYZE (04:51)
Histograms and the ANALYZE Command (04:2
Gathering Statistics using DBMS_STATS (03:52)
Gathering Statistics using OEM (02:22)
What is STATSPACK? (03:1
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:0
Joins (05:0
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:5
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:5
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:2
Conclusion
Wrapping it All Up! (04:44)
Credits
About the Author (01:14)
روابط التحميل:
https://www.technolib.net/2008/09/09...complete-2cds/
وتقبلوا منى تحياتى
مفاجاة: اسطوانتى VTC Oracle Performance Tuning (1Z0-033)
ضوابط المشاركة
المفضلات