Last updated on JULY 06, 2016
Applies to:Oracle Net Services - Version 188.8.131.52 to 184.108.40.206 [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 220.127.116.11, 18.104.22.168 (onward)
A One-off patch is available for 22.214.171.124, 126.96.36.199 and 188.8.131.52, use <patch 16694777>
Cumulative Patch inclusion (DBPSU) with 184.108.40.206.11 and 220.127.116.11.7
Exadata bundle patch inclusion (BP12)
Online / Hot Patch capable
All of the one-off patches that enable dynamic server tracing in versions 18.104.22.168, 22.214.171.124, and 126.96.36.199 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
Million Knowledge Articles and hundreds of Community platforms