Re: SQL*NET Tracing

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Sun, 29 Feb 2004 02:31:30 -0500
Message-Id: <pan.2004.02.29.07.31.27.651941@adelphia.net>

On Fri, 27 Feb 2004 09:20:37 -0800, Jaffery wrote:

> Hi,
>
>
> With regards to an Oracle database, I like to ask how we do SQL* NET tracing.
> Where should I find the SQL*Net Tracing files?
>
> Thanks
>
> David

Basically, you find them where you put them. You can trace from two sides, client and the server. You can set the client trace by putting the following directives in your sqlnet.ora:

TRACE_LEVEL_CLIENT = ADMIN TRACE_DIRECTORY_CLIENT = /tmp

and, on the server side,
TRACE_LEVEL_LISTENER = ADMIN This trace will go $ORACLE_HOME/network/trace. Be sure that you understand networking and how oracle does it, before you start tracing. Listener trace will trace ANY CONNECTION and is not appropriate for busy databases. You shoud read the fine manuals despite my giving you the exact directives or you will not know what to look for.

-- 
Some people are only alive because it is illegal to shoot them.

Received on Sun Feb 29 2004 - 01:31:30 CST