Re: How to trace SQL calls?

From: Roger Snowden <snowden_at_haven.ios.com>
Date: 1995/10/19
Message-ID: <4666cv$oti_at_news.ios.com>#1/1

Andy Hardy (aph_at_ahardy.demon.co.uk) wrote:
: Hi,
: I have some long enquiries running and I'd like to see what they are up
: to!
: How do I trace these SQL calls?

You need to use the sql trace facility, described in appendix B of the Application Developers Guide. It also explains the tkprof utility for analyzing the trace files created by Oracle. You have to plug some parameters in the instance .ora file, which means bouncing the database.

You can trace either a session or the entire instance. Check it out.

Roger Snowden
snowden_at_haven.ios.com
snowdenr_at_boystown.org Received on Thu Oct 19 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Donna Kray: "Re: RE: Oracle as a back-end for MS Access?"
Previous message: Donna Bigler: "Re: How to trace SQL calls?"
In reply to: Andy Hardy: "How to trace SQL calls?"
In reply to Andy Hardy: "How to trace SQL calls?"
Next in thread: Donna Kray: "Re: RE: Oracle as a back-end for MS Access?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message