Re: OCLOSE OLOGOFF Hang Problem

More meaningful debugging info should come from select * from v$session_wait where sid = <yoursid>

Yong Huang

jmayers_at_transcendit.net (Jay Mayers) wrote in message news:<69868325.0205031548.6268ccf2_at_posting.google.com>...
> Did you know you can run your Listener in debug mode?
>
> See the lsnrctl command for more info. Also, there are multiple debug options
> for the listner.ora and sqlne.ora files, so check the docs. The only hanging
> I've notice in performance testings was the old FIN_WAIT2, but that total
> hangs the server of up to 9 minutes.
>
> Good Luck
>
>
>
>
>
> ndacgd_at_labor.state.ny.us (Chris D.) wrote in message news:<3df264fb.0205031024.904a3a_at_posting.google.com>...
> > We have an n-tier web application using IIS5.0 (Win2k), COM+ (Win2k),
> > and Oracle 8i (NT4). We've been running some performance tests (one
> > concurrent user hitting the same 7 pages, for 15 minutes). About 2/3
> > of the time, the performance is perfectly acceptable (< 5 seconds per
> > page) The other 1/3 of the time, the pages will hang for upwards of
> > 30-75 seconds. We ran a sniffer and found the following anomaly...
> >
> > Summary Delta Time
> >
> > TCP ACK (small)
> > SQL: OCLOSE - Close cursor (small)
> > TCP ACK (small)
> > Expert: Window Frozen 43.166.457
Received on Sun May 05 2002 - 08:21:43 CDT