Re: Query capture

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@xxxxxxxxxxxxx>
>>
>> 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

Other related posts: