Re: v$sqlarea in Oracle 9i

From: <sybrandb_at_yahoo.com>
Date: 3 Mar 2004 06:38:25 -0800
Message-ID: <a1d154f4.0403030638.47f141f7@posting.google.com>

"Buky" <buky_zg_at_hotmail.com> wrote in message news:<c246s4$g2i$1_at_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 Received on Wed Mar 03 2004 - 08:38:25 CST