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