OCP Oracle 9i Database Performance Tuning考试指南(英文版)(Exam1Z0-033) (2010 年度畅销榜NO.11448 )

\r\n

ACKNOWLEOGMENTS\r\n\r\nINTROOUCTION\r\nPART I\r\n\r\nOCP Tuning Exam Guide\r\n\r\n1 Database Tuning Overview\r\n\r\nHow This Book Is Organized\r\nTopics Covered in the OCP OBA Tuning Exam\r\nThe Oracle Performance Tuning Methodoiogy\r\nDiagnostics and Tuning Tools\r\nSizing the Shared Pool\r\nSizing the Buffer Cacbe\r\nSizing Other SGA Structures\r\nDatabase Configuration and I/O lssues\r\nOptimizing Sort Operdtions\r\nDidgnosing Contention for Latches\r\nTuning Rollback or UNDO Segments\r\nMonitoring and Detecting Lock Contention\r\nTuning Oracle Sbared Server\r\nApplication Tuning\r\nUsing Oracle Blocks Efficiently\r\nSQL Statement Tuning\r\nOS Considerations\r\nTuning Overview\r\nWhy Do We Performance Tune?\r\nWhat Is Performance Tuning?\r\nWhere Do I Tune7\r\nHow Do I Performance Tune?\r\nWhen Do I Tune?\r\nHow Do I Know If My Performance Tuning Efforts Are\r\nActually Working?\r\nTo Advance Your Tuning Knowledge\r\n\r\n2 Oracle Performance Tuning Methodology\r\n\r\nOracle Performance Tuning Method\r\nDescribe the Roles Associated with the Database Tuning Process\r\nDescribe the Dependency Between Tuning in Different\r\nDeve1opment Phases\r\nDescribe SLAs\r\nDescribe the Tuning Goals\r\nDescribe the Most Common Tuning Problems\r\nDescribe Tuning Goals Associated with Different Types\r\nof Applications\r\nPerformance and Safety Trade-Offs\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n3 Diagnostic and Tuning Tools\r\n\r\nDiagnostic and Tuning Tools\r\nThe Data Dictionary and Dynamic Performance Views Related to Tuning\r\nData Dictionary Views\r\nHow the ANALYZE Command Is Used with Data\r\nDictionary Views\r\nDynamic Performance Views\r\nCurrent State Views\r\nAccumulator Views\r\nInformational Views\r\nStatistics in the Dynamic Performance Views\r\nInstance/Database Performance Views\r\nMemory\r\nDisk\r\nContention\r\nSession-Related\r\nWhat Is Statspack?\r\nInstalling and Configuring Statspack\r\nInteractive or Batch Installations\r\nStatspack Maintenance\r\nConfiguring Statspack Statistics Gathering\r\nCollect Statistics Using Statspack\r\nTake a Snapshot\r\nAutomating Snapshots\r\nProducing a Performance Report\r\nContents of the Statspack Performance Report\r\nOther Tools That Can Be Used for Tuning\r\nUTLBSTATUTLESTAT\r\nOEM Oracle Expert\r\nCustom Tools\r\nThe A1ert Log and Trace Files\r\nInstance Alert Log\r\nTrace User SQL\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n4 Sizing the Shared Pool\r\n\r\nSizing the Shared Pool\r\nShared Pool Concepts\r\nMeasure and Tune the Library Cache Hit Ratio\r\nSize and Pin Objects in the Shared Pool\r\nTune the Shared Pool Reserve Space\r\nMeasure and Tune the Dictionary Cache Hit Ratio\r\nDescribe UGA and Session Memory Considerations\r\nSetting the Large Pool\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n5 Sizing the Buffer Cache\r\n\r\nSizing the Buffer Cache\r\nDescribe How the Buffer Cache Is Used by Different\r\nDracle Processes\r\nDescribe the Tuning lssues Related to the Buffer Cache\r\nCetting Advice about the Buffer Cache Size\r\nImplement Dynamic SGA Allocation\r\nMonitor the Use of the Buffer Cache and the Different\r\nPoo1s Within the Buffer Cache\r\nCreate and Size Multiple Buffer Pools\r\nMake Appropriate Use of Table Caching\r\nDiagnose LRU Latch Contention\r\nDiagnose Freelist Contention\r\nDeprecated Buffer Cache Parameters\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n6 Sizing Other SGA Structures\r\n\r\nSizing Other SGA Structures\r\nMonitor and Size the Redo Log Buffer\r\nMonitor and Size the Java Pool\r\nLimit the Amount of Java Session Memory Used by a Session\r\nConfiguring I/O Slaves\r\nConfiguring Multiple DBW Processes\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n7 Database Configuration and I/O lssues\r\n\r\nDatabase Configuration and I/O Issues\r\nDescribe Reasons for Distributing Different Oracle File Types\r\nDiagnose Inappropriate Use of Tablespaces\r\nTune Full Table Scan Operations\r\nDescribe How Checkpoints Work\r\nMonitor and Tune Checkpoints\r\nMonitor and Tune Redo Logs\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n8 Optimize Sort Operations\r\n\r\nOptimize Sort Operations\r\nDescribe How Sorts Are Performed in Oracle\r\nSet Old and New Sort Parameters\r\nDescribe the Operations That Cause Sorting\r\nDifferentiate Between Disk and Memory Sorts\r\nCreate and Monitor Temporary Tablespaces\r\nDescribe Ways to Reduce Total Sorts and Disk Sorts\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n9 Diagnosing Contention for Latches\r\n\r\nDiagnosing Contention for Latches\r\nDescribe the Purpose of Latches\r\nDescribe the Different Types of Latch Requests\r\nDescribe How to Diagnose Contention for Latches\r\nIdentify the Resources to Be Tuned to Minimize Latch Contention\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n10 Tuning Rollback or Undo Segments\r\n\r\nTuning Rollback/Undo Segments\r\nUse the Dynamic Performance Views to Check Rollback\r\nSegment Performance\r\nDefine the Number and Size of Manual Rollback Segments\r\nAppropriately Allocate Rollback Segments to Transactions\r\nUnderstand and Expiain the Concept of Automatic Undo\r\nManagement\r\nCreate and Maintain Automatically Managed Undo Tablespace.\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n11 Monitoring and Detecting Lock Contention\r\n\r\nMonitoring and Detecting Lock Contention\r\nDefine Levels of Locking\r\nDescribe PossibIe Causes of Contention\r\nUse Oracle Utilities to Detect Lock Contention\r\nResolve Contention in an Emergency\r\nPrevent Locking Problems\r\nRecognize Oracle Errors Arising from Deadlocks\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n12 Tuning Oracle Shared Server\r\n\r\nTuning Oracle Shared Server\r\nIdentifying Issues Associated with Managing Users in a\r\nShared Server Environment\r\nDiagnosing and Resolving Performance Issues with\r\nShared Server Processes\r\nConfigure the Shared Server Environment to Optimize\r\nPerformance\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\nl3 Application Tuning\r\n\r\nApplication Tuning\r\nDescribe the Role of the DBA in Tuning Applicatior\r\nExplain Different Storage Structures\r\nExplain and Describe Clustering Options\r\nExplain the Different Types of Indexes\r\nExplain IOTs\r\nDescribe Materialized Views and the Use of Query Rewrites\r\nList Requirements for OLTP, DSS, and Hybrid Systems\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\nl4 Using Oracle Blocks Efficiently\r\n\r\nUsing Oracle Blocks Efficiently\r\nDescribe the Correct Usage of Extents and Oracle Blocks\r\nExplain Space Usage and the High Watermark\r\nDetermine the High Watermark\r\nRecover Space from Sparsely Populated Segments\r\nDescribe the Use of Oracle Block Parameters\r\nDescribe and Detect Chaining and Migration of Oracle Blocks\r\nPerform Index Reorganization\r\nMonitor Indexes to Determine Usage\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n15 SQL Statement Tuning\r\n\r\nSQL Statement Tuning\r\nDescribe How the Optimizer Is Used\r\nExplain the Concept of Plan Stabi1ity.\r\nUse of Stored Outlines\r\nDescribe How Hints Are Used\r\nCollect Statistics on Indexes and Tables\r\nDescribe the Use of Histograms\r\nCopy Statistics Between Databases\r\nOLTP and OSS Considerations\r\nUse SQL Trace and TKPROF\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n16 OS Considerations and Oracle Resource Manager\r\n\r\nOS Considerations\r\nDescribe Different System Architectures\r\nUnderstand Virtual Memory and Paging\r\nDescribe the Primary Steps of OS Tuning\r\nIdentify Similarities Between OS and DB Tuning\r\nExplain the Difference Between a Process and a Thread\r\nDatabase Resource Manager\r\nConfiguring Resource Management\r\nAdminister Resource Manager\r\nChapter Summary\r\nTwo-Minute Drill\r\nChapter Questions\r\nAnswers to Chapter Questions\r\nPART II\r\nPractice Exams\r\n\r\n17 Practice Exam I and 2\r\n\r\nPractice Exam 1 Questions\r\nAnswers to Practice Exam 1 Questions\r\nPractice Exam Two\r\nPractice Exam 2 Questions\r\nAnswers to Practice Exam 2 Questions\r\nGlossary\r\n\r\nIndex