Database Tuning (MOSC)

MOSC Banner

row lock waits

edited Mar 23, 2011 2:46AM in Database Tuning (MOSC) 4 commentsAnswered
 Hi,
I would like to know what causes row lock waits on Indexes. Is that heavily stuffed block with less pct_free?

I have a non-partitioned table with 200 million rows and with 7 Indexes. Every day around 350K rows will be inserted to this table using Informatica job. Informatica statistics are showing writer is 99% busy. When I am looking into the issue I found that all the Indexes are experiencing row lock waits.

Please see the excerpt from v$segment_statistics.

OBJECT_NAME   STATISTIC_NAME                                                        VALUE
------------- ---------------------------------------------------------------- ----------
IDX_A         logical reads                                                       4870560
IDX_A         buffer busy waits                                                         1
IDX_A         gc buffer busy                                                            0

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center