Re: Oracle Standard Edition & RAC

On 1/3/07, Job Miller <jobmiller_at_yahoo.com> 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

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