OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Database size

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database size [message #61743]

Mon, 24 May 2004 01:02

Sean Day
Messages: 7
Registered: October 2003

Junior Member

Can somebody please tell me how to find the exact size of a single database. The server is Oracle Enterprise Server 9.0.1 running on a Solaris 8 server.

Cheers

Report message to a moderator

Re: Database size [message #61744 is a reply to message #61743]

Mon, 24 May 2004 02:01

prashant
Messages: 122
Registered: September 2000

Senior Member

issue this statement on sql prompt.

sql> select sum(bytes)/1024/1024/1024 "size of DataBase in GB" from dba_data_files;

this will tell you the size of yours database.

Thanks,
Prashant.

Report message to a moderator

Re: Database size [message #61751 is a reply to message #61743]

Mon, 24 May 2004 11:03

Thomas Anderson
Messages: 9
Registered: January 2003

Junior Member

There are some scripts available to do that:

Click here

[url=http://www.dbaclick.com/modules.php?op=modload&name=News&file=article&sid=149] Click here <a/>

HTH,

clio_usa - OCP 8/8i/9i DBA

Oracle DBA Resoources | Oracle DBA Forums | USENET Oracle newsgroups

Report message to a moderator

Previous Topic:	Oracle Service fails to start
Next Topic:	Errors while importing a dump file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 12:39:14 CST 2025