Database Administration (MOSC)

MOSC Banner

How to identify sessions and Sqls for UNDO allocated / used (UNEXPIRED) ?

edited Jan 14, 2009 3:25AM in Database Administration (MOSC) 6 commentsAnswered
Hi Oracle Support experts,

How to identify sessions and Sqls for UNDO allocated / used size (UNEXPIRED) ?

Thanks and regards
Ezhil

<<

Tablespace                 Total_MB    Alloc_MB   Avail_MB  Big_slot    (%) Severity
------------------------------ ----------       ----------        ----------      --------        ---- --------
UNDO1                        27,000        21,279        5,721         614           79 NORMAL


NAME                                    TYPE    VALUE
------------------------------------ ----------- ------------------------------
undo_retention                      integer  21500

SELECT STATUS, round(SUM(BYTES)/1048576) Size_MB, COUNT(*) FROM DBA_UNDO_EXTENTS GROUP BY STATUS;

STATUS     SIZE_MB  COUNT(*)
---------            ----------      ----------
ACTIVE               265             6
EXPIRED         2,580        272
UNEXPIRED  18,434     2153

>>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center