SQL

Tom Kyte
- Vertical SQL output
  print_table()
  local original output
Tim Gorman
- Automated Statspack Purging
  delete from STATS$SNAPSHOT, other tables are defined 'references STATS$SNAPSHOT on delete cascade'
  sppurpkg.sql
  local original
- Oracle Memory Usage on Solaris
  oramem.sh
  local original
- Enqueue Waits Report
  enqwaits.sql
  local original output
- Run the Enqueue Waits Report
  run_enqwaits.sql
  local original
- Enqueue Waits Report in anonymous PLSQL
  temp_enqwaits.sql
  local original
- Statspack Stat Trends
  sptrends.sql
  local original
- Statspack Wait Trends
  sp_evtrends.sql
  local original

Papers

Anjo Kolk

Waits (pdf)

Locks (doc)

Locks (html)

John Beresniewicz

AAS (pdf)

Tanel Poder

Tanel on ASSM (ppt)