É comum verificar o percentual de uso da flash recovery area (FRA) quando a mesma se encontra configurada na base de dados. Para verificar o percentual de uso da mesma, pode-se usar a V$FLASH_RECOVERY_AREA_USAGE. Com isso, segue um exemplo neste post:
- Verificando se a flash recovery area se encontra configurada:
SQL> show parameters recovery_file NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string +DG_FRA db_recovery_file_dest_size big integer 800G
Note que está configurado a flash recovery area para utilizar o disk group DG_FRA e com o valor máximo de uso para 800G. Outro ponto interessante, que o valor máximo é diferente do valor total do disk group, que pode possuir mais espaço. Para checar o tamanho total do disk group, pode-se usar a V$ASM_DISKGROUP, como no exemplo abaixo:
SQL> select name,total_mb from v$asm_diskgroup where name='DG_FRA'; NAME TOTAL_MB ------------------------------ ---------- DG_FRA 1228800
Viu só? Não estamos utilizando o disk group inteiro de 1228800MB para a FRA.
Todavia, dos 800G configurados para a FRA, vamos obter facilmente através da V$FLASH_RECOVERY_AREA_USAGE o percentual de uso. Sendo assim, segue um exemplo:
SQL> set pages 2000 SQL> set lines 2000 SQL> select * from V$FLASH_RECOVERY_AREA_USAGE; FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES -------------------- ------------------ ------------------------- --------------- CONTROL FILE 0 0 1 REDO LOG 0 0 0 ARCHIVED LOG 9.51 3.11 138 BACKUP PIECE 0 0 0 IMAGE COPY 0 0 0 FLASHBACK LOG 0 0 0 FOREIGN ARCHIVED LOG 0 0 0 7 rows selected.
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.