RE: enq: HW on CLOB.
From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Mon, 10 Dec 2012 00:43:46 -0800 (PST)
Message-ID: <1355129026.99401.YahooMailNeo_at_web161304.mail.bf1.yahoo.com>
Joel,
Having a brief spike in concurrent sessions (dedicated server configuration) trying to insert into one table can cause 'enq: HW' waitevent as each concurrent session may potentially get one separate block allocated for the insert by ASSM.
Date: Mon, 10 Dec 2012 00:43:46 -0800 (PST)
Message-ID: <1355129026.99401.YahooMailNeo_at_web161304.mail.bf1.yahoo.com>
Joel,
Having a brief spike in concurrent sessions (dedicated server configuration) trying to insert into one table can cause 'enq: HW' waitevent as each concurrent session may potentially get one separate block allocated for the insert by ASSM.
Your can read about LOB storage at http://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_tables.htm#CIHEBABG
Thanks,
Sai
http://sai-oracle.blogspot.com
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 10 2012 - 09:43:46 CET