Latch wait time
From: Bob S (noone_at_nowhere.com)
Date: 11/16/04
- Next message: \: "Re: trigger debug"
- Previous message: jxstern: "Re: right way to perfromance tune?"
- Next in thread: AnthonyThomas: "Re: Latch wait time"
- Reply: AnthonyThomas: "Re: Latch wait time"
- Reply: Sue Hoegemeier: "Re: Latch wait time"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 15 Nov 2004 22:22:52 -0500
Does anyone know the potential causes of a high average latch wait time
(12-20 sec) for LATCH_EX? Total average disk queue depth << 1, CPU at 40%,
not many inserts, client side cursors.
- Next message: \: "Re: trigger debug"
- Previous message: jxstern: "Re: right way to perfromance tune?"
- Next in thread: AnthonyThomas: "Re: Latch wait time"
- Reply: AnthonyThomas: "Re: Latch wait time"
- Reply: Sue Hoegemeier: "Re: Latch wait time"
- Messages sorted by: [ date ] [ thread ]