Sumário Itens Encontrados: 89Introduction 1Tuning Overview 1What Can Be Done? 2Optimizing Oracle Internals 3Database Buffer Tuning 3Database Writer Tuning 6Shared Pool Tuning 8What is the shared pool? 8Monitoring and Tuning the Shared Pool 10Putting it All In Perspective 17What to Pin 22The Shared Pool and MTS 24Large Pool Sizing 25A Matter Of Hashing 26Monitoring Library and Data Dictionary Caches 30In Summary 32Tuning Checkpoints 33Tuning Redo Logs 34Redo Log Sizing 35Tuning Rollback Segments 38Tuning Oracle Sorts 42Optimizer Modes 44Tuning the Multi-part Oracle8 Buffer Cache 45Use of the Default Pool 45Use of The KEEP Pool 45Use of the RECYCLE Pool 46Tuning the Three Pools 46Adding Resources 47Tuning Tables and Indexes 48Table Rebuilds 48Rebuilding Indexes 49Adjusting Index Cost in Oracle8 52Bitmapped Index Usage* 52Function Based Indexes 55Reverse Key Indexes 57Index Organized Tables 58Partitioned Tables and Indexes 59Partitioned Indexes 61Parallel Query 62Oracle8 Enhanced Parallel DML 62Managing Multiple Buffer Pools in Oracle8 66Use of the Default Pool 66Use of The KEEP Pool 66Use of the RECYCLE Pool 67Sizing the Default Pool 67Sizing the Keep Pool 67Sizing the Recycle Pool 68Tuning the Three Pools 68Using Outlines in Oracle8i 69Creation of a OUTLINE object 70Altering a OUTLINE 71Dropping an OUTLINE 72Use of the OUTLN_PKG To Manage SQL Stored Outlines 72DROP_UNUSED 72DROP_BY_CAT 73UPDATE_BY_CAT 74Summary 75Using Oracle8i Resource Plans and Groups 76Creating a Resource Plan 76DBMS_RESOURCE_MANAGER Package 82DBMS_RESOURCE_MANGER Procedure Syntax 84Syntax for the CREATE_PLAN Procedure: 84Syntax for the UPDATE_PLAN Procedure: 84Syntax for the DELETE_PLAN Procedure: 85Syntax for the CREATE_RESOURCE_GROUP Procedure: 85Syntax for the UPDATE_RESOURCE_GROUP Procedure: 85Syntax for the DELTE_RESOURCE_GROUP Procedure: 86Syntax for the CREATE_PLAN_DIRECTIVE Procedure: 86Syntax for the UPDATE_PLAN_DIRECTIVE Procedure: 87Syntax for the DELETE_PLAN_DIRECTIVE Procedure: 88Syntax for CREATE_PENDING_AREA Procedure: 88Syntax of the VALIDATE_PENDING_AREA Procedure: 88Usage Notes For the Validate and Submit Procedures: 89Syntax of the CLEAR_PENDING_AREA Procedure: 89Syntax of the SUBMIT_PENDING_AREA Procedure: 90Syntax of the SET_INITIAL_CONSUMER_GROUP Procedure: 90Syntax of the SWITCH_CONSUMER_GROUP_FOR_ SESS Procedure: 90Syntax of the SWITCH_CONSUMER_GROUP_FOR_ USER Procedure: 91DBMS_RESOURCE_MANAGER_PRIVS Package 91DBMS_RESOURCE_MANGER_PRIVS Procedure Syntax 91Syntax for the GRANT_SYSTEM_PRIVILEGE Procedure: 91Syntax for the REVOKE_SYSTEM_PRIVILGE Procedure: 92Syntax of the GRANT_SWITCH_CONSUMER_GROUP Procedure: 92Usage Notes 93Syntax of the REVOKE_SWITCH_CONSUMER_GROUP Procedure: 93Section Summary 94COPYRIGHT © 2003 RAMPANT TECHPRESS ALL RIGHTS RESERVED.ROBO BOOKS MONOGRAPH TUNING WHEN YOU CAN'T TOUCH THE CODEPresentation Summary 94