Oracle 11.2 has introduced s staggering 33 new AWR dba_hist
tables.
dba_hist_ash_snapshot
dba_hist_baseline_details
dba_hist_baseline_metadata
dba_hist_baseline_template
dba_hist_cluster_intercon
dba_hist_colored_sql
dba_hist_dispatcher
dba_hist_dyn_remaster_stats
dba_hist_event_histogram
dba_hist_ic_client_stats
dba_hist_ic_device_stats
dba_hist_interconnect_pings
dba_hist_iostat_detail
dba_hist_iostat_filetype
dba_hist_iostat_filetype_name
dba_hist_iostat_function
dba_hist_iostat_function_name
dba_hist_mem_dynamic_comp
dba_hist_memory_resize_ops
dba_hist_memory_target_advice
dba_hist_mutex_sleep
dba_hist_mvparameter
dba_hist_persistent_qmn_cache
dba_hist_persistent_queues
dba_hist_persistent_subs
dba_hist_plan_operation_name
dba_hist_plan_option_name
dba_hist_rsrc_consumer_group
dba_hist_rsrc_plan
dba_hist_shared_server_summary
dba_hist_sqlcommand_name
dba_hist_tablespace
dba_hist_toplevelcall_name
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
