Latch waits

Posted in 2005

Geezer From The Freezer — Tue, 05 Jul 2005 10:58:27 +0100 — source: Usenet: comp.databases.informix

I'm seeing quite a highish level of latch waits (lchwaits) - whats the best way to reduce this? Increase the shared memory?

↪ replying to Geezer From The Freezer

Art S. Kagel — Tue, 05 Jul 2005 18:45:09 -0400 — source: Usenet: comp.databases.informix

Geezer From The Freezer wrote: > I'm seeing quite a highish level of latch waits (lchwaits) - whats the > best way to reduce this? Increase the shared memory? Depends on what's being latched. Onstat -g wmx to see what kind of latches are causing waits and who's waiting on them. Art S. Kagel

Glossary

shared memory