Home » RDBMS Server » Server Administration » How do I calculate the size of my database?
How do I calculate the size of my database? [message #631010] Wed, 07 January 2015 21:30 Go to next message
frankC
Messages: 2
Registered: December 2014
Junior Member
HELLO AM A NEWBIE IN THIS FIELD AND DETERMINED TO MAKE IT. HOW DO I CALCULATE THE SIZE OF MY DB.

THANKS


[EDITED by LF: modified topic title; was "DABABASE"]

[Updated on: Thu, 08 January 2015 00:12] by Moderator

Report message to a moderator

Re: DABABASE [message #631012 is a reply to message #631010] Wed, 07 January 2015 22:01 Go to previous messageGo to next message
BlackSwan
Messages: 25856
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

It depends upon what is to be included & what is not counted against database size.

How will you know when the correct answer has been posted?

SELECT SUM(BYTES) FROM DBA_DATA_FILES; --- provides a number & other queries will produce a different number depending upon which files are included or not.
Re: DABABASE [message #631028 is a reply to message #631012] Thu, 08 January 2015 00:47 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

To add to BlackSwan's post, have a look a dba_data_files, dba_temp_files, v$log, v$standby_log, v$controlfile views in Database Reference.

Re: DABABASE [message #631088 is a reply to message #631028] Fri, 09 January 2015 00:02 Go to previous message
frankC
Messages: 2
Registered: December 2014
Junior Member
Thanks a lot for the quick response. I find the forum very fascinating and enriching.
Previous Topic: Refresh Production data to Development Schema
Next Topic: ORA:00600: internal error code, arguments: [kkzuasid]
Goto Forum:
  


Current Time: Thu Feb 22 07:31:44 CST 2018

Total time taken to generate the page: 0.07458 seconds