Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: insert blob slow in 10g

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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US