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