Re: Monitoring the contents of SQL statements

From: <buckeye714_at_my-deja.com>
Date: 2000/05/15
Message-ID: <8fp5t1$dqi$1@nnrp1.deja.com>#1/1

Take a look at TOAD from Quest software. You can download a free trial copy @ www.quest.com. Several of the developers here use it and, as a DBA, I am working on getting it. It allows you to look at all of the SQL statements in the shared pool and shows you the explaoin plan for the statements you choose. I have used this several times in a pinch.

HTH,
Patrick

In article <8fp2t0$a60$1_at_nnrp1.deja.com>, Tom Lewis <telewis_at_my-deja.com> wrote:
> I'm trying to monitor the contents of SQL statements issued by an
> application (mainly selects and inserts). I've tryed to monitor
> V$SQLAREA but its rather messy. Any better ways to do this?
>
> --
> Tom Lewis
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon May 15 2000 - 00:00:00 CDT