1 Reply Latest reply: May 2, 2014 11:18 AM by Top.Gun RSS

    Undo Utilization is High and not getting the session details which are using undo tablespace

    1876064

      Hi All,

       

      In One of our Production database Undo utilization is very high, and i am not getting the session details which are using undo .

       

      Below are the database details

      Database version : 11.2.0.3

      Os version : SunOS oraprd1 5.10 Generic_147440-19 sun4v sparc sun4v

      Undo tablespace utilization :

       

      TABLESPACE_NAME                TOT_SIZE_MB TOT_FREE_MB PCTF MAX_FREE_MB  CHKF     % used

      UNDO_TBS                              6100         924   15         204    19  84.852459

       

      Please suggest me on this issue please .