Re: Query capture

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: Seema Singh <oracledbam@xxxxxxxxxxx>
  • Date: Thu, 07 Apr 2005 10:48:01 -0600

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. 


Wolfgang Breitling
Centrex Consulting Corporation

Other related posts: