what type of enqueues are they
On 12/10/06, San Sridharan <san_oracle_dba_at_yahoo.com> wrote:
>
> We have an application that writes to a CLOB field in the database. The
> DB version is Oracle9i Enterprise Edition Release 9.2.0.7.0
>
>
>
> INSERT
> INTO usr_sssn_item
>
> (sssn_id, last_updt_dt, KEY, data_item_bl
>
> )
>
> VALUES (:sessionid, SYSDATE, :KEY, :dataitem
>
> )
>
>
>
> Recently we have been seen lots of ENQUEUE wait events and sessions that
> does the insert blocks other sessions. User has been complaining about
> performance.
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 12 2006 - 16:59:56 CDT
