RE: Make trace files with large sql statements available to developers
- From: "Post, Ethan" <Ethan.Post@xxxxxx>
- To: <Eric.Buddelmeijer@xxxxxxxxxx>, <davidsharples@xxxxxxxxx>
- Date: Thu, 10 Nov 2005 16:02:30 -0600
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.
I have also allowed a web interface which allows developers ability to
see trace files and download them, this directory can be password
enabled and I use pretty simply cgi script for this. You can also set up
a job to come along and tkprof files for you.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Eric Buddelmeijer
Sent: Thursday, November 10, 2005 3:37 PM
To: davidsharples@xxxxxxxxx
Cc: 'Oracle Mailing List'
Subject: RE: Make trace files with large sql statements available to
developers
Because I want to be able to use it in a production environment as well.
Developers will be troubleshooting there as well.
________________________________
Van: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] Namens David Sharples
Verzonden: donderdag 10 november 2005 22:00
Aan: Eric.Buddelmeijer@xxxxxxxxxx
CC: Oracle Mailing List
Onderwerp: Re: Make trace files with large sql statements
available to developers
if its a development environment why not set _trace_file_public
= true ?
On 11/10/05, Eric Buddelmeijer <Eric.Buddelmeijer@xxxxxxxxxx>
wrote:
Hi All,
I am working on a sql script to make trace files (10046
traces) available to
developers through sqlplus (mixed sun/win environment,
oracle 9.2.0.5). I
Other related posts:
