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

From: <J.Velikanovs_at_alise.lv>
Date: Mon, 21 Jun 2004 11:04:35 +0300
Message-ID: <OF1A388E23.DA6776B2-ONC2256EBA.002AAF4F-C2256EBA.002D04F3@alise.lv>

>> 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:

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_at_freelists.org 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
-----------------------------------------------------------------

Received on Mon Jun 21 2004 - 03:08:33 CDT

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