Home » RDBMS Server » Performance Tuning » Partitioned table growing too fast (10.2.0.3 on Solaris 8)
icon8.gif  Partitioned table growing too fast [message #349311] Fri, 19 September 2008 19:45 Go to next message
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.
Re: Partitioned table growing too fast [message #349314 is a reply to message #349311] Sat, 20 September 2008 00:07 Go to previous messageGo to next message
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?
Re: Partitioned table growing too fast [message #349317 is a reply to message #349311] Sat, 20 September 2008 00:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Partitioned table growing too fast [message #349341 is a reply to message #349317] Sat, 20 September 2008 08:13 Go to previous messageGo to next message
IMRAN2008
Messages: 2
Registered: September 2008
Junior Member
Hi

All are equal
Re: Partitioned table growing too fast [message #349342 is a reply to message #349311] Sat, 20 September 2008 08:27 Go to previous messageGo to next message
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?)
Re: Partitioned table growing too fast [message #349363 is a reply to message #349341] Sat, 20 September 2008 13:27 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
IMRAN2008 wrote on Sat, 20 September 2008 15:13
Hi

All are equal

Prove it!

Regards
Michel

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


Current Time: Fri Dec 09 17:16:06 CST 2016

Total time taken to generate the page: 0.12857 seconds