Question Re: Help - Database Growth and loading best practice in Technology Q&A

Help - Database Growth and loading best practice

Former Member — Mon, 22 Mar 2010 01:46:28 GMT

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

Re: Help - Database Growth and loading best practice

Former Member — Mon, 22 Mar 2010 02:37:48 GMT

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,

Re: Help - Database Growth and loading best practice

Former Member — Mon, 22 Mar 2010 06:20:46 GMT

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

Re: Help - Database Growth and loading best practice

shanthi_bhaskar — Mon, 22 Mar 2010 06:30:48 GMT

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

Re: Help - Database Growth and loading best practice

Former Member — Tue, 23 Mar 2010 16:23:07 GMT

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?

Re: Help - Database Growth and loading best practice

Former Member — Tue, 23 Mar 2010 18:46:40 GMT

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...

Re: Help - Database Growth and loading best practice

Former Member — Thu, 24 Feb 2011 11:23:04 GMT

Thanks all.

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