Hi,


Try this!


SELECT r.name "RBSNAME", s.sid, s.serial#, s.username, t.status,
t.used_ublk, t.cr_get, t.phy_io, t.noundo,
substr(s.program, 1, 78) "COMMAND"
FROM sys.v_$session s
,sys.v_$transaction t
,sys.v_$rollname r
WHERE t.addr = s.taddr
and t.xidusn = r.usn
ORDER BY t.used_ublk;


Battila





"Alan Lima - Unidade de Suporte e Telecom "
<oracledba-ezmlmshield-x94916331.[Email address protected]
05/03/2007 08:16 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
UNDO






Hi,

I need help. How can I see which process is consuming the UNDO
TABLESPACE_NAME?

Regards,

Alan




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page