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

We are on,
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.

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: Mon Oct 24 22:52:34 CDT 2016

Total time taken to generate the page: 0.05145 seconds