Re: Oracle Standard Edition & RAC

On 1/3/07, Job Miller <jobmiller@xxxxxxxxx> wrote:


The biggest downside to SE that I see is no Diagnostics Pack (AWR) data
available to you.

so now if you throw in RAC, you have any more of a need to
understand/diagnose the underlying wait data, but no convenient mechanism
like AWR to collect all of that for you.




Oh it's available to you. You can't legally use it since Oracle will refuse
your cash and won't license the product to you - got to be a first that -
but AWR and the diags pack are certainly in existence in SE. It isn't true
that it is unavailable though. Those of you who've noticed things like
queries on free space etc for 10g taking a while will find that they are
being executed for you in the background :(.

My default position is that for many OLTP apps people will find that SE does
them just fine - it's the 4 processor/core limit and on 64bit platforms the
ram limits that will mostly create a need to go to EE.

--
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: