|
Jun 17,
2008
|
show user locks
|
|
Jun 17,
2008
|
show uga and pga memory usage
|
|
Jun 17,
2008
|
show all running sql text
|
|
Jun 17,
2008
|
users waiting for locks
|
|
Jun 17,
2008
|
display sessions holding locks
|
|
Jun 17,
2008
|
list inactive db users
|
|
Jun 17,
2008
|
list running db jobs
|
|
Jun 17,
2008
|
list all queued jobs
|
|
Jun 17,
2008
|
report sql text of locks in database
|
|
Jun 17,
2008
|
show all users and locks
|
|
Jun 17,
2008
|
more sql users and locks
|
|
Jun 17,
2008
|
list submitted jobs dba_jobs
|
|
Jun 17,
2008
|
list running jobs dba_jobs
|
|
Jun 17,
2008
|
sql to list users to kill
|
|
Jun 23,
2008
|
check for analyzed tables with chaining.sql
|
|
Jun 23,
2008
|
check_hidden_params.sql
|
|
Jun 23,
2008
|
crate a stats table.sql
|
|
Jun 23,
2008
|
create a test dba schema.sql
|
|
Jun 23,
2008
|
explain plan template again.sql
|
|
Jun 23,
2008
|
explain plan template.sql
|
|
Jun 23,
2008
|
get os info and hostname.sql
|
|
Jun 23,
2008
|
get sql text for a given hash value.sql
|
|
Jun 23,
2008
|
getsql text for a given hash value again.sql
|
|
Jun 23,
2008
|
list all awr metrics being collected.sql
|
|
Jun 23,
2008
|
list all initialisation parameters.sql
|
|
Jun 23,
2008
|
list all sql in sga assigned to a sid.sql
|
|
Jun 23,
2008
|
list all waits by time waited.sql
|
|
Jun 23,
2008
|
list db sessions.sql
|
|
Jun 23,
2008
|
list gv$resource limits.sql
|
|
Jun 23,
2008
|
list rollback segment details.sql
|
|
Jun 23,
2008
|
list segment types per tablespace and user.sql
|
|
Jun 23,
2008
|
list segmet usage by type and name.sql
|
|
Jun 23,
2008
|
list tables and when they were last analyzed.sql
|
|
Jun 23,
2008
|
list tablespaces and free space.sql
|
|
Jun 23,
2008
|
list users on this instance.sql
|
|
Jun 23,
2008
|
list waiting and blocking users.sql
|
|
Jun 23,
2008
|
look for sql in the sga containing the provided text.sql
|
|
Jun 23,
2008
|
loop and check pool usage.sql
|
|
Jun 23,
2008
|
pga_mem total max and freed.sql
|
|
Jun 23,
2008
|
pgastat values.sql
|
|
Jun 23,
2008
|
query the plan_table.sql
|
|
Jun 23,
2008
|
sessions by pga usage.sql
|
|
Jun 23,
2008
|
set session trace off.sql
|
|
Jun 23,
2008
|
set session trace on.sql
|
|
Jun 23,
2008
|
show active sql.sql
|
|
Jun 23,
2008
|
show all tables being accesed and the userid.sql
|
|
Jun 23,
2008
|
show db sessions and sql text.sql
|
|
Jun 23,
2008
|
show logon_time username machine and locks for sessions.sql
|
|
Jun 23,
2008
|
show segment space used by an object.sql
|
|
Jun 23,
2008
|
DELETE show sessions logged on.sql
|
|
Jun 23,
2008
|
show sessions logged on.sql
|
|
Jun 23,
2008
|
show uga and pga memory usage by all sessions.sql
|
|
Jun 23,
2008
|
show what tables are locked by what process.sql
|
|
Jun 23,
2008
|
size of the db in different ways.sql
|
|
Jun 23,
2008
|
table stats using table TRACE_INFO
|
|
Nov 11,
2008
|
global cache gc latency
|
|
Nov 11,
2008
|
sessions waiting
|
|
Nov 11,
2008
|
instance load across rac
|
|
Nov 11,
2008
|
schema stats
|
|
Nov 11,
2008
|
open cursors
|
|
Nov 11,
2008
|
db version registry installed
|
|
Nov 11,
2008
|
scn time
|
|
Nov 11,
2008
|
system waits and events
|
|
Nov 11,
2008
|
write to alert log and trace files
|
|
Sep 04,
2009
|
blocking session
|
|
Sep 04,
2009
|
session row lock contention
|
|
Jul 02,
2014
|
IO Performance investigation example
|