v$sqlarea in Oracle 9i

[Buky]

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

[sybrandb@yahoo.com]

Re: v$sqlarea in Oracle 9i

"Buky" <buky_zg@hotmai l.comwrote in message news:<c246s4$g2 i$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