To Show ACTIVE/EXPIRED/UNEXPIRED Extents of Undo Tablespace

To Show ACTIVE/EXPIRED/UNEXPIRED Extents of Undo Tablespace SELECT tablespace_name,status,Count(extent_id) “Extent Count”,SUM(blocks) “Total Blocks”,SUM(blocks) * 8 / ( 1024 * 1024 ) total_spaceFROM dba_undo_extentsGROUP BY tablespace_name,status; … Read more