How to close oracle trace log

Close method: 1. Open the "sqlnet.ora" file and comment out all parameters such as "SQLNET.AUTHENTICATION_SERVICES" and "TRACE_UNIQUE_CLIENT" in the file; 2. Delete the "sqlnet.ora" file directly That’s it.

The operating environment of this tutorial: Windows 7 system, Oracle 11g version, Dell G3 computer.

Oracle usually has many log files. When encountering abnormal situations, a large number of logs will be generated, causing disk space to be tight.

Because the TRACE log is turned on, the disk space where the trace file is located is insufficient.

So how to turn off the trace log?

Method 1,

$ORACLE_HOME/network/admin/sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES = (NTS)

#TRACE_UNIQUE_CLIENT = ON
#TRACE_LEVEL_CLIENT = 16
#TRACE_DIRECTORY_CLIENT = '/opt/oracle/app/oracle/product/client32/client_32/network/trace'
#TRACE_FILE_CLIENT = SQLNetTrace
#TRACE_TIMESTAMP_CLIENT = ON

#TRACE_FILE_CLIENT = trace090212

Comment all the above parameters

Method 2,

Delete the file sqlnet.ora

Extended knowledge:

Precautions when TRACE

1. Ensure that the configuration file for the required trace assembly exists

Default In this case, Oracle will search for network configuration files from the following locations

  a.TNS_ADMIN environment variable (incl. Windows Registry Key) 
  b./etc or /var/opt/oracle (Unix) 
  c.$ORACLE_HOME/network/admin (Unix) 
  d.%ORACLE_HOME%/Network/Admin or %ORACLE_HOME%/Net80/Admin (Windows) 
  
  Note: User-specific Oracle Net parameters may also reside in $HOME/sqlnet.ora file.
  An Oracle Net server installation is also a client itself.

2. Make sure that the disk where the trace file is located has enough space

3. Oracle should be disabled immediately after the Oracle net fault is resolved. net trace feature

4. Large trace log files make the process overhead too high, so if there are no exceptions, turn off the trace feature, truncate the log file, etc. to improve the overall performance of Oracle net

5 . Make sure that the connected user has write permission to the path where the tracking log file is located.

6. For server-side trace, after setting it to OFF, the server-side trace cannot be stopped immediately, and the monitoring needs to be restarted.

7. Oracle Net itself also generates related logs, such as monitoring logs, sqlnet logs, etc. Oracle Net trace provides more detailed fault diagnosis information on this basis.

Recommended tutorial: " Oracle Tutorial》

The above is the detailed content of How to close oracle trace log. For more information, please follow other related articles on the PHP Chinese website!