RE: Database Growth for previous month
- From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
- To: <lyallbarbour@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 4 Jun 2010 15:24:33 -0400
You can use the v$datafile.creation_time to find out how many datafiles
were added in a month. I use the following statement:
select
to_char(CREATION_TIME,'RRRR') year,
to_char(CREATION_TIME,'MM') month,
sum(bytes) Bytes
from
v$datafile
group by
to_char(CREATION_TIME,'RRRR'),
to_char(CREATION_TIME,'MM')
order by
1, 2
And it gives an o/p like below:
Year Month Growth
2007 01 4,294,967,296
02 104,857,600
03 6,442,450,944
05 4,294,967,296
06 10,371,465,216
07 7,595,884,544
08 6,442,450,944
09 11,867,783,168
10 8,589,934,592
11 2,147,483,648
12 2,147,483,648
********** -------------------
sum 64,299,728,896
2008 01 2,097,152,000
03 2,147,483,648
04 6,442,450,944
06 12,884,901,888
07 19,327,352,832
09 15,032,385,536
10 6,442,450,944
11 11,811,160,064
12 15,032,385,536
********** -------------------
sum 91,217,723,392
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
lyallbarbour@xxxxxxxxxxxxxxx
Sent: Friday, June 04, 2010 3:05 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Database Growth for previous month
We have Grid at our shop. Using the reports from it, that use the views
mentioned in another reply, we have information since the Agents started
reporting.
Otherwise, previously, at other jobs, i've had to write scripts. Of
course, if you do not have anything collecting information for the past
two months, from Oracle or your own homegrown, then, you won't be able
to get that information.
Lyall
-----Original Message-----
From: Prabhu Krishnaswamy <prabhu_adam@xxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Fri, Jun 4, 2010 2:25 pm
Subject: Database Growth for previous month
Hi Lists,
Could you please help me is there any way to get the database growth for
the previous two months.
Thanks in advance.
Prabhu
________________________________
Build a bright career through MSN Education Sign up now. =
Other related posts:
