Home » Other » General » check database size
icon6.gif  check database size [message #202799] Sun, 12 November 2006 21:13 Go to next message
dunno
Messages: 2
Registered: November 2006
Junior Member
How do i find out what is my database size in windows oracle platform?
Re: check database size [message #202827 is a reply to message #202799] Mon, 13 November 2006 00:24 Go to previous messageGo to next message
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.
Re: check database size [message #202850 is a reply to message #202799] Mon, 13 November 2006 01:12 Go to previous message
Frank
Messages: 7880
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.
Previous Topic: SAP - FICO Material
Next Topic: ODBC DRIVER for ORACLE 9.2
Goto Forum:
  


Current Time: Thu Dec 08 04:30:55 CST 2016

Total time taken to generate the page: 0.05634 seconds