Forum Post: RE: 11.3.2: default -omsize & high number of MTL_OM latches

  • Thread starter Thread starter gus
  • Start date Start date
Status
Not open for further replies.
G

gus

Guest
code to check: define variable prev-latches as integer. repeat: find _latch where _latch-name = "MTL_OM". display _Latch-Name _Latch-Lock /* # times latch acquired */ _Latch-Wait /* # time conflict occurred */ _Latch-Lock - prev-latches label "latch/sec". prev-latches = _Latch-Lock. pause 1. end. code to figure out what to set -omsize to: select count(*) from _storageobject. the number of storage objects you have is how many object mappings you need. allow some (say 15% or 20%) extra for headroom.

Continue reading...
 
Status
Not open for further replies.
Back
Top