Chapter 1 - Instance Internals Scripts
Monitoring Control Files and Initialization Parameters
Monitoring Control Files
Monitoring Database Initialization Parameters
Monitoring Undocumented Initialization Parameters
Monitoring Locks and Latches
Monitoring Sessions Causing Blocked Locks
Monitoring DDL and DML Locks
Monitoring Internal Locks
Monitoring Waits
Monitoring Events
Workspaces in Oracle9i
Chapter 2 - Inside the Shared Pool
Monitoring and Tuning the Shared Pool
Conclusions about the Shared Pool
Guideline 1
Guideline 2
Guideline 3
Pinning the PL/SQL Packages in the Shared Pool
The Shared Pool and the MTS
Large Pool Sizing
Disk IO and the Shared Pool
Monitoring Library and Data Dictionary Caches
Guideline 7
Shared Pool Summary
Chapter 3 - Data Buffer Internals Scripts
Classic DB Block Buffer Tuning
Tuning the Multi-part Oracle8 Buffer Cache
Use of the Default Pool
Use of the KEEP Pool
Use of the RECYCLE Pool
Sizing the Default Pool
Sizing the Keep Pool
Sizing the Recycle Pool
Tuning the Three Pools
Chapter 4 - The Undocumented Oracle Parameters
Inside the Undocumented Parameters
Tuning the Database Writer with Undocumented Parameters
Hidden Parameters with Inappropriate Default Values
Immutable Hidden Parameters
Oracle Recovery with --ALLOW--RESETLOGS--CORRUPTION
Procedure
Chapter 5 - Oracle Event Internals
Event Classes
The Initialization File Event Settings
Example Uses of the EVENT Initialization Parameter
Events at the Session Level
Example Uses of the ALTER SESSION Command to Set EVENT Codes
Seeing which Events are Set in a Session
Using DBMS--SYSTEM.SET--EV and
DBMS--SYSTEM.READ--EV
Chapter 6 - Tablespace and File Internals Scripts
Monitoring Tablespace Free space and Fragmentation
Monitoring Tablespace Autoextend Settings
Monitoring Tablespace Data Files
Monitoring Tablespace Extent Mapping
Monitoring Rollback Segments
Monitoring Rollback Usage and Statistics
Monitoring Rollback Current Usage
Monitoring Rollback Transaction Size
Monitoring Deferred Rollback Segments
Monitoring Redo Log Activity
Monitoring Redo Log Status
Monitoring Redo Log Switches
Monitoring Redo Statistics
Directory and Library Internals
Monitoring Directories
Monitoring Libraries
Chapter 7 - Storage and Object Internal Scripting
Monitoring Ownership, Placement, and Clustering
Monitoring Size of Tables
Table Statistics Scripts
Table Type Internals
Table Columns Internals
Table Column Statistics Internals
Table Key Internals
Finding Tables with Chained Rows
Using the ANALYZE Command
Partitioned Table Internals
Monitoring Partition Statistics
Table Sub-partition Internals
Monitoring Sub-partition Statistics
Nested Table Internals
External Table Internals
Cluster Table Internals
Monitoring Table Cluster Storage Statistics
Monitoring Cluster Statistics
Monitoring Cluster Hash Expressions
Monitoring Oracle8 Types, Collections, Methods, and Operators
Monitoring Types
Monitoring Type Collections
Monitoring Type Methods
Monitoring Type REFs
Monitoring Operators
Monitoring Dimensions
Monitoring Stored Outlines
Monitoring Outline Hints
Monitoring of Materialized Views and Materialized View Logs
Using DBA-- and V$ type Views
Chapter 8 - Index Internals Scripting
Monitoring Index Statistics
Monitoring Partitioned Indexes
Function-based Index (FBI) Internals
Domain Index Internals
Bitmap Join Index Internals
Chapter 9 - Security Internals Scripts
Table Security Internals
Using the V$ and DBA-- Views for Monitoring Users
Monitoring User Setup
Monitoring User Roles
Monitoring User Table and Column Grants
Monitoring Currently Logged-in User Processes
Monitoring Profiles
Audit Table Monitoring
