Script to get size of generated archived logfiles in certain timeframe

I’m testing a import datapump load procedure and I need to know the approximate size of generated archives that this load will generate to determine the size needed for our database recoveryarea. Script below queries the v$archived_log view for this information. Please note that I have tested this with ONE and only ONE active / […]

Read More…

SQL script to check available space in your recoveryarea (db_recovery_file_dest_size)

We’re hitting a lot of ORA-19815, ORA-19809, ORA-00257, ORA-16038 these days on some of our development databases – see here. Scroll down for an updated version. The space_reclaimable should be substracted from space_used. Script below displays percentage used in in your recoveryarea(s) as defined in init parameter ‘db_recovery_file_dest_size’. col name for a32 col size_m for […]

Read More…