ORA-01555 or Alter _highthreshold_undoretention integer

hello,

Setting either of this parameter will limit high value of undo retention like as ;

Description: _highthreshold_undoretention integer : high threshold undo_retention in seconds

connect as sysdba
alter system set "_HIGHTHRESHOLD_UNDORETENTION=21600" SCOPE=spfile;

you need to close and open database !!

SQL> show parameter undo;

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
_highthreshold_undoretention integer
17200
undo_management string
AUTO
undo_retention integer
7200
undo_tablespace string
UNDOTBS1
SQL> alter system set "_HIGHTHRESHOLD_UNDORETENTION"=21600 SCOPE=spfile;

System altered.

SQL> SHUTDOWN
SQL>
SQL>
SQL>
SQL> shutdown immediate;
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 8551575552 bytes
Fixed Size 2238616 bytes
Variable Size 4496295784 bytes
Database Buffers 4043309056 bytes
Redo Buffers 9732096 bytes
Database mounted.
Database opened.
SQL> show parameter undo;

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
_highthreshold_undoretention integer
21600
undo_management string
AUTO
undo_retention integer
7200
undo_tablespace string
UNDOTBS1
SQL> exit

Hits: 9

Leave a Reply

Your email address will not be published. Required fields are marked *