RDBPROD: record locks statistics
edited Jan 10, 2014 1:14PM in Rdb on OpenVMS, IBM zSeries and Oracle on OpenVMS (MOSC) 6 commentsAnswered
Hello everyone,
I would like to get any commets on the below rmu/sho stat display.
I think that the "record locks" statistics is a bit high.
Do you agree ?
Could you suggest what sholud be done to improve this indicator ?
Oracle Rdb V7.1-521 Perf. Monitor 23-OCT-2013 12:51:51.69
Rate: 3.00 Seconds Locking (stall time x100) Elapsed: 100 21:48:44.63
statistic......... rate.per.second............. total....... average......
name.............. max..... cur..... avg....... count....... per.trans....
total locks 8923 0 1.4 15533484 0.3
area locks 0 0 0.0 0 0.0
buffer/page locks 13 0 0.0 109847 0.0
record locks 8922 0 0.9 10044508 0.2 <--------
SEQBLK lock 27 0 0.1 989484 0.0
FILID locks 0 0 0.0 196 0.0
TSNBLK locks 3 0 0.0 20962 0.0
RTUPB lock 0 0 0.0 4886 0.0
ACTIVE lock 0 0 0.0 103 0.0
MEMBIT lock 0 0 0.0 0 0.0
AIJ locks 0 0 0.0 260 0.0
snapshot locks 0 0 0.0 0 0.0
freeze lock 0 0 0.0 5008 0.0
quiet point lock 0 0 0.2 2871717 0.0
logical area locks 13 0 0.0 174323 0.0
0