Re: code to load tracefile into CLOB?
Date: Wed, 17 Aug 2011 10:53:06 -0500
Message-ID: <CA+fnDAZ1J1V3mjSR9QG6R-fj0kNR+UraD5Yz9yjqXbF4UvUXOA_at_mail.gmail.com>
%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_at_method-r.com>wrote:
> On Wed, Aug 17, 2011 at 9:36 AM, Jeremy Schneider <
> jeremy.schneider_at_ardentperf.com> 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.freelists.org/webpage/oracle-lReceived on Wed Aug 17 2011 - 10:53:06 CDT