New Dynamic SQL*Net option for Server tracing!
An exciting new trace function has just been provided to us by the Oracle*Net BDE/DEV team!
Please see Note:1550897.1 "Dynamic Server Tracing" for information on this.
This new feature allows us to enable SQL*Net SERVER tracing but to target specific processes (dynamic) as opposed to the original "static" tracing which gathered tracing of ALL processes created on the DB server, and thus causing some concerns and problems.
This has been included with 11.2.0.4 and 12c, but for prior Oracle versions, (that is, 11.1.07, 11.2.0.2 & 11.2.0.3), the feature can be enabled with a simple patch available on My Oracle Support: patch 16694777.
Hope it helps