Database growing rapidly

[Former Member]

Dear all,

We are facing the problem where our database is getting increrased rapidly.We are already facing a problem where our daily growth is around 1.5 GB, for which we are yet tracing the root cause for the same.But all of a sudden from past 2days the consumption has increased to 6.6 and 5.3 GB approx respt. When investigated with functional team,there is no upload or activity is performed that would increase consumptionof the DB.

-

---

Screen shot of the db02old TB space history is been pasted below.

Scale: Day Size (Kbyte) Free(Kbyte) Used (Kbyte) %-Used Tables/Indices Extents

Date Total Delta Total Total Delta Total Delta Total Delta Total Delta

17.03.2011 944,128,000 0 9,640,448 934,487,552 206,848 98 0 159958 0 308,209 6

16.03.2011 944,128,000 0 9,847,296 934,280,704 5,309,888 98 0 159958 0 308,203 180

15.03.2011 944,128,000 0 15,157,184 928,970,816 6,695,232 98 1 159958 0 308,023 180

14.03.2011 944,128,000 0 21,852,416 922,275,584 1,668,480 97 0 159958 2 307,843 116

13.03.2011 944,128,000 0 23,520,896 920,607,104 493,632 97 0 159956 0 307,727 21

12.03.2011 944,128,000 0 24,014,528 920,113,472 1,601,536 97 0 159956 0 307,706 52

11.03.2011 944,128,000 0 25,616,064 918,511,936 1,635,712 97 0 159956 0 307,654 77

10.03.2011 944,128,000 0 27,251,776 916,876,224 1,613,184 97 1 159956 0 307,577 132

09.03.2011 944,128,000 0 28,864,960 915,263,040 2,341,440 96 0 159956 0 307,445 153

08.03.2011 944,128,000 0 31,206,400 912,921,600 2,262,400 96 0 159956 4 307,292 123

07.03.2011 944,128,000 0 33,468,800 910,659,200 1,339,648 96 0 159952 2 307,169 118

-

---

Request you to kindly suggest so that we can check for root cause and rectify the same.

Kindly treat this as high priority.Eagerly waiting for the positive reply,

Regards,

Amit

Edited by: amit prayag on Mar 17, 2011 4:21 AM

[Former Member]

Hi

Firstly, What is you system ? Is it a new install / upgraded or an established system

What is your database

What tablespace is this that is growing...

How is your tablespace datafiles configured... E.G autoextend what is the next extent value

do you have table logging on ?

Have you an archive strategy ?

Lots of questions.......! need answers to get close to your problems....

Regards

Mark

[Former Member]

Hi,

System is 2 yrs old.No activity of upgrade is performed.

Database is Oracle .Table space PSAPSR3 is getting occupied.

Autoextnd is off.

No archive activity performed.Table logging is also not enabled.

We are observing from few days that the DB is growng with 1.5 GB approx consumption.All of a sudden on last 2 days and today we have a consumption of 6,5,and 3GB respt.

When asked to functional team, no activity has been performed is what response we get.

We are aware of high sized tables like ACCT*,FAGKL but when checked in DB02old the growth or chng/day is not high.

Table Name Type Size (Kbyte) Extents

Total Chg/day Total Chg/day

ACCTIT TABLE 47,986,688 124,116 933 2

EX: Scale: Day Size (Kbyte)

Date Total Delta

18.03.2011 47,986,688 136,192

17.03.2011 47,850,496 70,656

16.03.2011 47,779,840 196,608

15.03.2011 47,583,232 131,072

14.03.2011 47,452,160 0

13.03.2011 47,452,160 196,608

12.03.2011 47,255,552 0

Thus , we are unable to find the table that is consuming huge data.

Kindly suggest.

Regards,

Amit

[Former Member]

Hi,

So what tables are moving daily?

db02old => space statitistics => table/indexes

Also are you doing any online reorgs ?

The FAGKL* table is a good one to reclaim space.

Mark

[Former Member]

Hello Amit,

If your system is BW, please check if you've put in place a clean of old PSAs?

And check what is the size of the table RSBATCHDATA, if the size is too large, you can clean it with the transaction RSBATCH.

Hope it's helpful.

Best regards,

Hoangson

[Former Member]

Hi Amit,

I would start with checking for the fastest growing tables and see what functionality is making use of these tables, so you know in what area these high volumes are being processed. Perhaps some functional person made some changes, which are causing this.

The easiest way (in my opinion) to check the fastest growing tables is via transaction DB02OLD -> Detailed analysis -> (select object type table) and go. Now sort on size and check the history per table.. Here you can see the growth per date, so it should give an indication as of which day the increasing started.

Kind regards,

Mark