| 修改时间 28-JUL-2010 类型 HOWTO 状态 MODERATED | |||
| This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |
Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.5 to 10.2.0.5 - Release: 9.2 to 10.2Information in this document applies to any platform.
***Checked for relevance on 25-Jul-2010***
Goal
How do you determine which users are using and how much UNDO is being used?Solution
select a.sid, a.serial#, a.username, b.used_urec, b.used_ublk
from v$session a, v$transaction b
where a.saddr=b.ses_addr;
EXAMPLE:
SQL> select a.sid, a.serial#, a.username, b.used_urec, b.used_ublk
2 from v$session a, v$transaction b
3 where a.saddr=b.ses_addr;
SID SERIAL# USERNAME USED_UREC USED_UBLK
---------- ---------- ------------------------------ ---------- ----------
21 7856 KBCOOK 1 1
USED_UBLK = Number of undo blocks used
USED_UREC = Number of undo records used
产品
|
相关的
返回页首