• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1923
  • Last Modified:

turning off SQLNET trace at the server and client side

Can someone provide me with instructions on how to turn of SQLNET tracing on the server and on the client.

3 Solutions
Daniel StanleyDatabase engineerCommented:
if client session is tracing: do this from individual session:

SQL> alter session set sql_trace=false;

or as sys user to stop session from tracing:

sql> exec sys.dbms_support.stop_trace_in_session(SID, serial#);

for server

if instance was started using spfile then:
sql> alter system set sql_trace=false scope=spfile;
sql> shutdown immediate
sql> startup open

if instance was started using pfile then:
alter sql_trace parameter in init.ora file to 'sql_trace=false'
sql> shutdown immediate
sql> startup open

good luck,
Peter KwanCommented:
client side:

set in the sqlnet.ora:
trace_level_client = OFF
just remove the line

server side:
remove the line in sqlnet.ora:
Mark GeerlingsDatabase AdministratorCommented:
If it really is SQL*Net tracing, then pkwan is correct.  This is controlled by the sqlnet.ora files on the client and server.  So, you need to either remove the "trace level..." line, or set the value to: OFF in the sqlnet.ora files, then stop and restart the listener and the client connections.

Or if it is really SQL tracing, then drs66's suggestions should do the job for you.
Forced accept.

EE Admin

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now