database growth script [message #193149] |
Fri, 15 September 2006 01:32 |
*Jess*
Messages: 48 Registered: December 2005 Location: Penang, Malaysia
|
Member |
|
|
Hi all,
I got this script from Oracle Metalink and tested on our production server.
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')
The result shows:
Month Growth in Meg
-------------- -------------
2005 December 2700
2005 November 300
2005 October 3000
2005 September 3500
2006 April 2860
2006 August 10820
2006 January 550
2006 June 3760
2006 March 700
Not sure why the output is not shown for every month, does this relation with the creation_time in the script?
I'm quite fresh in this area and appreciate any guidelines. Thanks.
|
|
|
|
|
|
|