meta données pour cette page
  •  

Ceci est une ancienne révision du document !

Flash Recovery Area (FRA)

  • Location
show parameter db_recovery
  • FRA size
SET linesize 500
col NAME FOR a50
SELECT name, ROUND(SPACE_LIMIT/1024/1024/1024,2) "Allocated Space(GB)", 
ROUND(SPACE_USED/1024/1024/1024,2) "Used Space(GB)",
ROUND(SPACE_RECLAIMABLE/1024/1024/1024,2) "SPACE_RECLAIMABLE (GB)" ,
(SELECT ROUND(ESTIMATED_FLASHBACK_SIZE/1024/1024/1024,2) 
FROM V$FLASHBACK_DATABASE_LOG) "Estimated Space (GB)"
FROM V$RECOVERY_FILE_DEST;