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
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps
Monday, June 30, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment