OraFAQ Forum: Server Administration » How do I calculate the size of my database?

Home » RDBMS Server » Server Administration » How do I calculate the size of my database?

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

How do I calculate the size of my database? [message #631010]

Wed, 07 January 2015 21:30

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

BlackSwan
Messages: 26640
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.

Report message to a moderator

Re: DABABASE [message #631028 is a reply to message #631012]

Thu, 08 January 2015 00:47

Michel Cadot
Messages: 66714
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.

Report message to a moderator

Re: DABABASE [message #631088 is a reply to message #631028]

Fri, 09 January 2015 00:02

frankC
Messages: 2
Registered: December 2014

Junior Member

Thanks a lot for the quick response. I find the forum very fascinating and enriching.

Report message to a moderator

Previous Topic:	Refresh Production data to Development Schema
Next Topic:	ORA:00600: internal error code, arguments: [kkzuasid]

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 16:36:23 CST 2019