From: sybrandb@yahoo.com
Newsgroups: comp.databases.oracle
Subject: Re: v$sqlarea in Oracle 9i
Date: 3 Mar 2004 06:38:25 -0800
Organization: http://groups.google.com
Lines: 17
Message-ID: <a1d154f4.0403030638.47f141f7@posting.google.com>
References: <c246s4$g2i$1@sunce.iskon.hr>
NNTP-Posting-Host: 145.13.42.4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1078324705 19598 127.0.0.1 (3 Mar 2004 14:38:25 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 3 Mar 2004 14:38:25 +0000 (UTC)


"Buky" <buky_zg@hotmail.com> wrote in message news:<c246s4$g2i$1@sunce.iskon.hr>...
> In a v$sqlarea in Oracle 9i version, there's a columns cpu_time and
> elapsed_time.
> Is there a relating columns to those in Oracle 8.1.7.?
> Or, alternatively, is there a unique way (for vesions 8.1.7 and 9) to
> measure cpu time or a real time of sql commands?
> 
> tnx,
> 
> Dario


This is new functionality in 9i.
Consequently there exists no equivalent for 8i.

Sybrand Bakker
Senior Oracle DBA