Query on Database Size

[Former Member]

Hi all,

I have a question regarding database size of my SAP Instance. My database by the way is Oracle 10g. I used the db02old transaction code. I got the ff: data in the space statistics:

Scale: Month Database

Date Values SIze/kb Free/kb

01.09.2009 Total 258744,320 27,741,824

01.08.2009 Total 258744,320 30,568,320

01.07.2009 Total 258744,320 34,444,288

01.06.2009 Total 258744,320 38,159,168

01.05.2009 Total 247152,640 29,041,344

01.04.2009 Total 247152,640 35,197,184

01.03.2009 Total 235560,960 39,262,144

01.02.2009 Total 205455,360 14,124,224

01.01.2009 Total 201175,040 14,463,168

01.12.2008 Total 197324,800 14,466,112

01.11.2008 Total 193474,560 14,282,560

01.10.2008 Total 188907,520 13,716,736

Note that the size from 01.06.2009 to 01.09.2009 has not changed. Does this mean that my database hasnt grown at all?

How can I determine the exact growth of my database? Im planning to do some projection on how long will it take before my entire disks are consumed so I need to gather some data with respect to my database growth per month.

Thanks in advance

Jun

[Former Member · Accepted solution]

Easiest way would be to

In DB02OLD

Click on Space Statistics

Not sure how history you have.

Click Months/Weeks/Days

Months is a better option for average growth

Total up for all of the tablespaces

Pravin

[Former Member · Accepted solution]

Hi Pravin,

That's exactly what I did. And I also used the month option. The question is, the size from June to Aug 2009 hasnt changed. Please refer to the data I provided earlier. Does it mean that my database hasnt grown during this period? It may not be possible since we are also using the system normally during the specified period.

Hope you can enlighten me on this,

Thanks

[Former Member · Accepted solution]

But, free size has been reduced w.r.t total size. What does it mean ?

[Former Member · Accepted solution]

As Anjali rightly pointed out.

Total size has not increased but used has increased as you see the free space has decreased.

Your database has grown by the amount of free space it has consumed

Hope that clears your doubt

Pravin

[Former Member · Accepted solution]

Hi Pravin,

Im sorry but Im still confused. I see the free space has decreased allright and since, it has decreased, then we're pretty sure that database has grown allright. But let me put it this way. What if someone will ask me this, What is the size of your database from June 2009, July 2009 and Aug 2009? How would I answer it? Shall I say DB size for June 2009 is 258,744,320kb, July 2009 is 258,744,320kb and August 2009 is 258,744,320kb?

Thanks in advance.

[Former Member · Accepted solution]

ok, once let us know something. Are your tablespaces/datafiles in 'Autoextend' mode or you add datafiles manually ?

[Former Member · Accepted solution]

If you want to be soooo specific but that would be incorrect answer

Then the answer would be Total space -Free Space = Space used by Database.

As obvioulsy you cant have a database running with 100% used.

Depends on how much a buffer you keep before you add a new datafile.

You are looking for growth rate and look at the deltas of the used space and that is your growth.

Pravin

[Former Member · Accepted solution]

Thanks Pravin,

Now I understand. Thank you very much.

[Former Member · Accepted solution]

Hi,

Im adding datafiles manually.

Thanks

[Former Member · Accepted solution]

and probably you didn't add any datafile during those three months, that's why total size doen't differ.

[Former Member · Accepted solution]

HI Anjali,

Yes, that's precisely what happened. Now I know that the size indicated in db02old is not actually the size of the data contained in the database but rather, its the size of the tablespaces in my database.

Thank you very much for the enlightenment.

Best regards

[fidel_vales · Accepted solution]

>

> HI Anjali,
> 
> Yes, that's precisely what happened. Now I know that the size indicated in db02old is not actually the size of the data contained in the database but rather, its the size of the tablespaces in my database.
> 
> Thank you very much for the enlightenment.
> 
> Best regards

Hi,

Sorry for "interrupt" here.

I'd recommend you to read the Oracle Database Concept Guide or go to any initial training (like ADM505)

There you will find out that with "database" Oracle refers to the physical files.

You can create a DB of 1 TB and that will be the database size, regardless of the data that is "inside".

That means that, at the end, you more or less understood.

DB02 shows the database size, not the amount of data that is inside the database

[anindya_bose]

Which system?

ECC,Bi?

Do you have Early Watch Report? It shows database growth rate.

[Former Member]

Hi,

Its ECC. I checked on the EWA but I prefer to look at the summary.

Thanks