Database - RAC/Scalability (MOSC)

MOSC Banner

Block used by undo not unfreezed on database 11.2.0.4 RAC

edited Apr 22, 2020 2:38PM in Database - RAC/Scalability (MOSC) 4 commentsAnswered

Hello Friends,

I need your help :

When  I  am checking  my undo space (Tablespace UNDOTBS1)  , it is taking  already 100 % of usage  and there are many block not released  on the system.

SQL> SELECT DISTINCT STATUS, SUM(BYTES)/1024/1024, COUNT(*) FROM DBA_UNDO_EXTENTS where tablespace_name = 'UNDOTBS1' GROUP BY STATUS;

STATUS    SUM(BYTES)/1024/1024   COUNT(*)

--------- -------------------- ----------

UNEXPIRED            94988.875      11289

EXPIRED                1429.25        315

ACTIVE                     248         10

Help me to   release the space that the status was   expired without  switch to another TBS undo.

Regards,

Six

Tagged:

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