|
lockmon.sql |
- |
An oldie but a goodie. I let this one get out
of date, but I've updated it for 10g/11g and it's much faster than it was. |
|
ges_locks.sql |
|
RAC script to show GES locks (cross instance
based locks) |
|
dispactive.sql |
- |
Query to display details of active
sessions. Very useful for finding the SID, Serial# and SPID of an
Oracle session. |
|
dispusr.sql |
- |
Query to display details of all sessions. Very
useful for quickly finding the SID, Serial# and SPID of an Oracle session. |
|
waits.sql |
- |
Show session waits (current and cumulative). |
|
libcache_lock.sql |
- |
Nice script to display library cache lock/pin blockers and waiters. |
|
objcache_dep.sql |
- |
A query that will map library cache objects back to user sessions.
Very useful if you've ever tried to compile a package and been hung on a
"library cache lock". |
|
libcache_pin.sql |
- |
A query to help
determine which objects should be pinned based on the objects currently loaded in the
library cache. |
|
tsmap.sql |
- |
Tablespace space map,
dynamic SQL to handle autoextending tablespaces. This has been fixed to handle
datafiles that are manually resized larger than the MAXSIZE setting. Tablespace
totals have been recently added. |
|
tsmap9i.sql |
- |
Tablespace map using just SQL. For Oracle 9i
and higher. |
|
ts_storage8i.sql |
- |
Display tablespace
storage info for an 8i database. Includes support for locally managed
tablespaces. |
|
asm_info.sql |
- |
Query to display ASM information. |
|
sess_info.sql |
- |
Maps Oracle user session
information. |
|
cpu_test |
- |
Script to generate a theoretical maximum number
of logical I/Os on a single CPU. |
|
session_time.sql |
- |
Script to format v$sess_time_info. |
|
recovery_file_dest.sql |
- |
Display v$recovery_file_dest space usage. |
|
show_space.sql |
- |
Based on Tom Kyte's original version, this one
also displays SecureFile information. |
|
unloader.sql |
- |
A modified version of Tom Kyte's PL/SQL
unloader script. It is also available on Tom's site
here. |
