Database Networking (MOSC)

MOSC Banner

Dynamic Server Oracle Net Tracing

edited Oct 18, 2017 9:35AM in Database Networking (MOSC) 1 comment

It's possible to generate server side Oracle net traces for a single server process if you can identify that process.

You no longer have to turn on tracing for every single incoming connection!

Just follow the instructions in this document:

Dynamic Oracle Net Server Tracing (Doc ID 1550897.1)

Start here under the Solution header:

Tracing a dedicated server process associated with a connected client. (Start 1b)


1) Find the process ID (PID) of the server process that will be traced, for Windows locate the thread ID.


b) Identifying a connected client's associated server process.

You can also turn OFF server tracing using the same feature!  Let's say you

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center