|
ISBN:
0-9727513-8-6
ISBN 13
978-0972751384 |
Library of
Congress Number: 2003112378 |
358 Pages:
Perfect Bind 9x7 |
Publication date: October 2003 |
|
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) |
 |
Get the Oracle
Tuning Pack
Six
for $79.95 - A $150.00 value |
|
|
|
|
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
|
Hear what people are saying: Marlene
from Philadelphia, PA says:
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!
|
|
