top of page
Search

UNDO management

-- UNDO tablespace space

select tablespace_name tablespace,

status,

sum(bytes)/1024/1024 MB,

count(*) counts

from dba_undo_extents

group by tablespace_name, status

order by 1,2;

-- UNDO Retention

ALTER SYSTEM SET UNDO_RETENTION = 1800

 
 
 

Recent Posts

See All
Get DDL for Oracle object

set feed off set long 1000000 set longchunksize 1000000 set pages 0 set lines 32767 set trimspool on set feed off set wrap on set...

 
 
 
Foreign key constraint violation

/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id...

 
 
 

Comments


bottom of page