--

-- List Earliest Flashback Database Time and SCN.

--

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET PAGESIZE 60

SET LINESIZE 300

SET VERIFY OFF

COLUMN oldest_flash_scn FOR 999,999,999

ALTER SESSION 

   SET nls_date_format='DD MON YYYY hh24:mi:ss'

/

SELECT 

   oldest_flashback_scn,

   oldest_flashback_time

FROM  

   v$flashback_database_log

/