Check FRA location utilization Fast Recovery Area must be monitored regularly. Sometimes FRA runs our of space and a DBA must be able to...
Check table size in oracle Once you run the query, it will ask your table name. Enter the table name in the format of owner.tablename....
Delete files older than x days There is always a requirement to delete files which are older than x days on Linux / Unix systems. Before...
Estimate archive destination space The below query gives results of archive generation in oracle database. Use below query to find the archive space requirements...
Tablespace utilization in Oracle A DBA must maintain adequate space in database tablespaces in order to have smooth functioning. All the tablespaces must be...
Datafile utilization check When you want to shrink a datafile, you must always check the single datafile utilization. In case if you shrink...