Re: Lot of Latch Free and Enqueue Hash Chain Wait Events

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Tue, 3 Oct 2017 12:56:04 -0600
Message-ID: <b4062a37-3df7-9816-aabe-4691eb662c50_at_gmail.com>



Well documented. Please refer to the brief at https://www.oracle.com/database/standard-edition-two/index.html for more information.

/Hans

On 2017-10-03 12:48 PM, Mladen Gogala wrote:
>
> Wow! I didn't know that, because I have no experience with SE2. I
> don't like the ethics of such behaviour. That looks to me like a
> sales pitch taken too far.
>
> Regards
>
>
> On 10/03/2017 02:13 PM, Stefan Knecht wrote:
>> Yes, exactly as Niall said.
>>
>> The CPU limit is hard-coded into the software and they implemented it
>> through the resource manager. Whenever you're actively using more
>> than 16 threads, resource manager will prevent your from getting any
>> more CPU until a thread has been freed.
>>
>> I was bitten by this too when testing (deliberately producing) latch
>> contention behavior. You can't really put too much concurrent stress
>> on an SE2 instance, you'll simply be throttled.
>>
>> Stefan
>>
>>
>>
>>
>>
>> On Wed, Oct 4, 2017 at 12:07 AM, Niall Litchfield
>> <niall.litchfield_at_gmail.com <mailto:niall.litchfield_at_gmail.com>> wrote:
>>
>> SE2 is core limited by if memory serves CPU_COUNT.
>>
>> On 3 Oct 2017 17:09, "Mladen Gogala" <gogala.mladen_at_gmail.com
>> <mailto:gogala.mladen_at_gmail.com>> wrote:
>>
>> Hi Stefan, can you expand a bit on this?
>>
>> Regards
>>
>>
>> On 10/03/2017 11:44 AM, Stefan Knecht wrote:
>>
>> Is this Standard Edition 2 ? You may be throttled by the
>> database on purpose.
>>
>>
>> --
>> Mladen Gogala
>> Oracle DBA
>> Tel: (347) 321-1217 <tel:%28347%29%20321-1217>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>> <http://www.freelists.org/webpage/oracle-l>
>>
>>
>>
>>
>>
>> --
>> //
>> zztat - The Next-Gen Oracle Performance Monitoring and Reaction
>> Framework!
>> Visit us at zztat.net <http://zztat.net> | Support our Indiegogo
>> campaign at igg.me/at/zztat <http://igg.me/at/zztat> | _at_zztat_oracle
>
> --
> Mladen Gogala
> Oracle DBA
> Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 03 2017 - 20:56:04 CEST

Original text of this message