Question Re: Query on Database Size in Technology Q&A

Query on Database Size

Former Member — Fri, 18 Sep 2009 01:46:47 GMT

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

Re: Query on Database Size

Former Member — Fri, 18 Sep 2009 03:21:54 GMT

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

Re: Query on Database Size

Former Member — Fri, 18 Sep 2009 03:58:03 GMT

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

Re: Query on Database Size

Former Member — Fri, 18 Sep 2009 04:05:57 GMT

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

Re: Query on Database Size

Former Member — Fri, 18 Sep 2009 04:17:35 GMT

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

Re: Query on Database Size

anindya_bose — Fri, 18 Sep 2009 04:20:55 GMT

Which system?

ECC,Bi?

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

Re: Query on Database Size

Former Member — Fri, 18 Sep 2009 04:59:22 GMT

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.

Re: Query on Database Size

Former Member — Fri, 18 Sep 2009 05:04:38 GMT

Hi,

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

Thanks

Re: Query on Database Size

Former Member — Fri, 18 Sep 2009 05:04:53 GMT

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

Re: Query on Database Size

Former Member — Fri, 18 Sep 2009 05:17:37 GMT

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

Re: Query on Database Size

Former Member — Fri, 18 Sep 2009 05:31:30 GMT

Thanks Pravin,

Now I understand. Thank you very much.

Re: Query on Database Size

Former Member — Fri, 18 Sep 2009 05:32:45 GMT

Hi,

Im adding datafiles manually.

Thanks

Re: Query on Database Size

Former Member — Fri, 18 Sep 2009 05:45:51 GMT

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

Re: Query on Database Size

Former Member — Fri, 18 Sep 2009 06:09:05 GMT

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

Re: Query on Database Size

fidel_vales — Fri, 18 Sep 2009 06:56:33 GMT


> 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