The client can be configured for logging and tracing.
Log information is typically stored in the sqlnet.log file located in $ORACLE_HOME/network/log on UNIX and ORACLE_HOME \network\log on Windows platforms.
Trace information is stored by default in sqlnet.trc for the client and svr_pid..trc for the server, located in $ORACLE_HOME/network/trace on UNIX and ORACLE_HOME \network\trace on Windows platforms
To enable logging or tracing:
In the navigator pane, expand Oracle Net Configuration > Local > Profile.
From the list in the right pane, select General.
Specify the logging or tracing settings
Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.