الإعــلام الآلي والرياضيــات يشتمل على جميع مبادئ الإعلام الآلي والرياضيــات

إضافة رد
قديم 15-01-2009, 08:45 AM
  #1
achraf.mouni
مشرف قسم
الكمبيوتر وتطوير المواقع والانترنت
مشرف قسم
الرياضيات والإعلام الآلي
 الصورة الرمزية achraf.mouni
 
تاريخ التسجيل: 08-09-2008
الدولة: الجزائر
المشاركات: 2,439
achraf.mouni عضو محترف الابداعachraf.mouni عضو محترف الابداعachraf.mouni عضو محترف الابداعachraf.mouni عضو محترف الابداعachraf.mouni عضو محترف الابداعachraf.mouni عضو محترف الابداعachraf.mouni عضو محترف الابداعachraf.mouni عضو محترف الابداعachraf.mouni عضو محترف الابداعachraf.mouni عضو محترف الابداعachraf.mouni عضو محترف الابداع
09 VTC Oracle Performance Tuning


السلام عليكم ورحمة الله

يسعدنى ان اقدم لكم الاسطوانتين الكاملتين من شركة 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/


achraf.mouni غير متواجد حالياً  
رد مع اقتباس
إضافة رد

الكلمات الدلالية (Tags)
oracle, performance, tuning

أدوات الموضوع
انواع عرض الموضوع

تعليمات المشاركة
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك

BB code is متاحة
كود [IMG] متاحة
كود HTML معطلة

الانتقال السريع

المواضيع المتشابهه
الموضوع كاتب الموضوع المنتدى مشاركات آخر مشاركة
formation oracle en algerie??? el3arbi قسم الإستفسارات و الطّلبات 3 27-04-2011 08:42 AM
{شرح مصور} tuning pc 2010 corailbleu تبادل الخبرات في مجال الحاسب 2 30-10-2010 09:55 AM
Tuning et fichiers originaux pour toutes marques de voitures. ouaheb الهندسة الميكانيكية 0 15-12-2009 06:49 PM
كتاب في oracle 10 monarque الإعــلام الآلي والرياضيــات 0 05-12-2008 09:16 PM
AIX : Certification, administration et tuning Ssoft الإعــلام الآلي والرياضيــات 1 03-12-2008 12:25 PM


الساعة الآن 01:37 AM.