Re: CPU usage for an indivdual user

From: Cary Millsap <cary.millsap_at_method-r.com>
Date: Tue, 27 Mar 2018 15:40:57 -0500
Message-ID: <CAJOkrQatFi31AC1AmJZmEGPqtprbTNdmYfhS1ichp56oBsqGbg_at_mail.gmail.com>



If you want details, use sql_trace (event 10046).

That'll tell you not only CPU consumed by a user, it'll tell you how much CPU (±0.01s) is consumed for each and every dbcall that user makes.

Cary Millsap
Method R Corporation
Author of *Optimizing Oracle Performance <http://amzn.to/OM0q75>* and *The Method R Guide to Mastering Oracle Trace Data, 2nd edition <http://amzn.to/1U7q8X1>*

On Wed, Mar 21, 2018 at 4:13 PM, Sayan Malakshinov <xt.and.r_at_gmail.com> wrote:

> I'm pretty sure that is double-counting error with recursive calls
>
> On Thu, Mar 22, 2018 at 12:05 AM, Andrew Kerber <andrew.kerber_at_gmail.com>
> wrote:
>
>> Thanks!
>> There is something wrong with the db_cpu_percent calculation, its giving
>> numbers over 100 in some cases, but I should be able to track that down.
>>
>> ...
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>>
>
>
>
> --
> Best regards,
> Sayan Malakshinov
> Oracle performance tuning engineer
> Oracle ACE Associate
> http://orasql.org
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 27 2018 - 22:40:57 CEST

Original text of this message