RE: RESOURCE INTENSIVE QUERIES

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Sat, 30 Oct 2004 16:58:49 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF275A9B7C@AABO-EXCHANGE02.bos.il.pqe>

My favorite tool is SQL*Plus. V$SQL has buffer_gets, executions, = disk_reads, parse_calls, all of which may be significant in evaluating = resource intensive queries.

However, as has been stated here many times before, a much more = effective process is to look at a particular application or business = process that's performing poorly. Trace it, look at where the time is = being spent. Resource intensive queries, along with any other problems = that process encounters, will come out in the analysis.

Hope that helps,

-Mark

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Seema Singh
> Sent: Friday, October 29, 2004 4:28 PM
> To: oracle-l_at_freelists.org
> Subject: RESOURCE INTENSIVE QUERIES

>=20
>=20

> Does any one know any free tools thru which we can capture=20
> more resource=20
> intensive queries?
> thanks

>=20


> _________________________________________________________________

> Don't just search. Find. Check out the new MSN Search!=20
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/

>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

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

Received on Sat Oct 30 2004 - 15:54:24 CDT