Home » RDBMS Server » Server Administration » locks on oracle 11g (merged 3) (orcale database 11.1.0.7.0 with AIX 5.3, 64 bits)
locks on oracle 11g (merged 3) [message #426567] Fri, 16 October 2009 12:28 Go to next message
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

Best regards


Re: locks on oracle 11g (merged 3) [message #428178 is a reply to message #426567] Tue, 27 October 2009 07:37 Go to previous messageGo to next message
yomghi
Messages: 3
Registered: October 2009
Location: paris
Junior Member
Hum, does any body have any idea ? Could anyone confirm the strange result of my test case ? Please help. Sad
Re: locks on oracle 11g (merged 3) [message #428182 is a reply to message #428178] Tue, 27 October 2009 07:49 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
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


Post your SQLNET.ORA
Re: locks on oracle 11g (merged 3) [message #428183 is a reply to message #428182] Tue, 27 October 2009 07:53 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/consist.htm#CNCPT1339
Previous Topic: alertlog file size
Next Topic: Unable to stop the trace files
Goto Forum:
  


Current Time: Sat Sep 24 16:21:07 CDT 2016

Total time taken to generate the page: 0.10433 seconds