Home » RDBMS Server » Server Administration » Bug No. 6376915 (10g Rel 2)
Bug No. 6376915 [message #301788] Thu, 21 February 2008 13:43
faiz_hyd
Messages: 294
Registered: February 2006
Senior Member
Hi,

We are on 10.2.0.3,
On one of the frequently accessed and inserted table, since last 2 days we were getting " ENQ: HW - CONTENTION WITH LOB SEGMENTS ". All the inserts were just piling up and things were slow,

Searching metalink and documentation pointed to this bug# 6376915 , and there is patch for it,
Wondering if any one else before came across this and have implemented this for a similar issue,

This table stores Data for 7 days only and on 8th day it we delete data of the oldest date, by Delete Statement,
this is a NON Partitioned Table,

Any other comments or suggestions on this.

Thanks
Previous Topic: ORA-39700 on newly created database
Next Topic: Does the Index which was moved to the other tablespace would be rebuilt concurrency?
Goto Forum:
  


Current Time: Fri Dec 02 21:06:37 CST 2016

Total time taken to generate the page: 0.09404 seconds