RE: Tracing a session - weird problem

From: Kathy Duret <KathyD_at_belkin.com>
Date: Thu, 15 Nov 2001 11:45:03 -0800
Message-ID: <F001.003C68FA.20011115112522@fatcity.com>

I can't bounce the database right now.

Exactly what do you mean disconnect and connect? I did exit the session and sells directly into the database and tried to do the trace again and it did not create
a trace file.

Kathy

-----Original Message-----
Sent: Thursday, November 15, 2001 10:55 AM To: Multiple recipients of list ORACLE-L

Hi Kathy,

Did you delete the trace on OS level. I have seen cases where the connected processes will not generate traces after u delete the file. If this is not production then you could bounce db or beter disconn and conn again

Deepak

• Kathy Duret <KathyD_at_belkin.com> wrote:
  > 8.1.6 on HP-UNIX
  > sqlplus sys/xxxxx
  >
  > alter session set timed_statistics=true;
  >
  > exec
  > dbms_system.set_sql_trace_in_session(50,23265,true);
  > exec
  >
  dbms_system.set_sql_trace_in_session(50,23265,false);
  >
  > I ran these statements got a trace file but NO time
  > stamps. Since the process was
  > still running I tried to run it again, but this time
  > no trace file... I know I have the
  > correct location for the udump. The file system is
  > NOT full. What could be going on.
  > I have never seen this.
  >
  > Thanks
  >
  > Kathy
  >
  > Confidential
  > This e-mail and any files transmitted with it are
  > the property
  > of Belkin Components and/or its affiliates, are
  > confidential,
  > and are intended solely for the use of the
  > individual or
  > entity to whom this e-mail is addressed. If you are
  > not one
  > of the named recipients or otherwise have reason to
  > believe
  > that you have received this e-mail in error, please
  > notify the
  > sender and delete this message immediately from your
  > computer.
  > Any other use, retention, dissemination, forwarding,
  > printing
  > or copying of this e-mail is strictly prohibited.
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Kathy Duret
  > INET: KathyD_at_belkin.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Do You Yahoo!?
Find the one for you at Yahoo! Personals http://personals.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: deepakthapliyal_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Confidential
This e-mail and any files transmitted with it are the property
of Belkin Components and/or its affiliates, are confidential,
and are intended solely for the use of the individual or
entity to whom this e-mail is addressed.  If you are not one
of the named recipients or otherwise have reason to believe
that you have received this e-mail in error, please notify the
sender and delete this message immediately from your computer.
Any other use, retention, dissemination, forwarding, printing
or copying of this e-mail is strictly prohibited.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kathy Duret
  INET: KathyD_at_belkin.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Nov 15 2001 - 13:45:03 CST