RE: RESOURCE INTENSIVE QUERIES
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracledbam@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 30 Oct 2004 16:58:49 -0400
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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Seema Singh
> Sent: Friday, October 29, 2004 4:28 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
>=20
--
//www.freelists.org/webpage/oracle-l
Other related posts:
