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).
Received on Thu Nov 15 2001 - 13:23:15 CST