Re: code to load tracefile into CLOB?
- From: Jeremy Schneider <jeremy.schneider@xxxxxxxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Thu, 18 Aug 2011 10:51:31 -0500
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
On Wed, Aug 17, 2011 at 10:53 AM, Jeremy Schneider <
jeremy.schneider@xxxxxxxxxxxxxx> wrote:
> %s/MR Trace/MR Profiler/g
> (sorry, mixed a few things up... momentarily forgot that MR Trace is
> separate product from Profiler)
>
> Thanks Ron - heard similar messages from others as well. Guess I can
> suggest adding some new development tools to their arsenal... which of
> course will open up lots of new options (of which MR Trace is one). Most
> developers here aren't allowed to install new software on their machines, so
> it would have to get approved and packaged for corp deployment... would
> still be a lot easier and less intrusive if I can come up with a simple
> block of code... but I guess it might not be that simple, so maybe we have
> to go this direction.
>
> -J
>
>
> On Wed, Aug 17, 2011 at 10:05 AM, Ron Crisco <ron.crisco@xxxxxxxxxxxx>wrote:
>
>> On Wed, Aug 17, 2011 at 9:36 AM, Jeremy Schneider <
>> jeremy.schneider@xxxxxxxxxxxxxx> wrote:
>>
>>> Thanks to everyone for the suggestions...
>>>
>>> 1. Next time I'll mention that I'm very familiar with and fond of MR's
>>> fantastic offerings. :) In fact this is exactly what made me ask the
>>> question in the first place... they've really been getting excited about MR
>>> Trace here. It's the whole reason I want developers to have their trace
>>> files - so they can run it through MR Trace. Unfortunately the development
>>> team in this shop uses PL/SQL Developer from Allround Automations (
>>> http://www.allroundautomations.com/plsqldev.html) and the MR Trace
>>> plugin is not available for this environment. Seems like a bit of a stretch
>>> for me to try to convince their entire development team to change to a new
>>> development environment... hence asking about a snippit of code to pull the
>>> tracefiles for them.
>>>
>>> [Any MR folks on the list... do you have a solution for this that you
>>> give to MR Trace customers? I did ask around at Hotsos and got no answer...
>>> but I probably should have shot an email over to you before I hit the list
>>> here!!]
>>>
>>>
>> Our reply is in two parts. First, we would love to work with PL/SQL
>> Developer and/or TOAD given the opportunity, but that hasn't worked out
>> yet.
>>
>> Second, there's no reason to change development's favorite IDE. Continue
>> to use whatever tool they like for development, and use SQL Developer (which
>> is free) for testing the code and using MR Trace.
>>
>> Ron Crisco
>> Method R
>>
>
>
>
> --
> http://www.ardentperf.com
> +1 312-725-9249
>
> Jeremy Schneider
> Chicago
>
--
http://www.ardentperf.com
+1 312-725-9249
Jeremy Schneider
Chicago
Other related posts:
