ENQUEUE WAITS ON TABLE SEGMENTS
Hi All
One thing I would like share with all of you, in my production database there is one batch job which runs at end of the each day, during this batch job we are facing lots of enqueue on table segments.
When I looked at wait V$session_wait lots of enqueue were happening and also I came to know that there is one table on which so many many updates are happening I think this is the main root cause as per my analysis.
Due you have any suggestions so that we can avoid enqueue waits on this table segmenmts ?
One thing I would like share with all of you, in my production database there is one batch job which runs at end of the each day, during this batch job we are facing lots of enqueue on table segments.
When I looked at wait V$session_wait lots of enqueue were happening and also I came to know that there is one table on which so many many updates are happening I think this is the main root cause as per my analysis.
Due you have any suggestions so that we can avoid enqueue waits on this table segmenmts ?
0