Re: SQL Tuning

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Tue, 3 May 2016 10:11:16 +1000
Message-ID: <CAFeFPA8=5qBHpLGeG93xqgJOSX13MePCxG+Yzsb+92A8BLDz6g_at_mail.gmail.com>

11.2.0.3.5

Jack van Zanen

---

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation

On Tue, May 3, 2016 at 10:00 AM, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> On 05/02/2016 06:56 PM, Jack van Zanen wrote:
>
>> read by other session 8530 0.47
>> 11.65
>> latch: cache buffers chains 99 0.00 0.00
>>
> Ah, here's your CPU consumption! What is the exact version? Oracle 11G has
> had it's latches, needles and pins mechanism completely rewritten and there
> are some bugs which were rectified in later versions. Characteristics for
> this is CPU being used entirely in the user mode, not kernel mode, as would
> be the case with paging.
>
> Regards
>
> --
> Mladen Gogala
> Oracle DBA
> Tel: (347) 321-1217
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 03 2016 - 02:11:16 CEST