Re: v$sqlarea in Oracle 9i
From: <sybrandb_at_yahoo.com>
Date: 3 Mar 2004 06:38:25 -0800
Message-ID: <a1d154f4.0403030638.47f141f7_at_posting.google.com>
Date: 3 Mar 2004 06:38:25 -0800
Message-ID: <a1d154f4.0403030638.47f141f7_at_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 - 15:38:25 CET