Re: Enqueue Diagnosis

Brian,

Thanks for the advice. I just have one more thing to clarify.....

I have a trace file for a session that incurred a 4 minute enqueue wait (TX 6)on a very small table (50 rows 2 columns). The hit rate on this table is quite low.

When analyzing the trace file with TRCANLZR, I picked up on the fact that over a period of 10 minutes the session only commited once despite the fact that there were over 30 DML statements in the trace file.

This may be the cause of my enqueue conflict, but before I point the finger at the application (Peoplesoft HR) I want to make sure that I have my facts right.

Are all commits shown in the trace file (I.E. explicit and implicit commits). It seems quite unusual that this session is committing so infrequently.

The Peoplesoft makes use of a TP monitor as a middle tier which should act as the point of transaction control. Are there different monitoring requirements for tracking commits/transactions in these kinds of environments.

Thanks again

Matt Received on Wed Aug 20 2003 - 03:14:20 CDT