Mike Ault Rampant TechPress, Paperback, Published December 2003, 358 pages, ISBN 0972751386
	List Price: $34.95 Our Price: $21.95 You Save: $13.00 (37% Off)
	Availability: Out-Of-Stock

Write a Review and tell the world about this title!

People who purchase this book frequently purchase:

• Oracle SQL Tuning & CBO Internals; Kimberly Floss, $17.95, 36% Off!
• Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning; Kirtikumar Deshpande, et al, $31.50, 41% Off!
• Optimizing Oracle Performance; Cary Millsap, et al, $20.95, 40% Off!
• Oracle Performance Troubleshooting: With Dictionary Internals, SQL & Tuning Scripts; Robin Schumacher, $17.95, 36% Off!

• Databases : Oracle

• Rampant TechPress

Written by the world's top DBA and author of over 14 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.

Key Features:

• 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.

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

Mike started working with computers in 1979 right out of a stint in the Nuclear Navy.
He began working with Oracle in 1990 and has since become a World Renowned
Oracle expert (in the words of his publisher anyway!) Mike has written 14 Oracle
related books, dozens of articles, and has presented at conferences in Europe and the
USA. Mike has two wonderful daughters and is kept out of trouble by his wife of 29
years, Susan.

Jan 8, 2004     Marlene Theman (marlereth3@hotmail.com) from Philly, PA
Absolure monitoring
I have all of Mr. Ault's books, and this one is one of his best works. It contains loads of working scripts and an Internet code download to get the working code. It also has excellent explainations of the concepts and internals from the output of the scripts.

This is definitely not a beginner book, and it is as complex as any of the other advanced Oracle books. If you want super-deep details, this book is for you!

Forgot your password? FAQs Shipping Options Returns Your Orders Your Account