undo-tbs


SQL> show parameter undo_

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> create rollback segment r1;

Rollback segment created.

SQL> show parameter undo_sup
SQL> show parameter undo_

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

There is no undo_suppress_error parameter in 10g.

SQL> alter system set undo_suppress_errors=true;
alter system set undo_suppress_errors=true
*
ERROR at line 1:
ORA-25138: UNDO_SUPPRESS_ERRORS initialization parameter has been made obsolete

let us see the undo_retention policy initialization.

SQL>

SQL> alter system set undo_retention 1000;
alter system set undo_retention 1000
*
ERROR at line 1:
ORA-00927: missing equal sign

SQL> alter system set undo_retention=1000;

System altered.


viewing v$undostat.

SQL>

SQL> select end_time,begin_time,undoblks from v$undostat;

END_TIME BEGIN_TIM UNDOBLKS
--------- --------- ----------
18-JUN-09 18-JUN-09 3
18-JUN-09 18-JUN-09 0
18-JUN-09 18-JUN-09 2
18-JUN-09 18-JUN-09 0
18-JUN-09 18-JUN-09 12

SQL>

C:\Documents and Settings\exam>set nls_date_format=dd-mm-yy:hh24:mi:ss

SQL> select end_time,begin_time,undoblks from v$undostat;

END_TIME BEGIN_TIME UNDOBLKS
----------------- ----------------- ----------
18-06-09:11:46:59 18-06-09:11:40:53 3
18-06-09:11:40:53 18-06-09:11:30:53 0
18-06-09:11:30:53 18-06-09:11:20:53 2
18-06-09:11:20:53 18-06-09:11:10:53 0
18-06-09:11:10:53 18-06-09:11:00:53 12

SQL>
SQL> select to_char(begin_time, 'DD-MON-RR HH24:MI') begin_time,
2 to_char(end_time, 'DD-MON-RR HH24:MI') end_time, tuned_undoretention
3 from v$undostat order by end_time;

BEGIN_TIME END_TIME TUNED_UNDORETENTION
--------------- --------------- -------------------
18-JUN-09 11:00 18-JUN-09 11:10 900
18-JUN-09 11:10 18-JUN-09 11:20 900
18-JUN-09 11:20 18-JUN-09 11:30 1000
18-JUN-09 11:30 18-JUN-09 11:40 1000
18-JUN-09 11:40 18-JUN-09 11:50 1000

SQL>