INDEX.ashmasters

ASH Masters http://ashmasters.com:

@setup.sql: calls other setup scripts
@set_dbid.sql: get current dbid into variables for other scripts
@set_date_format.sql: set the date format used for to_char(date)
@ash_bbw.sql: buffer busy wait analysis
@ash_enq.sql: enqueue wait analays
@ash_graph.sql: basic ASH load chart in ASCII art more for demo purposes
@ash_graph_waits.sql: basic ASH load chart in ASCII art with top 2 waits per bucket
@ash_graph_waits_histash.sql: ASH load chart from DBA_HIST_ACTIVE_SESS_HISTORY only
@ash_graph_histash_by_dbid.sql: ASH load chart from DBA_HIST_ACTIVE_SESS_HISTORY only, input DBID
@ash_graph_histash_by_dbid_program.sql: ASH load chart from DBA_HIST_ACTIVE_SESS_HISTORY only, input DBID and PROGRAM
@ash_graph_histash_by_dbid_sqlid.sql: ASH load chart from DBA_HIST_ACTIVE_SESS_HISTORY only, input DBID and a SQL_ID
@ash_io_sizes.sql: I/O sizes from ASH
@ash_sql_elapsed.sql: use ASH to find longest running SQL
@ash_sql_elapsed_hist.sql: use ASH to find longest running SQL, give histogram of execution times
@ash_sql_elapsed_hist_longestid.sql: use ASH to find longest running SQL, give histogram of execution times and execution id of longest running query
@ash_top_procedure.sql: top procedures and who they call
@ash_top_session.sql: top SESSION from ASH ordered by time broke into wait, I/O and CPU time
@ash_top_sql.sql: top SQL from ASH ordered by time broke into wait, I/O and CPU time
@ash_top_sql_w_top_obj.sql: top SQL from ASH ordered by time broke into wait, I/O and CPU time, include top object for I/O waits
@latency_eventmetric.sql: wait event latency from V$EVENTMETRIC, ie last 60 seconds
@latency_system_event.sql: wait event latency from DBA_HIST_SYSTEM_EVENT
@latency_waitclassmetric.sql: User I/O  latency from V$WAITCLASSMETRIC, ie  over last 60 seconds