UNDO-Tablespace-Usage :: "ACTIVE" vs. "USED"
MynzMay 6 2013 — edited May 6 2013Hello,
when I run this
SELECT SUM(BYTES)/1024/1024/1024 "GB" ,STATUS
FROM DBA_UNDO_EXTENTS
GROUP BY STATUS;
against my database, I get this
MB STATUS
---------- ---------
,008789063 UNEXPIRED
,094177246 EXPIRED
*19,7614746* ACTIVE
But when checking transactions with
SELECT s.sid , s.username , t.used_ublk*8/1024/1024
FROM v$transaction t
, v$session s
WHERE t.ses_addr = s.saddr;
I get this
SID USERNAME T.USED_UBLK*8/1024/1024
---------- ------------------------------ -----------------------
109 TRAM_STAT *6,0405426*
Where does this difference come from ???
Regards,
Mynz