transaction enqueue lock

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 15 Aug 2002 09:47:46 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702829C16@lnewton.leeds.lfs.co.uk>

Jon,

first of all, well spotted for noticing that when I wrote 'MINTRANS' I didn't have a clue what I was talking about, I meant to write INITRANS instead :o)

Next up, I asked on this NG many moons ago about how to set INITRANS on an index when the table has 'n'. I was told that the index should have 'n+1'.

I assume that having PCTFREE set to 40 should leave enough space in the block for a slot - if one cannot be obtained in the block header, so silly stuff now :

what are the settings for :

DML_LOCKS, ENQUE_RESOURCES and TRANSACTIONS in initSID.ora ?

It could be that these are set pretty funny and are holding you back.

Maybe, but unlikely :o(

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

Received on Thu Aug 15 2002 - 03:47:46 CDT