Re: Standard Edition Feature Availability

mccmx_at_hotmail.com wrote:
> Oracle 10.2.0.1 on W2K3
>
> I am choosing between Standard and Enterprise Edition for a new
> database. As part of the analysis I am compiling a list of desired
> features. Can anyone clarify which of the following are Enterprise
> Edition features. I've checked through Note:271886.1 "Differences
> Between Different Editions of Oracle Database 10G", but some of these
> features below are not obvious.
>
> So which of these are Enterprise Edition only features....

> Automated Workload Repository (AWR)
> Automatic Database Diagnostic Monitor (ADDM)

Grid Control packs

> Automatic Storage Manager (ASM)
> RMAN Incremental Merge
> Flash Recovery Area
> Flashback Database (and Flashback DB to 'Restore Point')
> Automatic Shared Memory Management (ASMM)
> Restore Optimizer Stats to Point in Time
> Optimizer Stats Gathering for stale objects (user_tab_modifications).

All

If deciding between Standard Edition and Enterprise Edition you should be looking a need for partitioning, DataGuard, and similar features.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)