Fast Recovery Area must be monitored regularly. Sometimes FRA runs our of space and a DBA must be able to...

Once you run the query, it will ask your table name. Enter the table name in the format of owner.tablename....

There is always a requirement to delete files which are older than x days on Linux / Unix systems. Before...

The below query gives results of archive generation in oracle database. Use below query to find the archive space requirements...

A DBA must maintain adequate space in database tablespaces in order to have smooth functioning. All the tablespaces must be...

When you want to shrink a datafile, you must always check the single datafile utilization. In case if you shrink...