Re: code to load tracefile into CLOB?
- From: Jeremy Schneider <jeremy.schneider@xxxxxxxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Fri, 19 Aug 2011 11:33:20 -0500
Here you go. I coded the whole thing up and published it... if anyone
can't use current plugins on the market but they need to give developers
access to 10046 trace data without server access, here's a simple block
of code that will do the trick.
http://www.ardentperf.com/2011/08/19/developer-access-to-10046-trace-files/
-Jeremy
On 8/18/2011 10:51 AM, Jeremy Schneider wrote:
> Here's what I was looking for. Dion Cho wrote the code and posted it
> to his blog two and a half years ago. I knew it wasn't that
> complicated... sheesh. His second example does it with 10 lines of code.
>
> http://dioncho.wordpress.com/2009/03/19/another-way-to-use-trace-file/
>
> Little different from my original idea (rather than a LOB or an
> external table, he prefers a pipelined functions with UTL_FILE) - but
> it accomplishes the task very elegantly. My developers can easily
> save query output to a file, which can subsequently be passed into the
> profiler of their choice. Or they can play with the data in Oracle,
> as Dion does. :)
>
> -Jeremy
--
http://www.ardentperf.com
+1 312-725-9249
Jeremy Schneider
Chicago
--
//www.freelists.org/webpage/oracle-l
Other related posts:
