OraFAQ Forum: Server Administration » locks on oracle 11g (merged 3)

Home » RDBMS Server » Server Administration » locks on oracle 11g (merged 3) (orcale database 11.1.0.7.0 with AIX 5.3, 64 bits)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

locks on oracle 11g (merged 3) [message #426567]

Fri, 16 October 2009 12:28

yomghi
Messages: 3
Registered: October 2009
Location: paris

Junior Member

Hello,

We noticed a strange difference in the behavior of oracle 11g and 9i. It is about locks.

We created tables with keys as shown in the joined document.

When we made an insert in a child table, it makes locks on the parent table, BUT DIFFERNET KIND of locks according to the version ?????
- Row-X(SX) (« mode held ») on oracle 11g
- Row-S(SS) (« mode held ») on oracle 9i
Unfortunately we have the 11g version and it is a big problem for us because we meet lots of locks and have to kill a session every hour... Sad

However, the gap might come from oracle soft or from a parameter of our own database. Actually the test we made on the 11g version was located in our own database, with two new tables.

Whereas the test we made with the 9i version was on a new database, we just build for the occasion.

You will find attached to this message the SQL and the results of it... It is amazing and really a big problem because we met lots of locking troubles.

If you have any idea about the reason why (parameter of the data, patch on oracle), I would be so glad ! Smile