ISBN: 0-9727513-8-6 ISBN 13 978-0972751384 Library of Congress Number: 2003112378 358 Pages: Perfect Bind 9x7 PD 1003 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         Get the Oracle Tuning Half-Pack Three for $79.95 - A $125.00 value Oracle Tuning: The Definitive Reference 2nd Edition $69.95 Oracle Replication $27.95 Oracle Silver Bullets $27.95

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

Index:

_ _affinity _allow_error_simulation _allow_read_only_corruption _allow_resetlogs_corruption _always_star_transformation _compatible_no_recovery _corrupt_blocks_on_stuck_ recovery _corrupted_rollback_segments _cpu_count _cpu_to_io _cursor_db_buffers_pinned _db_always_check_system_ts _db_block_cache_protect _db_block_hash_buckets _db_block_hash_latches _db_block_hi_priority_batch_size _db_block_max_scan_cnt  _db_block_max_scan_count _db_block_med_priority_ batch_size _db_block_no_idle_writes _db_block_write_batch _db_cache_advice _db_handles _db_handles_cached _db_large_dirty_queue _db_no_mount_lock _db_writer_chunk_writes _db_writer_scan_depth _db_writer_scan_depth_ decrement _db_writer_scan_depth_ ncrement  _debug_sga _disable_logging _distributed_lock_timeout _dss_cache_flush  _eliminate_common_subexpr _enqueue_hash_chains _enqueue_locks _fast_full_scan_enabled _ignore_desc_in_index _init_sql_file _io_slaves_disabled _ipc_fail_network _ipc_test_failover _ipc_test_mult_nets _kgl_latch_count _latch_spin_count _log_blocks_during_backup _log_buffers_corrupt _log_buffers_debug  _log_entry_prebuild_threshold  _mts_load_constants _mv_refresh_selections _new_initial_join_orders  _no_objects _offline_rollback_segments _ogms_home _optimizer_undo_changes _pmon_load_constants _reuse_index_loops _row_cache_cursors _save_escalates  _single_process  _small_table_threshold _spin_count _sqlexec_progression_cost _trace_files_public  _undo_optimizer_changes _unnest_subquery _use_ism  _wait_for_sync   A analyze table aud$ audit_actions avg_space_freelist_blocks   B buffer_busy_waits    buffer_pool_keep   buffer_pool_recycle C catblock.sql  cpu_count  create_stored_outlines

D db_allowed_logon_version db_block_buffers db_block_lru_latches db_block_size db_flashback_retention_target db_recovery_file_dest  db_recovery_file_dest_size  dba_blockers  dba_clu_columns  dba_cluster_hash_expression  dba_cluster_hash_functions  dba_clusters dba_coll_types dba_ddl_locks dba_directories dba_dml_locks dba_extents dba_external_locations dba_external_tables dba_ind_expressions dba_ind_partitions  dba_ind_subpartitions dba_indexes dba_internal_locks dba_join_ind_columns dba_kgllock dba_libraries dba_lock  dba_lock_internal   dba_method_params   dba_method_results dba_nested_tables   dba_object_tables dba_opancillary  dba_oparguments dba_opbindings   dba_operators dba_outline_hints   dba_outlines dba_profiles dba_refs  dba_rollback_segs dba_tab_columns  dba_tab_partitions  dba_tab_sub-partitions dba_table  dba_tables      dba_tablespaces dba_type_attrs dba_type_methods dba_users dba_waiters dbms_context dbms_rls dbms_shared_pool dbms_stats  dbms_utility dbmspool.sql  ddl_wait_for_locks dirty_buffers_inspected E enqueue_hash_chains enqueue_locks enqueue_resources  F fet$ free_buffer_inspected   I index_stats instance_type  J job_queue_interval  job_queue_processes   K k$kqdpg    L large_pool_size ldap_directory_access lock_name_space log_archive_config log_buffer log_checkpoint_interval log_simultaneous_copies log_small_entry_max_size

N num_freelist_blocks   O obj$  optimizer_mode Oracle Process ID osm_disk_repair_time   osm_diskgroups   osm_diskstring   osm_power_limit     outln_utl    P parallel_automatic_tuning     parallel_max_servers   pctincrease   plan_table  plsql_optimize_level    plsql_warnings  props$    prvtpool.plb  R redo blocks written  redo buffer allocation retries  redo entries linearized  redo log space wait  redo size redo small copies  redo writes  redo_allocation redo_copy resumable_timeout    S shared_pool_pct shared_pool_size    skip_unusable_indexes smtp_out_server sp_name   sql_summary  streams_pool_size  System Process ID      T timed_statistics    U uet$  undo_retention  user_dump_dest      V v$archived_log  v$bh v$buffer_pool v$buffer_pool_statistics v$controlfile v$controlfile_record  v$controlfile_record_section  v$database v$datafile  v$db_object_cache   v$dbwr_write_histogram  v$dbwr_write_log     v$latch    v$latch_children   v$latchname   v$librarycache v$lock_dpt  v$log_history  v$logfile  v$parameter  v$parameter2 v$process v$resource_limit  v$rollname v$rollstat   v$session v$session_event v$sesstat  v$sgastat  v$sqlarea v$sqltext  v$statname v$sysstat  v$system_parameter v$system_parameter2 v$tablespace v$transportable_platform v$waitstat      W word_wrapped Workspace Manager X x$bh x$kcbfwait  x$kqdpg      x$kvit

Reader Comments

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!

Errata: