Tuning Third Party Vendor Oracle Systems

Team DDU......Page 1
Notice ......Page 4
Publication Information ......Page 5
Table Of Contents  ......Page 6
Tuning Overview ......Page 11
What Can Be Done? ......Page 12
Database Buffer Tuning ......Page 13
Database Writer Tuning ......Page 16
What is the shared pool? ......Page 18
Monitoring and Tuning the Shared Pool  ......Page 20
Putting it All In Perspective ......Page 27
What to Pin  ......Page 32
The Shared Pool and MTS ......Page 34
Large Pool Sizing  ......Page 35
A Matter Of Hashing  ......Page 36
Monitoring Library and Data Dictionary Caches  ......Page 40
In Summary  ......Page 42
Tuning Checkpoints ......Page 43
Tuning Redo Logs  ......Page 44
Redo Log Sizing  ......Page 45
Tuning Rollback Segments ......Page 48
Tuning Oracle Sorts ......Page 52
Optimizer Modes ......Page 54
Use of The KEEP Pool  ......Page 55
Tuning the Three Pools ......Page 56
Adding Resources ......Page 57
Table Rebuilds ......Page 58
Rebuilding Indexes ......Page 59
Bitmapped Index Usage* ......Page 62
Function Based Indexes ......Page 65
Reverse Key Indexes  ......Page 67
Index Organized Tables ......Page 68
Partitioned Tables and Indexes ......Page 69
Partitioned Indexes  ......Page 71
Oracle8 Enhanced Parallel DML  ......Page 72
Use of The KEEP Pool  ......Page 76
Sizing the Keep Pool  ......Page 77
Tuning the Three Pools ......Page 78
Using Outlines in Oracle8i  ......Page 79
Creation of a OUTLINE object  ......Page 80
Altering a OUTLINE ......Page 81
DROP_UNUSED  ......Page 82
DROP_BY_CAT ......Page 83
UPDATE_BY_CAT ......Page 84
Summary ......Page 85
Creating a Resource Plan ......Page 86
DBMS_RESOURCE_MANAGER Package ......Page 92
Syntax for the UPDATE_PLAN Procedure:  ......Page 94
Syntax for the UPDATE_RESOURCE_GROUP Procedure:  ......Page 95
Syntax for the CREATE_PLAN_DIRECTIVE Procedure: ......Page 96
Syntax for the UPDATE_PLAN_DIRECTIVE Procedure:  ......Page 97
Syntax of the VALIDATE_PENDING_AREA Procedure:  ......Page 98
Syntax of the CLEAR_PENDING_AREA Procedure:  ......Page 99
Syntax of the SWITCH_CONSUMER_GROUP_FOR_ SESS Procedure:  ......Page 100
Syntax for the GRANT_SYSTEM_PRIVILEGE Procedure: ......Page 101
Syntax of the GRANT_SWITCH_CONSUMER_GROUP Procedure:  ......Page 102
Usage Notes ......Page 103
Presentation Summary ......Page 104