Home > Oracle COREDB > ALL USEFULL SCRIPTS RELATED TO UNDO

ALL USEFULL SCRIPTS RELATED TO UNDO

July 27, 2013

I have been adding separate post for each script so far. Today i changed my mind and thought of grouping based on the topic to reduce the number of posts. Let me do for sometime and will review the same. In this post i am going to cover all scripts related to UNDO.

1) How to check undo related parameter values from current instance.

set lines 120
set pages 120
column name format a30
column value format a30
select name,value from v$parameter where name like ‘%undo%’;

Output looks similar to below.

NAME                             VALUE
—————————— ——————————
undo_management      AUTO
undo_tablespace          UNDOTBS1
undo_retention             900

2)

Advertisements
Categories: Oracle COREDB
%d bloggers like this: