Re: Query capture

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 8 Apr 2005 10:21:07 +0100
Message-ID: <7765c897050408022145756eca@mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 08 2005 - 05:24:59 CDT