Database Administration (MOSC)

MOSC Banner

EBS R12.1.1 Undo Tablespace

edited Dec 22, 2011 2:23AM in Database Administration (MOSC) 7 commentsAnswered
Dears

I like to ask you about undo tablespase the size approach to be full around 13,920 MB

Is this healthy for database ?

SQL>  show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management              string      AUTO
undo_retention                    integer     900
undo_tablespace                 string      APPS_UNDOTS1


SQL> SELECT DISTINCT STATUS, SUM(BYTES), COUNT(*)
  2  FROM DBA_UNDO_EXTENTS GROUP BY STATUS;

STATUS          SUM(BYTES)   COUNT(*)
---------              ----------              ----------
UNEXPIRED     1.3749E+10       1937
ACTIVE            109051904         13
EXPIRED          4587520            40

SQL> select autoextensible from dba_data_files where tablespace_name='UNDOTBS1';

no rows selected

SQL> select autoextensible from dba_data_files where tablespace_name='APPS_UNDOTS1';

AUT
---
NO

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