Help - Database Growth and loading best practice

[Former Member]

Dear all,

I'm using NW 7.1

my data are consuming lots of space. I notice my data are grow at 20Gb per 2 month.

I wonder why the growth is so fast.

I using process chain to load my data and I always delete my data before full update my cube.

I kept only 1 week worth of data in my psa.

I do upload all my master data daily. ( full and delta upload )

Please advice

Regards,

-Dedys

[Former Member]

Thanks all.

I schedule to delete data from psa and the growt is reduced

[Former Member]

Occasionally run stats on all the tables and do a REORG on the database - sometimes even though you delete data in the tables - the space does not get released and only a reorg will release the space.

Run a reorg and see if the sizes change...

[Former Member]

Hi Dedy,

Its difficult to answer your question without some stats. use Tcode DBACOCKPIT to analyze different table spaces, by using option Space> Tablespaces or Space>Tables and Indexes. This will help to understand which tablespace / table is growing significantly and wil help you take necessary actions accordingly.

Let us know, your findings and if you need more help.

Cheers,

CK

[Former Member]

Hi,

I have open the table space and here things that show at the table spaces

PSAPSR3	140.000,00	10.018,13	93
PSAPSR3700	21.600,00	1.421,81	        93
PSAPSR3DB	5.000,00	  1.639,81	        67
PSAPSR3USR	20,00	        19,31	        3
PSAPTEMP	1.000,00	  998,00	        0
PSAPUNDO	9.020,00	  8.624,94	        4
SYSAUX	        320,00	        55,25	        83
SYSTEM	        560,00	        7,50	                99

the one that always full is the PSAPSR3

what kind of data that is in the PSAPSR3 category ?

please advice

[shanthi_bhaskar]

As BI consultant we were keen on PSAODS table which relates to PSA and changelog tables

[Former Member]

Your system tablespace shows 99% full. You should plan on allocating more space to SYSTEM.

Run this SQL statement in SQLPLUS (you can also use ST04 to gather this info)

SELECT SUM(BYTES) from dba_segments

where segment_name like '/BIC/B000%' ;

Can you tell us the result of this statement?