Supporting a large database over 300gb with performance challenges on 10g standard edition oracle is a rough endeavor. Here is a list of my favorite missing oracle features from enterprise edition.
Parallel ( Backups using multiple channels, building indexes, running long running queries )
RMAN Block Change Tracking File for fast incremental backups.
Table Partitioning, I have a work around but it involves doing poor man partitioning like we did in Oracle 7.
Bitmap Indexes, this is truly a missed feature that is hard to work around.
Dataguard, I have a work around but it involes manually copying archive logs to standby and updating standby controlfile everytime I add a datafile on primary.
Here is oracle's official list for 11g.
http://download.oracle.com/docs/cd/B28359_01/license.111/b28287/editions.htm#CJACGHEB
No comments:
Post a Comment