Database Utilities (MOSC)

MOSC Banner

An oracle trace file generated by event 10046 level 12, linking binds and sql

I have a trace file that I am writting a python script to parse it down to the sql statements and a list of any binds showing directly after the formatted dump of the sql. The problem is that I can't find anyway to say that a specific list of binds go with a specific sql statement. I thought that maybe I count use the "PARSING IN CURSOR #??" number to tie to the "BINDS #??" number but the trace reuses the "PARSING IN CURSOR #??" number for multiple sql statements so I can't figure out how to link to

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center