GitHub - bigdatalyn/ashmasters: ASH and related queries

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/

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

Name		Name	Last commit message	Last commit date
Latest commit History 40 Commits
.gitattributes		.gitattributes
.gitignore		.gitignore
README.md		README.md
act.sql		act.sql
ash_bbw.sql		ash_bbw.sql
ash_enq.sql		ash_enq.sql
ash_graph.sql		ash_graph.sql
ash_graph_histash_by_dbid.sql		ash_graph_histash_by_dbid.sql
ash_graph_histash_by_dbid_program.sql		ash_graph_histash_by_dbid_program.sql
ash_graph_histash_by_dbid_sqlid.sql		ash_graph_histash_by_dbid_sqlid.sql
ash_graph_waits.sql		ash_graph_waits.sql
ash_graph_waits_histash.sql		ash_graph_waits_histash.sql
ash_io_sizes.sql		ash_io_sizes.sql
ash_io_top_obj.sql		ash_io_top_obj.sql
ash_io_top_obj_advanced.sql		ash_io_top_obj_advanced.sql
ash_manual.sql		ash_manual.sql
ash_plan_line.sql		ash_plan_line.sql
ash_sql_elapsed.sql		ash_sql_elapsed.sql
ash_sql_elapsed_hist.sql		ash_sql_elapsed_hist.sql
ash_sql_elapsed_hist_longestid.sql		ash_sql_elapsed_hist_longestid.sql
ash_top_procedure.sql		ash_top_procedure.sql
ash_top_session.sql		ash_top_session.sql
ash_top_sql.sql		ash_top_sql.sql
ash_top_sql_w_top_obj.sql		ash_top_sql_w_top_obj.sql
ash_wait_chains.sql		ash_wait_chains.sql
ash_wait_chains_hist.sql		ash_wait_chains_hist.sql
ash_xplan.sql		ash_xplan.sql
ash_xplan_example.txt		ash_xplan_example.txt
awr_change_dbid.sql		awr_change_dbid.sql
cpu_consumed_verses_cpuwait.sql		cpu_consumed_verses_cpuwait.sql
cpu_consumed_verses_cpuwait_RAC.sql		cpu_consumed_verses_cpuwait_RAC.sql
dbid.sql		dbid.sql
import_awr.sql		import_awr.sql
io.sql		io.sql
io_dpr.sql		io_dpr.sql
io_pqo.sql		io_pqo.sql
io_scat.sql		io_scat.sql
io_seq.sql		io_seq.sql
io_sql.sql		io_sql.sql
io_timestamps.sql		io_timestamps.sql
ioag.sql		ioag.sql
ioag_orig.sql		ioag_orig.sql
iodfpr.sql		iodfpr.sql
ionoobj.sql		ionoobj.sql
ionosql.sql		ionosql.sql
ioobj.sql		ioobj.sql
ioobjdec.sql		ioobjdec.sql
iop.sql		iop.sql
iosql.sql		iosql.sql
iosql_aas.sql		iosql_aas.sql
iotbs.sql		iotbs.sql
iotbs1.sql		iotbs1.sql
iotx.sql		iotx.sql
jb.sql		jb.sql
latency_eventmetric.sql		latency_eventmetric.sql
latency_system_event.sql		latency_system_event.sql
latency_waitclassmetric.sql		latency_waitclassmetric.sql
pstack.sh		pstack.sh
tcf.sql		tcf.sql

bigdatalyn/ashmasters

Folders and files

Latest commit

History

Repository files navigation

About

Resources

Stars

Watchers

Forks

Languages