Skip to Content

PSAPUNDO tablespce is not releasing instantly from 100%

Hi All,

I have an issue

PSAPUNDO tablespce is not releasing instantly from 100%.Its taking near about 30 min to release while my current UNDO value is :

SQL> show parameter undo;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_undo_autotune boolean FALSE
undo_management string AUTO
undo_retention integer 43200
undo_tablespace string PSAPUNDO01
SQL>

regards

Abhishek

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 08, 2017 at 05:48 AM

    Hi Abhishek,

    Was there any issue? normally we don't look into PSAPUNDO full, because any way the space in PSAPUNDO will be released and used if necessary.

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 14, 2017 at 12:12 PM

    Actually PSAPUNDO table space is not releasing fro 30 min every night we have checked the tables which are utilize that time.Found BALDAT table is taking maximum utilization.

    But right now we have changed the parameter set the _undo_autotune=true.

    Still now no issue we are facing for 2 days after that.

    Add comment
    10|10000 characters needed characters exceeded