1 2 Previous Next 15 Replies Latest reply: Dec 5, 2012 1:08 AM by 975148 RSS

    Size of a 11g database

    975148
      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
          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
            http://lmgtfy.com/?q=size+of+oracle+database+
            • 3. Re: Size of a 11g database
              Osama_Mustafa
              Similar thread
              Check database size
              • 4. Re: Size of a 11g database
                Helios-GunesEROL
                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....
                  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
                    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
                      12cdb
                      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
                        Thanks for your answer.
                        • 9. Re: Size of a 11g database
                          975148
                          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
                            Request people on this forum to please reply.

                            Regards
                            • 11. Re: Size of a 11g database
                              sb92075
                              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
                                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
                                  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
                                    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