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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Query capture

Re: Query capture

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 07 Apr 2005 10:48:01 -0600
Message-ID: <42556441.6030401@centrexcc.com>


I thought that's what I said. elapsed_time and cpu_time didn't exist in v$sql prior to Oracle9.

Seema Singh wrote:

> there is no column in v$sql table in Oracle8i.which table ?
> 

>> From: Wolfgang Breitling <breitliw_at_centrexcc.com>
>>
>> elapsed_time and cpu_time are always in microseconds since they didn't
>> exist in v$sql in the centiseconds era before Oracle9i.
-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 07 2005 - 12:51:59 CDT

Original text of this message

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