Configuring Profile Logging and Tracing

Tracing allows you to diagnose and troubleshoot network problems. Tracing does this by keeping track of the steps performed by the client and the server during a network connection. This is different from logging in that logging only keeps track of whether entire operations fail or succeed, where tracing reports the success of the components of each operation. Trace information is typically stored in SQLNET.TRC for the client and SVR_PID.TRC for the server in $ORACLE_ HOME/network/trace on UNIX and ORACLE_HOME\network\trace on Windows platforms

Logging is a feature that allows you to track and save errors, service activity, and statistics as they occur on a client and/or server. This information is written to a log file. It is a much higher level version of tracing, one that does not record the small steps of each process, but the success or failure of the process as a whole. Log information is typically stored in SQLNET.LOG in $ORACLE_ HOME/network/log on UNIX and ORACLE_HOME\network\log on Windows platforms

To enable logging or tracing:

  1. Click the Profile icon.

  2. Choose General from the drop-down list box.

  3. Click the Logging or Tracing tab.

  4. Specify the settings.

  5. Choose Save Network Configuration from the File menu to save changes to SQLNET.ORA in $ORACLE_HOME/network/admin on UNIX or ORACLE_HOME\network\admin on Windows platforms, or choose Save As from the File menu to save under a different file name or path.