Freddie,

LOCK_HEADER BLOCK
                Version: 145, Active owner:      0, Length: 25165824, Used: 
24798216
                Flags: 0x0001
                Enqs: 17157097538, Converts: 22693011, Rejects: 12135777, 
Blocks: 93039760
                Deadlock scans:    289, Deadlocks:      1, Scan interval:  10
                Acquires: 18346589405, Acquire blocks: 1203176111, Spin count:  
 0
                Mutex wait: 6.6%
                Hash slots: 1009, Hash lengths (min/avg/max):   47/  67/  93
                Remove node:      0, Insert queue:      0, Insert prior:      0
                Owners (151):   forward:  30704, backward: 21097392
                Free owners (4):             forward: 750216, backward: 24346456
                Free locks (10120):         forward:  28728, backward: 693760
                Free requests (7877):    forward: 8570432, backward: 1678000
                Lock Ordering: Enabled

Increase the number of hash slots (at least x10) and increase the lock manager 
memory (x4 to x6) in your fbconfig. File


Sean

  • [firebird-supp... Freddy Ertl f.e...@speexx.com [firebird-support]
    • [firebird... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
    • Re: [fire... Alexey Kovyazin a...@ib-aid.com [firebird-support]
      • AW: [... Freddy Ertl f.e...@speexx.com [firebird-support]
        • R... Alexey Kovyazin a...@ib-aid.com [firebird-support]

Reply via email to