ISBN: 0-9727513-8-6 ISBN 13 978-0972751384 Library of Congress Number: 2003112378 358 Pages: Perfect Bind 9x7 Shelving: Databases/Oracle Oracle In-Focus Series # 9

Mike Ault’s Oracle Internals Monitoring & Tuning Scripts Advanced internals & OCP certification insights for the master DBA By Mike Ault Retail Price $34.95 / £20.75 Order now and get immediate online access to the code depot! Only $24.95 (30% off) Key Features About the Author Table of Contents Reader Comments Errata Index

Written by the world's most widely-read DBA and author of over 20 Oracle books, Mike Ault shares his secrets for Oracle DBA management scripts. This handy reference is indispensable for all Oracle professionals who must quickly automate and manage their Oracle databases with scripts. This stellar book comes complete with an online code depot full of over 200 pre-tested Oracle DBA scripts, and covers all areas of Oracle database administration including data files, tablespace, table and index management scripts. Based on more than 20 years full-time experience, Mike Ault brings his expertise to the public with this fantastic book. Your time savings from a single script is worth the price of this great book.

* Presents a complete guide to using Oracle internal tricks for database administration activities. * Describes secret scripts for monitoring and tuning Oracle databases. * Presents a framework for automatic database administration without buying expensive tools. * Provides expert insights into the internal working of the Oracle database. * Reviews mechanisms for automating Oracle database administration tasks. * Comes with a complete code depot of working Oracle scripts.

About the Author:

Mike Ault Mike Ault has five Oracle Masters Certificates. Ault was the first popular Oracle author with his book "Oracle7 Administration and Management" and he also wrote several of the "Exam Cram" books.

Table of Contents:

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

Reader Comments: