| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
