RE: insert blob slow in 10g
- From: David Boyd <davidb158@xxxxxxxxxxx>
- To: "Jalovec, Jakub" <jakub.jalovec@xxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Jun 2007 13:42:49 -0400
Jakub,
Thanks for your reply. The max of blob size is 1M and the average is 0.2M.
Both initial and next extents are 1M. Our chunk size is 8K.David
From: Jakub.Jalovec@xxxxxxxxxxxxxxxxx: davidb158@xxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxxxxxx: Thu, 7 Jun 2007 19:00:03 +0200Subject: RE: insert
blob slow in 10g
David,
try to play with storage parameters of the LOB column
- initial and next extent
- enable/disale storage in row
- chunk size
What is average blob size?
Cache helped me as well.
it's old but useful
http://www.oracle.com/technology/products/database/application_development/pdf/lob_performance_guidelines.pdf
Jakub
_________________________________________________________________
Make every IM count. Download Windows Live Messenger and join the i’m
Initiative now. It’s free.
http://im.live.com/messenger/im/home/?source=TAGWL_June07
Other related posts:
