FAQ汇萃
>> Oracle 专栏
>> 显示回滚段的统计表
由 macro 发布于: 2001-03-03 09:36
column "Rollback Segment" format a16
column "Size (Kb)" format 9,999,999
column "Gets" format 999,999,990
column "Waits" format 9,999,990
column "% Waits" format 90.00
column "# Shrinks" format 999,990
column "# Extends" format 999,990
Prompt
Prompt Rollback Segment Statistics...
Select rn.Name "Rollback Segment", rs.RSSize/1024 "Size (KB)", rs.Gets "Gets",
rs.waits "Waits", (rs.Waits/rs.Gets)*100 "% Waits",
rs.Shrinks "# Shrinks", rs.Extends "# Extends"
from sys.v_$RollName rn, sys.v_$RollStat rs
where rn.usn = rs.usn
/
reslut screen:
Active transactions
SYSTEM 648 4,550 0 0.00 0 0
R01 3,032 4,972 0 0.00 0 0
R02 5,656 4,927 0 0.00 0 0
R03 3,192 4,971 0 0.00 0 0
R04 2,808 4,881 0 0.00 0 0
已选择5行。
|