yup. the short answer this was to fill a product offering gap in the low to mid
range without allowing hipsters to get unlimited cpu power as if it were a full
enterprise engine by adding cpu boards to the frame. Nothing unethical to see
here, on this particular issue.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Hans Forbrich
Sent: Tuesday, October 03, 2017 2:56 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Lot of Latch Free and Enqueue Hash Chain Wait Events
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@xxxxxxxxx>
wrote:
SE2 is core limited by if memory serves CPU_COUNT.
On 3 Oct 2017 17:09, "Mladen Gogala" <gogala.mladen@xxxxxxxxx> 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>
--
//www.freelists.org/webpage/oracle-l
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat |
@zztat_oracle
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217