Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Interesting SQL that displays time taken to do row count?

Re: Interesting SQL that displays time taken to do row count?

From: <sybrandb_at_yahoo.com>
Date: 30 Sep 2005 01:07:54 -0700
Message-ID: <1128067674.323600.176970@g14g2000cwa.googlegroups.com>


Basically you can't. You are on the wrong track. Also you seem to be tracking information that is already being maintained in v$sql. But if you insist: you really need to
get_time
run query
get_time
and/or generate level 12 trace files
or better still, buy something like Quest Central and don't waste your time on reinventing the wheel.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Fri Sep 30 2005 - 03:07:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US