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

  • Thread starter Thread starter toomaskask
  • Start date Start date
Status
Not open for further replies.
T

toomaskask

Guest
Hi! Just checked one of our databases and found that number of MTL_OM latches is pretty high: _Latch-Name _Latch-Lock _Latch-Wait latch/sec MTL_OM 4483906701 6844 4,483,906,701 MTL_OM 4483914640 6844 7,939 MTL_OM 4483922014 6844 7,374 MTL_OM 4483927715 6844 5,701 MTL_OM 4483933176 6844 5,461 MTL_OM 4483937684 6844 4,508 MTL_OM 4483941763 6844 4,079 MTL_OM 4483948088 6844 6,325 MTL_OM 4483969421 6844 21,333 MTL_OM 4484037072 6844 67,651 MTL_OM 4484104383 6844 67,311 MTL_OM 4484112012 6844 7,629 MTL_OM 4484117447 6844 5,435 MTL_OM 4484185073 6844 67,626 MTL_OM 4484206032 6844 20,959 MTL_OM 4484327023 6844 120,991 MTL_OM 4484353623 6844 26,600 Actual number of _storageobject records is 1600. Should I set -omsize to 2048 and expect something? Lower load? Increase in speed? Because of nature of our systems, it's almost impossible to set up full proper test environment, so I can change parameters only in production system. wbr, Toomas

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