R
Rob Fitzpatrick
Guest
You could turn on client statement caching for the app server agents; use the option for the current frame, not the whole stack. Then you can use ProTop to view that info, including program names and line numbers, and the blocked-client list in real time. Then when the problem hits, just hit "M" to mail yourself the info from the screens for later analysis. Or you can write your own code to get that info from _connect, _lock, etc., or screen-scrape promon.
Continue reading...
Continue reading...