RE: The best CPU usage measurement in Oracle: BUFFER_GETS or CPU_TIME?

>> My point is: may be now the better measure is CPU_TIME? I show in 
previous
>> posting situation then CPU_TIME figure is 10 times accurate then 
BUFFER_GETS.
>> Can you show me contrariwise situation? 
>> 
>> [Cary Millsap] No, I think you're actually on the best path to the 
solution.
Lets me ask contrariwise question:
Are there situations when using statspack report (if using) or other 
instance wide performance tool the better way to see TOP SQL-s is sort by 
BUFFER_GETS not CPU_TIME?

Jurijs







Additional  info from previous postings:
========================================
1. Activity 
========================================
NAME VALUE
---------------------------------------------------------------- 
session logical reads 23002
CPU used by this session 137

========================================
2. Activity 
========================================
NAME VALUE
---------------------------------------------------------------- 
session logical reads 23006
CPU used by this session 1422

I.
session logical reads 
Action 1 = Action 2
II.
CPU used by this session
Action 1 * 10 = Action 2

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: