By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,504 Members | 1,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,504 IT Pros & Developers. It's quick & easy.

v$sqlarea in Oracle 9i

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Buky" <bu*****@hotmail.com> wrote in message news:<c2**********@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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.