Platforms: 1-914CU;

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.2
Information 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

显示相关信息 相关的