RE: Sessions Hang When Not Being Traced/Unhang When Being Traced

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Fri, 15 Feb 2002 17:33:51 -0800
Message-ID: <F001.00411A84.20020215172325@fatcity.com>

Tom,

Have you checked the
V$SESSION_EVENT for those sessions to find out the waits?
Best Regards,K GopalakrishnanBangalore, INDIA   -----Original
  Message-----From: root_at_fatcity.com [mailto:root_at_fatcity.com]On   Behalf Of Tom PallSent: Friday, February 15, 2002 10:24   AMTo: Multiple recipients of list ORACLE-LSubject:   Sessions Hang When Not Being Traced/Unhang When Being   Traced
  Anybody seen this before?

  Running 8.1.5.0 on Solaris. We have a third party   product written in java which runs for a certain amount of time then   hangs. I don't see any locks or waits for the applications   sessions. This does not happen if I put sql_trace=true in the init file   and bounce the database. I can unhang and hang the application sessions   using ORADEBUG EVENT 10046 TRACE NAME CONTEXT FOREVER, LEVEL whatever/ORADEBUG   EVENT 10046 TRACE NAME CONTEXT OFF.

  I've searched Metalink's bug database and haven't found any   bugs that apply yet.

Received on Fri Feb 15 2002 - 19:33:51 CST