Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Index - Row Lock Waits

538022Dec 18 2007 — edited Dec 19 2007
Hello guys,
i am facing many "enq: TX - row lock contention" wait events in an AWR report and have a look at the statistic for "Segments by Row Lock Waits" and it looks like this.
Segments by Row Lock Waits                 
-> % of Capture shows % of row lock waits for each top segment compared
-> with total row lock waits for all segments captured by the Snapshot

                                                                     Row
           Tablespace                      Subobject  Obj.          Lock    % of
Owner         Name    Object Name            Name     Type         Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
OPRASC     POPRASC    RANT~0                          INDEX       15,995    4.69
OPRASC     POPRASC    VFEN                            TABLE       15,340    4.49
OPRASC     POPRASC    FJIJJOWMNV~001                  INDEX       14,098    4.13
OPRASC     POPRASC    SEAPOLNMNB~0                    INDEX       14,050    4.12
OPRASC     POPRASC    WESAC~SR3                       INDEX       12,976    3.80
          -------------------------------------------------------------
Database version: 10.2.0.2

I can understand the statistic for the table VFEN, but why are there so many indexes in that statistic? And what can cause a "Row Lock Wait" on an index segment?

There is no FK or and PK constraint. There are only some constraints on that corresponding table columns for "IS NOT NULL".

Thanks for your help.

Regards
Stefan

Comments

If you run this from the command line for the console, do you get any output? - just ot see if there are errors.
Also, try to run it with the shell script too, I did see some intermittent issues on 64 bit where some toolbar items were not visible

thanks
B
Answer
Did you install the SDK or JRE of 1.6? It looks like tools.jar is missing; this file is included with the SDK, but not a JRE.

- John
SQL Developer Team
Marked as Answer by 727458 · Sep 27 2020
727458
From previous versions of SQLDev I had desktop shortcut that called the .bat file (because there was no 64bit sqldeveloper.exe previously). It used first java it found in a PATH and it was the one from JRE. Thanks for pointing to right direction!
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 16 2008
Added on Dec 18 2007
#general-database-discussions
10 comments
7,992 views