Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: trace files

Re: trace files

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Thu, 4 Mar 2004 23:54:12 GMT
Message-ID: <4047C1A4.94DC7917@remove_spam.peasland.com>


IgorB wrote:
>
> Hi Everybody!
>
> There is a session on Oracle database 9.0.1.1, which is performing a
> long running select query.
> Parameter SQL_TRACE for this session is set FALSE.
> Nevertheless, in the trace directory on server this session
> is constantly writes in trace file as the query runs.
> Attempts to delete this file do not lead to success - the
> malicious file appears again and grows.
>
> Could anybody explain me what is happening and why?
>
> Igor, young DBA.

Try using DBMS_SESSION to explicitly turn tracing off for that session. Someone may have started it on you. Received on Thu Mar 04 2004 - 17:54:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US