This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Dec 4, 2012 11:08 PM by 975148 RSS

Size of a 11g database

975148 Newbie
Currently Being Moderated
I want to find the size of my 11g production database.

I hope, my question is clear. Please revert with the reply to my query.

Regards
  • 1. Re: Size of a 11g database
    asifkabirdba Guru
    Currently Being Moderated
    select round((sum(bytes)/1048576/1024),2)
    from V$datafile;

    select round((sum(bytes)/1048576/1024),2)
    from V$tempfile;



    Regards
    Asif Kabir
  • 2. Re: Size of a 11g database
    Fran Guru
    Currently Being Moderated
    http://lmgtfy.com/?q=size+of+oracle+database+
  • 3. Re: Size of a 11g database
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Similar thread
    Check database size
  • 4. Re: Size of a 11g database
    Helios-GunesEROL Oracle ACE
    Currently Being Moderated
    Hi;

    Similar issue mention here many times,please use search mechanisim.

    https://forums.oracle.com/forums/search.jspa?threadID=&q=database+size&objID=c18&dateRange=all&userID=&numResults=15

    Regard
    Helios
  • 5. Re: Size of a 11g database
    Aman.... Oracle ACE
    Currently Being Moderated
    The size of the database is what is the size of the tablespaces that it is made of. So question for you, how would you find the size of a tablespace?

    Aman....
  • 6. Re: Size of a 11g database
    EdStevens Guru
    Currently Being Moderated
    972145 wrote:
    I want to find the size of my 11g production database.

    I hope, my question is clear. Please revert with the reply to my query.

    Regards
    It depends on how you define "the size of the database"

    Is it the size of the datafiles?
    Even if a data file is 95% empty?
    Do you include temp files?
    Do you include online redo logs?
    Do you include control files?
    Is it just the amount of space occupied by actual data?
    Blocks allocated to an extent but as yet still unused?
  • 7. Re: Size of a 11g database
    user296828 Expert
    Currently Being Moderated
    In addition what have already said,
    select sum(bytes)/power(2,20) "Size In MB" from dba_segments;
    You can also check the actual size occupied at OS level by looking at the size of each database files.
  • 8. Re: Size of a 11g database
    975148 Newbie
    Currently Being Moderated
    Thanks for your answer.
  • 9. Re: Size of a 11g database
    975148 Newbie
    Currently Being Moderated
    This is a very good point. For all the people on this question, the Oracle documentation also says that the size of the DB is the sum of its tablespaces. What's the query going to
    be to find the sum of its tablespaces. Also, how to find the sum of only used blocks in the tablespace and not empty blocks as that is going to be the actual size occupied?

    Request you to please revert with the answers.

    Regards
  • 10. Re: Size of a 11g database
    975148 Newbie
    Currently Being Moderated
    Request people on this forum to please reply.

    Regards
  • 11. Re: Size of a 11g database
    sb92075 Guru
    Currently Being Moderated
    972145 wrote:
    Request people on this forum to please reply.

    Regards
    answer our questions so we can answer yours.

    It depends on how you define "the size of the database"

    Is it the size of the datafiles?
    Even if a data file is 95% empty?
    Do you include temp files?
    Do you include online redo logs?
    Do you include control files?
    Is it just the amount of space occupied by actual data?
    Blocks allocated to an extent but as yet still unused?
  • 12. Re: Size of a 11g database
    975148 Newbie
    Currently Being Moderated
    As per one of my earlier post, I was looking on the lines of "The size of the database is the sum of its tablespaces".

    Regards
  • 13. Re: Size of a 11g database
    sb92075 Guru
    Currently Being Moderated
    972145 wrote:
    As per one of my earlier post, I was looking on the lines of "The size of the database is the sum of its tablespaces".

    Regards
    OK, that works for you, then it works for me.
  • 14. Re: Size of a 11g database
    jgarry Guru
    Currently Being Moderated
    You seem to think this forum is a magical fount of all knowledge for your personal edification. Please understand that some effort is expected of you to ask a smart question. You are expected to have at least made an attempt to read the documentation, and at least made an attempt to search the internet and the archives of this group for an answer.

    It's ok to be ignorant, that is easily fixed with knowledge. It's not ok to expect people to do your work for you. That hopefully isn't your intention, but it's starting to look that way to some of us. We need more context in your questions when you first post them. Please see http://www.catb.org/esr/faqs/smart-questions.html

    You should have gotten the hint that there are dependencies in your question, not the least of which is the exact definition of "size." When you answer that deterministically, you can get a formula for an answer. Oracle doesn't always use disk in a simple manner. You might look at how much space is used, and how much is free, and your user will discover they can't add something tiny. If you respond to such a problem in the wrong way, you will lose data and fail as a dba.

    The skill is to ask the right question, and know how to get the right answer. Basic knowledge is the prerequisite for that.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points