Tuning Third-Party Vendor Oracle Systems: Tuning When You Can't Touch the Code Online access for BTH

TeamLiB......Page 1
Cover......Page 2
Publication Information......Page 5
Table Of Contents......Page 7
Tuning Overview......Page 12
What Can Be Done?......Page 13
Database Buffer Tuning......Page 14
Database Writer Tuning......Page 17
What is the shared pool?......Page 19
Monitoring and Tuning the Shared Pool......Page 21
Putting it All In Perspective......Page 28
What to Pin......Page 33
The Shared Pool and MTS......Page 35
Large Pool Sizing......Page 36
A Matter Of Hashing......Page 37
Caches......Page 41
In Summary......Page 43
Tuning Checkpoints......Page 44
Tuning Redo Logs......Page 45
Redo Log Sizing......Page 46
Tuning Rollback Segments......Page 49
Tuning Oracle Sorts......Page 53
Optimizer Modes......Page 55
Use of The KEEP Pool......Page 56
Tuning the Three Pools......Page 57
Adding Resources......Page 58
Table Rebuilds......Page 59
BookmarkTitle:......Page 0
Rebuilding Indexes......Page 60
Bitmapped Index Usage*......Page 63
Function Based Indexes......Page 66
Reverse Key Indexes......Page 68
Index Organized Tables......Page 69
Partitioned Tables and Indexes......Page 70
Partitioned Indexes......Page 72
Oracle8 Enhanced Parallel DML......Page 73
Use of The KEEP Pool......Page 77
Sizing the Keep Pool......Page 78
Tuning the Three Pools......Page 79
Using Outlines in Oracle8i......Page 80
Creation of a OUTLINE object......Page 81
Altering a OUTLINE......Page 82
DROP_ UNUSED......Page 83
DROP_ BY_ CAT......Page 84
UPDATE_ BY_ CAT......Page 85
Summary......Page 86
Creating a Resource Plan......Page 87
DBMS_ RESOURCE_ MANAGER Package......Page 93
Syntax for the UPDATE_ PLAN Procedure:......Page 95
Syntax for the UPDATE_ RESOURCE_ GROUP Procedure:......Page 96
Syntax for the CREATE_ PLAN_ DIRECTIVE Procedure:......Page 97
Syntax for the UPDATE_ PLAN_ DIRECTIVE Procedure:......Page 98
Syntax of the VALIDATE_ PENDING_ AREA Procedure:......Page 99
Syntax of the CLEAR_ PENDING_ AREA Procedure:......Page 100
Syntax of the SWITCH_ CONSUMER_ GROUP_ FOR_SESS Procedure:......Page 101
Syntax for the GRANT_ SYSTEM_ PRIVILEGE Procedure:......Page 102
Syntax of the GRANT_ SWITCH_ CONSUMER_ GROUP Procedure:......Page 103
Usage Notes......Page 104
Presentation Summary......Page 105