KO | EN

GitLite

Minimalist Open Source Repository Search Engine

gitlite — search

#dsh #dsh-plugin #ai-agents #developer-tools #typescript #codex #claude-code #mcp #rust #deepseek-harness #ai-agent #cli

ashmasters

★ 71 Open GitHub ↗

ASH and related queries

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

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

ashmasters

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README