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