Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: trace files
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