OraFAQ Forum: Performance Tuning » Partitioned table growing too fast

Home » RDBMS Server » Performance Tuning » Partitioned table growing too fast (10.2.0.3 on Solaris 8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Partitioned table growing too fast [message #349311]

Fri, 19 September 2008 19:45

IMRAN2008
Messages: 2
Registered: September 2008

Junior Member

Hi, we have exactly the same (partitioned) table in 2 seperate databases. Both are being pumped with data from the same load process. However, one is growing 5 times faster than the other. Why could that be considering the table creation script is the same.

Report message to a moderator

Re: Partitioned table growing too fast [message #349314 is a reply to message #349311]

Sat, 20 September 2008 00:07

Kriptas
Messages: 118
Registered: June 2008

Senior Member

maybe one table is creates with COMPRESS clause and other with NOCOMPRESS?
and other thing, maybe in one ETL scrip you use /*+ APPEND*/ hint and in other not?

Report message to a moderator

Re: Partitioned table growing too fast [message #349317 is a reply to message #349311]

Sat, 20 September 2008 00:20

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Check database blocks, tablespace parameters (extent management, allocation type, segment space management), table and partition storage parameters.
Also check database versions up to 4 decimals.

Regards
Michel

Report message to a moderator

Re: Partitioned table growing too fast [message #349341 is a reply to message #349317]

Sat, 20 September 2008 08:13

IMRAN2008
Messages: 2
Registered: September 2008

Junior Member

Hi

All are equal

Report message to a moderator

Re: Partitioned table growing too fast [message #349342 is a reply to message #349311]

Sat, 20 September 2008 08:27

Kriptas
Messages: 118
Registered: June 2008

Senior Member

do you use /*+ APPEND */ hint in etl ?
you can try to create the taple copies on all two databases
use the same table creation DML and name tables with _tmp at end.
on both databases load new tables from old ones with data using
insert into tblnm_tmp
select * from tblnm

and look at the size of the tables in tablespaces.

(or maybe you talking about row count growing 5 times faster?)

Report message to a moderator

Re: Partitioned table growing too fast [message #349363 is a reply to message #349341]

Sat, 20 September 2008 13:27

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

IMRAN2008 wrote on Sat, 20 September 2008 15:13

Hi

All are equal

Prove it!

Regards
Michel

Report message to a moderator

Previous Topic:	Tuning query approach
Next Topic:	Relationsip between Parallel Degree & Clustering Factor

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 09:25:33 CST 2024