Dynamic Oracle Net Server Tracing

(Doc ID 1550897.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle Net Services - Version to [Release 11.1 to 12.1]
Information in this document applies to any platform.


Oracle Net tracing is controlled by sqlnet.ora parameters which are static for the lifetime of RDBMS server processes. Since there is a single sqlnet.ora file for an instance, trace settings apply to all server processes. This can pose difficulties in live production environments. Dynamic server tracing allows for tracing at a per-process level and can be enabled ad hoc on any running server process. This is useful for tracing individual server side processes of a specific client connection or for tracing background server processes.


Available in, (onward)
A One-off patch is available for, and,  use <patch 16694777>
Cumulative Patch inclusion (DBPSU) with and
Exadata bundle patch inclusion (BP12)

Online / Hot Patch capable

All of the one-off patches that enable dynamic server tracing in versions,, and are "hot patch" capable. Hot patching allows for the patching of the Oracle Home without stopping the database. For more information about Online Patching please see: RDBMS Online Patching Aka Hot Patching [ID 761111.1]


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms