Re: LogMiner-like utility for trace files?

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Fri, 26 Feb 2016 16:27:19 +0000
Message-ID: <56D07CE7.8040102_at_dunbar-it.co.uk>

This has been done. Free code on GitHub to mine a 10046 trace file and extract the SQL statements and binds, then to list the SQL with the bind variables replaced by their actual values at EXEC time.

Details over here:
http://qdosmsq.dunbar-it.co.uk/blog/2016/02/traceminer-an-oracle-utility-to-mine-10046-trace-files/

Source code over here: https://github.com/NormanDunbar/TraceMiner

And while I've thrown a lot of old and new traces at it without it breaking, I'll be happy to resolve any problems you detect.

Cheers,
Norm.

--

Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG

Company Number: 05132767
--

http://www.freelists.org/webpage/oracle-l Received on Fri Feb 26 2016 - 17:27:19 CET