Database Scripts Library

Metalink Note 131704.1 is an index of database scripts:

Database Scripts

Last updated on September 25, 2008

AdvancedQueueing	ContentMgmt.Spatial	ContentMgmt.Text	ContentMgmt.UltraSearch
ContentMgmt.interMedia	DBA.Admin	DBA.Architecture	DBA.DBCreationAndConfiguration
DBA.Monitoring	DBA.Parameters	DBA.SQL	DBA.Storage
DBA.UpgradeAndMigration	DBWarehouse.MaterialView	DBWarehouse.ParallelExecution	DBWarehouse.Partitioning
Distributed.General	Distributed.Replication	Distributed.Streams	Globalization
Globalization.DST	HighAvailability.BR	HighAvailability.Corruption	HighAvailability.DataGuard
HighAvailability.RMAN	Install.Installer	Install.UnixGeneric	JVM
Manageability.MemoryMgmt	Manageability.Utilities.ExportImport	Manageability.Utilities.SqlLoader	Performance.Database
Performance.Locking	Performance.SqlTuning	Scalability.OPS	Scalability.RAC
Security.DBSecurity

Database scripts for estimating growth

One of the simplest scripts is based on addition of datafiles and is described in metalink note 135294.1

=======
Script:
=======

select to_char(creation_time, 'RRRR Month') "Month",
sum(bytes)/1024/1024
"Growth in Meg"
from sys.v_$datafile
where creation_time > SYSDATE-365
group by to_char(creation_time, 'RRRR
Month');


==============================
Sample Output from the script:
==============================

Month
Growth in
-------------------------------- ----------
2000 December 1068.625
2001 February 70