RE: insert blob slow in 10g

From: David Boyd <davidb158_at_hotmail.com>
Date: Thu, 7 Jun 2007 13:42:49 -0400
Message-ID: <BAY137-W17B0041CA1395584D95923EF260@phx.gbl>

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_at_adastracorp.comTo: davidb158_at_hotmail.com; oracle-l_at_freelists.orgDate: 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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 07 2007 - 12:42:49 CDT