Re: Oracle session hangs

Thanks to all those that replied.

Today we tried the hotsos.com 10046 event tracing. But it seems that once the session hangs, it hangs for good, and does not even show anything in the 10046 trace file.

Does that sound familiar to anybody ?

To answer some of the questions : we have an application server that uses a connection pool. Not all the connections are used all the time. Some may even spend most of their time waiting. Only a few connections in each connection pool a very active. When this problem occurs, only one of the connections goes in limbo. All of the others work fine. Also, the code that generates the hang works most of the time. It is not exactly easy to reproduce...

danielroy10junk_at_hotmail.com (Daniel Roy) wrote in message news:<3722db.0401040815.29df7ea_at_posting.google.com>...
> Go take a look at www.hotsos.com, and read about turning on event
> 10046 for these sessions, and how to interpret the trace files
> created. You'll need a username/password, but it's free. Look first
> for the paper "How to Activate Extended SQL Trace", by Cary Millsap.
> If you're stuck, email me a trace file and I'll give you my 2 cents
> (Canadian) of advice.
>
> Daniel (remove JUNK from my username to reach me).
Received on Wed Jan 07 2004 - 15:47:01 CST