VTC Oracle 9i教程 VTC.Oracle.Performance.Tuning.1Z0-033 1Z0-033 Oracle 9i调整 Turnin

游客，本帖隐藏的内容需要积分高于 1 才可浏览，您当前积分为 0

资源信息： 中文名: VTC Oracle 9i教程 英文名: VTC.Oracle.Performance.Tuning.1Z0-033 资源格式: 光盘镜像 版本: 1Z0-033 Oracle 9i调整(Turning)认证考试 地区: 美国 对白语言: 英语 概述: 转自TLF http://img701.photo.wangyou.com/2004/12/11/35926/200511174985990.jpg 语言：英语 网址：http://vtc.com/products/oracletuning.htm 类别：教程 VTC的作者Gavin Powell提供了1Z0-033 Oracle 9i调整（Turning）认证考试，包括基本的调整操作和调整工具。内存调整包括共享池、数据库缓存和其它缓存。通过I/O观察，讨论了数据库的物理文件结构、 tablespaces和block leve的l数据文件。 还有排列、锁定、关闭和等待事件、共享和提供服务进程、状态和SQL代码调整和资源管理等。 另外还有操作系统的调整以及专用对象。学习时只要点击Oracle Performance Tuning (1Z0-033) 的其中一课即可。 教程内容： Introduction Welcome Prerequisites for this Course About this Course pt. 1 About this Course pt. 2 Oracle Tuning Documentation What is Performance Tuning? Who Tunes and What Do They Tune? The Different Stages of Tuning Development/Testing/Production Statistics and Performance Evaluation Goal Oriented Tuning Common Problems pt. 1 Common Problems pt. 2 Performance Versus Integrity Oracle Enterprise Manager (OEM) Performance Tools The Alert Log Process Trace Files User Trace Files Setting Up Tracing TKPROF Manually Collecting Statistics STATSPACK and Collecting Statistics Collecting Statistics in OEM Introducing the Wait Event Interface What to Tune Tuning the Shared Pool The Shared Pool Shared Pool Efficiency Shared Pool and Reserved Shared Pool Library and Dictionary Cache Hit Ratios Pinning Objects in the Shared Pool The Large Pool Caching Cursors OEM and the Shared Pool Performance Views The Database Buffer Cache Database Buffer Cache Efficiency OLTP Versus Data Warehouse Configure the Database Buffer Cache Examine the Database Buffer Cache The Buffer Cache Hit Ratio Processes and the Buffer Cache How to Tune Buffer Cache How Else to Tune Buffer Cache Free List Contention Multiple Database Writers and Slaves Monitor Buffer Cache and Subset Pools OEM and the Database Buffer Cache Performance and Metadata Views Other Buffers Tuning the Redo Log Buffer Sizing the Redo Log Buffer The Java Pool Configuring Automatic PGA Memory Configuring Manual PGA Memory Tuning PGA Memory Changing SGA Memory Online SGA_MAX_SIZE Changing Non SGA Memory Online Performance Views Tuning I/O: Physical File Structures Datafiles/Tablespaces/Objects Control Files and Recoverability Distribution of Database Files Dividing Data Across Tablespaces Oracle Partitioning Tablespace Storage Structures Dictionary Managed Tablespaces Locally Managed Tablespaces Finding Tablespace Problems Redo and Archive Log Files pt. 1 Redo and Archive Log Files pt. 2 Physical Structures in OEM Performance Views Metadata Views Tuning I/O at the Block Level Segments Extents and Blocks The High Water Mark Reclaiming Unused Space Row Chaining and Row Migration Reorganizing Indexes Detecting Problems With Indexes Metadata Views Tuning Sorts How Does Sorting Work? Which SQL Code Causes Sorting? Demonstrating SQL Code Sorting Sorting in Memory and on Disk Analyzing Sorting Minimizing Sorting Sorting in OEM Performance Views Locking Issues Locking Levels Types of Contention pt. 1 Types of Contention pt. 2 Types of Locks Detecting Lock Contention How to Avoid Locking Lock Monitoring and Removal in OEM Performance and Metadata Views pt. 1 Performance and Metadata Views pt. 2 Latches and Wait Events What is a Latch? Different Types of Latches Shared Pool Latches pt. 1 Shared Pool Latches pt. 2 Database Buffer Cache Latches pt. 1 Database Buffer Cache Latches pt. 2 Database Buffer Cache Latches pt. 3 Redo Log Latches Session Connection Latches Latch Spins, Misses and Sleeps Latch Miss Rate Latch Miss Total Time What is a Wait Event? Event Types and TIMED_STATISTICS Idle Wait Events Querying Significant Wait Events Wait Events in an Active Database Analyzing Significant Wait Events The Wait Event Interface The Wait Event Interface in OEM Performance Views Shared Servers and Dedicated Servers Tuning Oracle Net Services Shared Versus Dedicated Servers Shared Server Configuration Oracle Net Manager in OEM Wait Events and Performance Views pt. 1 Wait Events and Performance Views pt. 2 Statistics What are Statistics? The Importance of Realistic Statistics Statistics and OPTIMIZER_MODE Statistics and CURSOR_SHARING CBO Parameters pt. 1 CBO Parameters pt. 2 CBO Parameters pt. 3 Gathering Statistics using ANALYZE Histograms and the ANALYZE Command Gathering Statistics using DBMS_STATS Gathering Statistics using OEM What is STATSPACK? Installing and Using STATSPACK Metadata Views Applications and Specialized Objects Database Type Requirements Oracle Special Storage Structures pt. 1 Oracle Special Storage Structures pt. 2 Applying Storage Structures Creating BTree and Bitmap Indexes Syntax Creating BTree and Bitmap Indexes Examples Creating Index Organized Tables Creating Clusters Creating Materialized Views Oracle Partitioning Methods Syntax Oracle Partitioning Methods Examples pt. 1 Oracle Partitioning Methods Examples pt. 2 Metadata Views SQL Code Tuning Building Efficient SQL Code Tuning Query Clauses pt. 1 Tuning Query Clauses pt. 2 Tuning Query Clauses pt. 3 Comparisons Joins Other Factors pt. 1 Other Factors pt. 2 SQL Code Execution Process The Optimizer and What It Does The Internal Machinations of the Optimizer pt. 1 The Internal Machinations of the Optimizer pt. 2 Hints Types of Hints Influence the Optimizer pt. 1 Influence the Optimizer pt. 2 Alter Table Scans Alter Index Scans pt. 1 Alter Index Scans pt. 2 Modify Joins pt. 1 Modify Joins pt. 2 Perform SQL in Parallel Change Queries and Subqueries Finding Queries with Problems EXPLAIN PLAN and the PLAN_TABLE Autotrace in SQL*Plus SQL Trace and TKPROF pt. 1 SQL Trace and TKPROF pt. 2 Finding Bad Queries in OEM Plan Stability and Stored Outlines Performance and Metadata Views Resource Management The Oracle Resource Manager Resource Manager Components Resource Plan Directives Create Groups and Plans and Allocate Metadata and Performance Views The Operating System Basic Operating System Tuning Virtual Memory/Paging/Swapping What Determines I/O Distribution? Database Function and Methods of Distribution Oracle Database File Types Distribution Database Block Size Resource Consumption in OEM Conclusion Wrapping it All Up! Credits About the Author ? ? 苘? 捋? 苘圹圹鄄圹曹苘 苒圹? 宁?苒圹圻哌 哌圹鄄圹 哪哪哪哪哪哪哪哪哪?圹圹圯哪哪哪哪哪哪哪哪哪哪哪宁 ??苒圹圻 鞍鞍鞍鞍 咣圹槽?鞍鞍鞍鞍鞍鞍鞍鞍 鄄圹圹 鞍鞍鞍 苘槽圮鞍鞍鞍鞍 鞍鞍 ?捋鄄? 圹圹槽 鄄圹圹? 苓圹圹槽? ? 圹鄄 圹圹槽 薏圹圹? ? 圹圹槽? 圹圹? 苘? 捋圹鄄? 苘? 鄄圹圹 捋鄄辈草 捋哕苒圯 茌圹圹槽捋圹圹鄄苘 圹槽圯 鄄北辈?x!FEAR ?北北掭圹鄄?北北?苓咻圹圹槽 哌咣圹圹槽?鄄圹荼北北北北北捋鄄鞍臂 北北北?? 苒鄄槽 捋圹槽? 咣圹鄄圮咣圹 捋鄄卑臂 鞍鞍?捋鄄辈圯鞍鞍鞍? 圹鄄圹 馨鞍鞍 咣圹槽?槽郯鞍鞍鞍鞍 圯圹北辈??鞍鞍鞍 捋脖氨圹 圹鄄圹 圻 圹圹槽 槽圮 苒?捋脖膊? 圹脖草槽? 苘圹圹圻苒 圹圹草 哌圹圮苒圹? 捋鄄槽 ? 圹鄄圹 哌圹槽圹策哕鄄? 捋圹鄄 哌哌 鄄圻 鞍鞍 馨捋槽圹?? 哌?咣鄄草?鞍鞍鞍鞍鞍?圹鄄?鞍鞍鞍鞍鞍鞍?圹 鞍鞍鞍鞍?? 鞍鞍 咣圹哌 鞍鞍鞍鞍鞍捋脖槽 鞍鞍鞍鞍鞍鞍佰圹槽 鞍鞍 鞍鞍鞍鞍 ?鞍鞍鞍鞍? 哪哪哪哪哪哪哪哪哪哪 鄄卑臂?哪哪哪哪哪 捋圹草哪哪哪哪哪哪哪 ?哪哪哪哪哪? 北??北北北北北北北北 圹脖草曹 北北北北?圹鄄?北北北北北北北北北北北北北北北 哪哪哪哪哪哪哪哪哪 苒圹槽?槽?哪哪哪苒圹槽 哪哪宁哪哪哪哪哪哪哪哪哪哪宁 咣圹槽?咣圹苘苒圹圹策 哌 哌圹鄄哌? 谀哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪目 楚? ?RELEASE iNFORMATiON ? ? 滥履哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪穆馁 嘲? TiTLE : VTC Oracle Performance Tuning 1Z0-033 Tutorials 嘲? 嘲? 嘲? 嘲? 嘲? 嘲媚哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪穆哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪拇俺 嘲? TYPE : BOOKWARE ? Cracker : TEAM DDU 嘲? 嘲媚哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪呐哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪拇俺 嘲? FiLES : 29 X 15MB ? PACKAGER : TEAM DDU 嘲? 嘲媚哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪呐哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪拇俺 嘲? TOTAL CDs: 1 CD ? SUPPLiER : TEAM DDU 嘲? 嘲媚哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪呐哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪拇俺 嘲? PLATFORM : WINDOWS ? FORMAT : BIN/CUE 嘲? 嘲媚哪哪哪哪哪哪哪哪哪哪哪哪哪哪?哪哪呐哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪拇俺 嘲? RLS DATE : 02/04/05 ? PROTECTiON : NONE 嘲? 谀聊哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪牧哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪牧目 楚? ?RELEASE NOTES ? ? 滥履哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪穆馁 嘲? 嘲? 嘲?[Product Information] 嘲? 嘲? 嘲? 嘲? VTC author, Gavin Powell, 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 Oracle Performance Tuning (1Z0-033) lessons. 嘲? 嘲? 嘲? 嘲? 嘲? 嘲? 嘲? 嘲? 嘲? 嘲? 嘲? 嘲?Its all about sharing. 嘲? 嘲? 嘲? 嘲? 嘲? 嘲? 嘲? 嘲?[Install Information] 嘲? 嘲? 嘲? 嘲?Unpack it 嘲? 嘲? 嘲? 嘲?[For more information] 嘲? 嘲? 嘲? 嘲?http://vtc.com/products/oracletuning.htm 嘲? 嘲? 嘲? 嘲? 嘲? 谀聊哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪牧目 楚? ?CONTACT iNFORMATiON ? ? 滥履哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪穆馁 嘲? 嘲? 嘲? Suppliers/SiteOPs Needed 嘲? 嘲? 嘲? 嘲? Email: TeamDDU[at]hotmail[dot]com 嘲? 嘲? 嘲? 谀聊哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪牧目 楚?TEAM DDU ( Day Day UP ) 2004 x!FEAR ? 滥哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪哪馁