There are many ways to calculate database growth and I’ve certainly had a few, but this is probably the most accurate so far..
Category: Enterprise Manager
Backup Report from Enterprise Manager
How do we report on databases that haven’t been backed up? We create a report from Enterprise manager and see what has failed and what backups are potentially missing Run this in Enterprise Manager
Database Capacity Planning
Capacity and Growth Forecast How to estimate the growth and forecast of a database on a host. Step-by-step guide The procedure is at the bottom of this article. Login to enterprise manager from sqlplus (from omsdbaup03) oracle@omsdbaup03:/users/oracle 2. Follow the following to calculate growth for each database on a host The following…
How can I view the number of targets blacked out in the last 30 days?
The MGMT$BLACKOUT_HISTORY file contains an overview of all finished blackouts for each target. To view the number of targets blacked out in the last 30 days, enter the following query:
How can I view a list of future scheduled blackouts?
The MGMT$BLACKOUTS file contains definitions of all blackouts known in the system. To view a list of future scheduled blackouts, enter the following query:
How do I return all targets under a blackout?
To return all targets under blackout, enter the following query: