FlashBack Monitoring Script
Hola,
Aqui les publico un script para monitorear el area de Flashback.
PROMPT
PROMPT ******************************************** FLASH RECOVERY AREA *****************************************************
SELECT NAME fra, SPACE_LIMIT/1024/1024/1024 “GB LIMITE”, ROUND(SPACE_USED/1024/1024/1024) “GB USADOS”, ROUND(SPACE_RECLAIMABLE/1024/1024) “MB RECLAMABLES”, NUMBER_OF_FILES archivos
FROM V$RECOVERY_FILE_DEST;
PROMPT
PROMPT ******************************************** FLASH RECOVERY AREA USAGE
SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;
PROMPT
PROMPT ******************************************** FLASHBACK
SELECT * FROM GV$FLASHBACK_DATABASE_LOGFILE;
SELECT * FROM GV$FLASHBACK_DATABASE_LOG;
SELECT * FROM GV$FLASHBACK_DATABASE_STAT;
Saludos a todos,
Francisco Munoz Alvarez