SQL Script Flashback Recovery Area Information

Updated: 28-Dec-2005
Version: 0.0

Description

list your Flashback Recovery Area details

Parameters

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

CLEAR
SET HEAD ON
SET VERIFY OFF
SET FEED ON
SET LINES 100
SET PAGES 200

show parameter flash

col flashback_on form a20 heading "Flashback On"

select   flashback_on 
from v$database
/

PROMPT
PROMPT Tablespaces excluded from flashback
PROMPT

select name,flashback_on from v$tablespace
/

PROMPT 
PROMPT No rows selected means that flashback is not configured
PROMPT

select OLDEST_FLASHBACK_TIME          
,RETENTION_TARGET               
,FLASHBACK_SIZE                 
,ESTIMATED_FLASHBACK_SIZE 
from v$flashback_database_log
/

PROMPT
PROMPT Flashback stats
PROMPT

select * from v$flashback_database_stat
/

Related Links

Oracle 10g: (SQL Script) Flashback Recovery Area Information

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links