RE: Make trace files with large sql statements available to developers

Ethan, Lex,

Maybe I am overreacting, but I believe I made a reference to AskTom in my original post. The approach by Tom Kyte is partly working, as is the approach by Jared Still (links in original post). The problem is that there are lines in the trace files that exceed the length of a varchar2. And both approaches do not allow for that. I am looking for a solution for the length of some lines in the trace files, not for a general solution of transferring trace files. I have found and tried several. At least that is what I tried to ask. Probably my way of asking made the question unclear. Can you help me finding other ways of working around the length problem, short of cutting up the lines and reassembling them after transfer?

Kind Regards,
Eric.

> -----Oorspronkelijk bericht-----
> Van: Lex de Haan [mailto:lex.de.haan_at_naturaljoin.nl]
> Verzonden: vrijdag 11 november 2005 0:00
> Aan: Ethan.Post_at_ps.net; Eric.Buddelmeijer_at_elegant.nl;
> davidsharples_at_gmail.com
> CC: 'Oracle Mailing List'
> Onderwerp: RE: Make trace files with large sql statements
> available to developers
>
> search AskTom and you'll find what you are looking for ...
>
> kind regards,
>
> Lex.
>
> ---------------------------------------------------------------------
> Jonathan Lewis Seminar http://www.naturaljoin.nl/events/seminars.html
> ---------------------------------------------------------------------
>
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Post, Ethan
>
> I am pretty sure I saw an article the other day showing how
> to put the contents of a trace file into a table in the
> database and query it, can't recall where.
>

--
http://www.freelists.org/webpage/oracle-l