List the Flashback Logging Size
--
-- List the Flashback Logging Size.
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
SET VERIFY OFF
 
SELECT 
     estimated_flashback_size/1024/1024/1024 "EST_FLASHBACK_SIZE(GB)" 
FROM 
     v$flashback_database_log
/

Related Scripts

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License