Home » SQL & PL/SQL » SQL & PL/SQL » Database size
Database size [message #403308] Thu, 14 May 2009 14:29 Go to next message
Messages: 22
Registered: February 2005
Location: Delhi
Junior Member

If someone can help me in this please.

I need to know the growth of the database size schema wise. Following query is not helping much.

SELECT TO_CHAR(creation_time, 'RRRR Month') "Month",
SUM(bytes)/1024/1024 "Growth in MB"
FROM sdas.v_$datafile
WHERE creation_time > SYSDATE-365
GROUP BY TO_CHAR(creation_time, 'RRRR Month');

Pleaase let me know if there is a etter way to find it schema wise growth of database.


Re: Database size [message #403312 is a reply to message #403308] Thu, 14 May 2009 14:51 Go to previous messageGo to next message
Messages: 25544
Registered: January 2009
Location: SoCal
Senior Member
>Following query is not helping much.

Your post is not offering much help.

You need to help us by following the Posting Guidelines as stated below.
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: Database size [message #403314 is a reply to message #403308] Thu, 14 May 2009 15:03 Go to previous message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Previous Topic: How to get a sequence nextval through a database link.
Next Topic: Year to Date Amounts
Goto Forum:

Current Time: Thu Jul 27 12:26:36 CDT 2017

Total time taken to generate the page: 0.12377 seconds