Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Listener trace
Tracing the listener won't help you much as the listener is a *broker* only
(so it doesn't communicate with existing clients).
Generally speaking
in listener.ora
trace_level_listener = 16
to trace the listener
in sqlnet.ora on the server
trace_level_server = 16
to trace the server side
in sqlnet.ora on the client
trace_level_client = 16
(the two latter files should produce an exact mirror)
usually it's wise to add
trace_unique_client = true
and
trace_directory_client = <any directory>
in sqlnet.ora on the client.
Hth,
Sybrand Bakker, Oracle DBA
Sid_James <sid.james_at_virgin.net> schreef in berichtnieuws
3921AB82.302_at_virgin.net...
> Hi.
>
> We're running Oracle 7.3.4. Can anyone tell me how I can run a trace on
> the listener process? I need to find out why an SQL Net process takes so
> long.
>
> Thanks.
>
> Ed.
Received on Tue May 16 2000 - 00:00:00 CDT