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

Hi,
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.

Regards,

Sudipta
Re: Database size [message #403312 is a reply to message #403308] Thu, 14 May 2009 14:51 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
http://www.orafaq.com/forum/t/88153/0/
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: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.lmgtfy.com/?q=oracle+database+size

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


Current Time: Mon Dec 05 04:51:48 CST 2016

Total time taken to generate the page: 0.12596 seconds