النتائج 1 إلى 3 من 3

الموضوع: مفاجاة: اسطوانتى VTC Oracle Performance Tuning (1Z0-033)

  1. #1
    عضو
    تاريخ التسجيل
    Oct 2003
    المشاركات
    12
    معدل تقييم المستوى
    0

    Thumbs up مفاجاة: اسطوانتى VTC Oracle Performance Tuning (1Z0-033)



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

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

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

    وتقبلوا منى تحياتى

  2. #2
    عضو برونزي
    تاريخ التسجيل
    Apr 2008
    المشاركات
    1,430
    معدل تقييم المستوى
    11

    رد: مفاجاة: اسطوانتى VTC Oracle Performance Tuning (1Z0-033)

    جزاك الله خيرا

  3. #3
    عضو
    تاريخ التسجيل
    Oct 2003
    المشاركات
    12
    معدل تقييم المستوى
    0

    رد: مفاجاة: اسطوانتى VTC Oracle Performance Tuning (1Z0-033)



    شكرا على الرد

المواضيع المتشابهه

  1. سؤال : من يعرف عن "Oracle Real Application Clusters "Oracle RAC
    بواسطة محمود العازم في المنتدى الأرشيف
    مشاركات: 3
    آخر مشاركة: 18-06-2012, 09:38
  2. Troubleshooting Oracle Performance
    بواسطة bloodyelf في المنتدى الأرشيف
    مشاركات: 1
    آخر مشاركة: 23-12-2011, 22:23
  3. هل من مشمر Intel Extreme Tuning Utility؟
    بواسطة kingheart في المنتدى الأرشيف
    مشاركات: 7
    آخر مشاركة: 02-09-2011, 17:50
  4. I need a book for Oracle Certified Associate, Oracle Solaris 10 Operating System
    بواسطة oldtown في المنتدى الأرشيف
    مشاركات: 1
    آخر مشاركة: 15-01-2011, 13:35
  5. ارجو المساعده في تشفير اسطوانتى للبرامج
    بواسطة zizos في المنتدى الأرشيف
    مشاركات: 1
    آخر مشاركة: 28-03-2008, 04:53

الكلمات الدلالية لهذا الموضوع

المفضلات

ضوابط المشاركة

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