OraFAQ Forum: General » check database size

Home » Other » General » check database size

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

check database size [message #202799]

Sun, 12 November 2006 21:13

dunno
Messages: 2
Registered: November 2006

Junior Member

How do i find out what is my database size in windows oracle platform?

Report message to a moderator

Re: check database size [message #202827 is a reply to message #202799]

Mon, 13 November 2006 00:24

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi
SQL> ed
Wrote file afiedt.buf

1* select round((sum(bytes)/1024/1024),2) "Database Size : Mb" from dba_data_files
SQL> /

Database Size : Mb
------------------
999.75

also go through below link.
http://www.databasejournal.com/img/DBSIZE_REPORT.SQL

hope this helps
Mohammad Taj.

Report message to a moderator

Re: check database size [message #202850 is a reply to message #202799]

Mon, 13 November 2006 01:12

Frank
Messages: 7901
Registered: March 2000

Senior Member

look at the size of the oradata directory.
It all depends on what you call 'the size' of your database.

Report message to a moderator

Previous Topic:	SAP - FICO Material
Next Topic:	ODBC DRIVER for ORACLE 9.2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 17:10:41 CST 2024