Skip to content
ASH and related queries
PLSQL Shell
Find file
Pull request Compare This branch is 6 commits ahead, 4 commits behind khailey:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.
topaas
.gitattributes
.gitignore added ASH SQL Elapsed time queries
README.md
aas_15min.sql
aas_by_hour.sql
act.sql
ash_bbw.sql
ash_enq.sql
ash_graph.sql
ash_graph_histash_by_dbid.sql
ash_graph_histash_by_dbid_program.sql
ash_graph_histash_by_dbid_sqlid.sql
ash_graph_waits.sql
ash_graph_waits_histash.sql
ash_io_sizes.sql
ash_io_top_obj.sql added ash_io_top_obj_advanced
ash_io_top_obj_advanced.sql
ash_manual.sql
ash_plan_line.sql
ash_sql_elapsed.sql
ash_sql_elapsed_hist.sql
ash_sql_elapsed_hist_longestid.sql
ash_top_procedure.sql adding top_procedure,. top_session, bbw plus file renaming
ash_top_session.sql
ash_top_sql.sql
ash_top_sql_w_top_obj.sql
ash_wait_chains.sql
ash_wait_chains_hist.sql
ash_xplan.sql
ash_xplan_example.txt
awr_change_dbid.sql
cpu_consumed_verses_cpuwait.sql updated blog URL
dbid.sql
event_histograms_delta_from_AWR.sql
import_awr.sql
io.sql
io_dpr.sql
io_pqo.sql
io_scat.sql
io_seq.sql
io_sql.sql
io_timestamps.sql
ioag.sql
ioag_orig.sql added io scripts and tcf.sql
iodfpr.sql added io scripts and tcf.sql
ionoobj.sql
ionosql.sql
ioobj.sql
ioobjdec.sql
iop.sql
iosql.sql
iosql_aas.sql
iotbs.sql
iotbs1.sql
iotx.sql
jb.sql added io scripts and tcf.sql
latency_eventmetric.sql
latency_system_event.sql added io scripts and tcf.sql
latency_waitclassmetric.sql
load_awr.sql adding new scripts
pstack.sh
tcf.sql added io scripts and tcf.sql
top10_sql_with_events_from_AWR.sql adding top10_sql_with_events_from_AWR
topsql.sql

README.md

see http://ashmasters.com for information on
Oracle Active Session History (ASH)

also see Tanel Poder's ash scripts at
http://blog.tanelpoder.com/files/scripts/ash/

<<<<<<< HEAD

  • load_awr - physical and logical reads per sec from AWR with snapshot time
  • top10_sql_with_events_from_AWR.sql - top 10 SQL queries with events per AWR snapshot
  • topsql - top 10 sql per last N minutes from ASH
  • aas_by_hour - display AAS (based on ASH) for number of days at specific time
  • aas_15min - display AAS (based on AWR) for all AWR snapshots calculated per 15 min spilt with split between CPU and WAIT
  • event_histograms_delta_from_AWR.sql - event histograms deltas between AWR snapshots

* topaas - display OEM like graph based on sampling and v$session view - NO DIAGNOSTIC PACK required

queries contained in repository

  • 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 >>>>>>> upstream/master
Something went wrong with that request. Please try again.