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

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Thu, 10 Nov 2005 16:02:30 -0600
Message-ID: <1F989681BA05FA4CAD9FA849ED85205701434C39@pscdalpexch01.perotsystems.net>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eric Buddelmeijer
Sent: Thursday, November 10, 2005 3:37 PM To: davidsharples_at_gmail.com
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] Namens David Sharples

	Verzonden: donderdag 10 november 2005 22:00
	Aan: Eric.Buddelmeijer_at_elegant.nl
	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_at_elegant.nl> 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                 

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

Received on Thu Nov 10 2005 - 16:04:59 CST