Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: trace files
how do you know that sql_trace is not set?
-- Niall Litchfield Oracle DBA Audit Commission UK "IgorB" <ibvis_at_hotmail.com> wrote in message news:26f7a1be.0403040335.1e91a19c_at_posting.google.com...Received on Thu Mar 04 2004 - 06:29:45 CST
> 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.