您的位置:寻梦网首页编程乐园Java天地JSP 专辑JSP001 HTML 离线版
Java 天地
JSP001 HTML 离线版
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行。




资料来源: JSP001.com