Re: Query capture
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: rafiq9857@xxxxxxxxx
- Date: Fri, 8 Apr 2005 10:21:07 +0100
And be aware that sometimes the elapsed time can be wrong. On our main
system the top ranked statement comes out like this (I've added the execs
and elapsed time columns to the query to show where the issue lies (and
taken out the sqltext for formatting in email)).
PLACE TIMEINSECONDS CUR_ID ADDRESS EXECS ELA
--------- ------------- ---------- -------- ---------- ----------
1 72587254.1 1480155015 52765E70 254132 1.8447E+19
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
