trc2sql.pl - Extract SQL Statements From Oracle 10046 Trace File

Submitted by dave on Fri, 10/14/2011 - 17:00

Purpose:
This Perl script will extract the SQL Statements out of an Oracle 10046 Trace File.
Usage:

trc2sql.pl < input.trc > output.sql

Source Code
GitHub Link : trc2sql.pl

Tags:

Comments

Permalink Submitted by Anonymous (not verified) on Sat, 10/15/2011 - 03:37.

Hi,
You can use record=1.txt as tkprof option.
Regards.
GregG

Permalink Submitted by dave on Sat, 10/29/2011 - 23:57.

Thanks for the heads up, haven't seen that tkprof option before.

I'll tuck this code away for the basis of my super duper trace file analyzer that I never seem to get around to writing :)