Dynamic Oracle Net Server Tracing

(Doc ID 1550897.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

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

Goal

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.

Availability


Available in 11.2.0.4, 12.1.0.1 (onward)
A One-off patch is available for 11.2.0.3, 11.2.0.2 and 11.1.0.7,  use <patch 16694777>
Cumulative Patch inclusion (DBPSU) with 11.2.0.2.11 and 11.2.0.3.7
Exadata bundle patch inclusion (BP12)

Online / Hot Patch capable

All of the one-off patches that enable dynamic server tracing in versions 11.1.0.7, 11.2.0.2, and 11.2.0.3 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]

Solution

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