|
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) |
 |
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
|
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: |
|
