Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- db_stat -CA
- Default locking region information:
- 6 Last allocated locker ID
- 0x7fffffff Current maximum unused locker ID
- 9 Number of lock modes
- 200 Initial number of locks allocated
- 0 Initial number of lockers allocated
- 200 Initial number of lock objects allocated
- 3000 Maximum number of locks possible
- 1500 Maximum number of lockers possible
- 1500 Maximum number of lock objects possible
- 200 Current number of locks allocated
- 15 Current number of lockers allocated
- 200 Current number of lock objects allocated
- 40 Number of lock object partitions
- 2053 Size of object hash table
- 12 Number of current locks
- 82 Maximum number of locks at any one time
- 4 Maximum number of locks in any one bucket
- 2 Maximum number of locks stolen by for an empty partition
- 2 Maximum number of locks stolen for any one partition
- 13 Number of current lockers
- 14 Maximum number of lockers at any one time
- 9 Number of current lock objects
- 51 Maximum number of lock objects at any one time
- 2 Maximum number of lock objects in any one bucket
- 0 Maximum number of objects stolen by for an empty partition
- 0 Maximum number of objects stolen for any one partition
- 5053 Total number of locks requested
- 5020 Total number of locks released
- 0 Total number of locks upgraded
- 5 Total number of locks downgraded
- 22 Lock requests not available due to conflicts, for which we waited
- 19 Lock requests not available due to conflicts, for which we did not wait
- 0 Number of deadlocks
- 0 Lock timeout value
- 0 Number of locks that have timed out
- 0 Transaction timeout value
- 0 Number of transactions that have timed out
- 2MB 504KB Region size
- 6 The number of partition locks that required waiting (0%)
- 2 The maximum number of times any partition lock was waited for (0%)
- 0 The number of object queue operations that required waiting (0%)
- 1 The number of locker allocations that required waiting (0%)
- 0 The number of region locks that required waiting (0%)
- 2 Maximum hash bucket length
- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
- Lock REGINFO information:
- Environment Region type
- 1 Region ID
- __db.001 Region name
- 0x7feaf89d6000 Region address
- 0x7feaf89d60a0 Region allocation head
- 0x7feaf8bd65b0 Region primary address
- 0 Region maximum allocation
- 0 Region allocated
- Region allocations: 283 allocations, 0 failures, 163 frees, 2 longest
- Allocations by power-of-two sizes:
- 1KB 278
- 2KB 0
- 4KB 1
- 8KB 0
- 16KB 0
- 32KB 0
- 64KB 2
- 128KB 0
- 256KB 1
- 512KB 0
- 1024KB 1
- REGION_SHARED Region flags
- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
- Lock region parameters:
- 2 Lock region region mutex [0/3274 0% 21989/140647174178624]
- 2053 locker table size
- 2053 object table size
- 2099280 obj_off
- 2316456 locker_off
- 1 need_dd
- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
- Lock conflict matrix:
- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
- Locks grouped by lockers:
- Locker Mode Count Status ----------------- Object ---------------
- 1 dd=11 locks held 1 write locks 0 pid/thread 21807/140233608316736 flags 10 priority 100
- 1 READ 1 HELD id2entry.bdb handle 0
- 2 dd=10 locks held 1 write locks 0 pid/thread 21807/140233608316736 flags 10 priority 100
- 2 READ 1 HELD dn2id.bdb handle 0
- 3 dd= 9 locks held 0 write locks 0 pid/thread 21807/140233608316736 flags 0 priority 100
- 4 dd= 6 locks held 1 write locks 0 pid/thread 21807/140233085118208 flags 10 priority 100
- 4 READ 1 HELD objectClass.bdb handle 0
- 5 dd= 5 locks held 1 write locks 0 pid/thread 21807/140233085118208 flags 10 priority 100
- 5 READ 1 HELD cloudIdeAliases.bdb handle 0
- 6 dd= 4 locks held 1 write locks 0 pid/thread 21807/140233085118208 flags 10 priority 100
- 6 READ 1 HELD ou.bdb handle 0
- 80000003 dd= 8 locks held 0 write locks 0 pid/thread 21807/140233608316736 flags 0 priority 100
- 80000004 dd= 7 locks held 1 write locks 1 pid/thread 21807/140233085118208 flags 0 priority 100
- 80000004 WRITE 1 HELD dn2id.bdb page 2
- 80000014 dd= 3 locks held 0 write locks 0 pid/thread 21807/140233059944192 flags 0 priority 100
- 80000014 READ 1 WAIT dn2id.bdb page 2
- 80000015 dd= 2 locks held 0 write locks 0 pid/thread 21807/140233043158784 flags 0 priority 100
- 80000016 dd= 1 locks held 0 write locks 0 pid/thread 21807/140233051551488 flags 0 priority 100
- 8000005b dd= 0 locks held 2 write locks 0 pid/thread 21807/140233051551488 flags 0 priority 100
- 8000005b READ 1 HELD 0x23f1b8 len: 9 data: 020000000000000000
- 8000005b READ 1 HELD dn2id.bdb page 10649
- 8000005c dd= 0 locks held 2 write locks 2 pid/thread 21807/140233051551488 flags 0 priority 100
- 8000005c READ 1 WAIT dn2id.bdb page 2
- 8000005c WRITE 1 HELD dn2id.bdb page 10516
- 8000005c WRITE 1 HELD dn2id.bdb page 10649
- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
- Locks grouped by object:
- Locker Mode Count Status ----------------- Object ---------------
- 6 READ 1 HELD ou.bdb handle 0
- 1 READ 1 HELD id2entry.bdb handle 0
- 8000005c WRITE 1 HELD dn2id.bdb page 10516
- 8000005b READ 1 HELD dn2id.bdb page 10649
- 8000005c WRITE 1 HELD dn2id.bdb page 10649
- 2 READ 1 HELD dn2id.bdb handle 0
- 80000004 WRITE 1 HELD dn2id.bdb page 2
- 8000005c READ 1 WAIT dn2id.bdb page 2
- 80000014 READ 1 WAIT dn2id.bdb page 2
- 8000005b READ 1 HELD 0x23f1b8 len: 9 data: 020000000000000000
- 5 READ 1 HELD cloudIdeAliases.bdb handle 0
- 4 READ 1 HELD objectClass.bdb handle 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement