| |
 |
|
ss
Oracle Tips by Burleson |
Chapter 6 Oracle Tablespace and File
Internals Scripts
COLUMN curext
FORMAT 999999 HEADING "Current|Extent"
COLUMN
curblk FORMAT 999999 HEADING "Current|Block"
COLUMN transaction FORMAT A15 Heading 'Transaction'
COLUMN program FORMAT a10 HEADING 'Program'
SET PAGES 56 LINES 80 VERIFY OFF FEEDBACK OFF
ttitle "Rollback Segments in Use"
SPOOL tx_rbs
SELECT
r.name,
l.Sid,
p.spid,
NVL(p.username, 'no transaction') "Transaction",
p.program "Program",
s.curext,s.curblk
FROM
v$lock l,
v$process p,
v$rollname r,
v$rollstat s
SEE CODE DEPOT FOR FULL SCRIPT
Mike has
priced his collection of scripts at $49.95, less than a dime per
script. You can download them immediately at this link:
|
