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

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

Comments

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

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 :)