RE: More on that strange locking we have

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Fri, 8 Sep 2000 10:42:48 +1000
Message-Id: <10612.116477@fatcity.com>

Hi Michael,

Are you aware of the blocking problems associated with ITL entry shortages? If not, it is described in my book and on the Ixora web site at http://www.ixora.com.au/q+a/locks.htm.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: Michael Kline [mailto:maklinesr_at_home.com] Sent: Friday, 8 September 2000 8:00
To: Multiple recipients of list ORACLE-L Subject: More on that strange locking we have

We are now listing records by row id so we can tell which records are in the same blocks. We have 'some" consistency on the problem.

If we pick up a single block and we lock record 1, then 2, then 3, the forth lock fails. If we lock record 1, then 16, then 23, we can't lock 26.... Again the fourth one.

But it appears we can lock much more than that, if they are on different blocks. There is approximately 35 records per block.

I found rollback segments to be low, so I added about 8 more, and they are doing more testing. Haven't heard back so far.

ThinkSpark - Michael Alan Kline, Sr.
(formerly Database Consultants, Inc.)
Technical Consultant - Richmond, Virginia Office 13308 Thornridge Court; Midlothian, VA 23112, USA. W: 804-744-1545
Michael.Kline_at_ThinkSpark.com
Pager: 877-705-1155 or 8777051155_at_page.metrocall.com ICQ: 1009605, 975313 PhoneFree: 1057439 Received on Thu Sep 07 2000 - 19:42:48 CDT