Things that had me surprised with 10G Standard Edition
Well we know that Standard edition is a marketing joke - but it is something we cannot avoid considering when we can save about 30K per cpu.
The following features not being supported by standard edition had me surprised(there are a lot more but this caught my attention)
1)Reorgs: Online index build, online table reorg/redef, online index coalesce. Global index maintenance during DDL
(some of the above we may overcome with third party LiveReorg Products)
2)Recovery: block level media recovery, Tablespace point in time recovery.
3)With 10g Std edition incremental backup and recovery is supported but not with 9i Std Edition - think of it which means you always have to do a full bkups.4)Indexes : Bitmap indexes are not supported while Function based indexes are supported in 10G Std edition.
The following features not being supported by standard edition had me surprised(there are a lot more but this caught my attention)
1)Reorgs: Online index build, online table reorg/redef, online index coalesce. Global index maintenance during DDL
(some of the above we may overcome with third party LiveReorg Products)
2)Recovery: block level media recovery, Tablespace point in time recovery.
3)With 10g Std edition incremental backup and recovery is supported but not with 9i Std Edition - think of it which means you always have to do a full bkups.4)Indexes : Bitmap indexes are not supported while Function based indexes are supported in 10G Std edition.
posted by Vidya Balasubramanian at
10:27 AM
5 Comments:
Don't know what you've been reading but function-based indexes are supported in Standard Edition (and XE for that matter).
The definitive comparison is :
http://www.oracle.com/database/product_editions.html
By
SydOracle, at 11:44 AM
That's correct, I overlooked that Function based and descending indexes are supported - its Bitmap that is not supported. Thanks for pointing it out.
There is still one more issue I am working on - is Cross Platform migration supported or not in Standard edition. Some notes say cross platform export is not supported by import is supported - we are still unclear if Cross platform migration is supported or not with Std Edition.
By
Vidya Balasubramanian, at 1:22 PM
http://www.oracle.com/technology/products/database/oracle10g/pdf/twp_general_10gdb_product_family.pdf
is the Product Matrix used
By
Vidya Balasubramanian, at 1:23 PM
All of those limitations are pretty understandable. Many organizations can live fine without it, especially, features that minimizing downtime - wanna have more than you should probably have enough money for EE or you might want to re-think your business model. ;-)
I think what's really missing in SE (and actually in default EE) are features of Diagnostic Pack. Those are a must for anyone using Oracle.
By
Alex Gorbachev, at 8:46 PM
Did you know that you have the RAC license for a two nodes cluster with Standard Edition? (Limitation: you must use ASM).
You do not have large scale up and speed up oppotunity with this , but you do have HA to a certain level.
Ain't this cool and efordable for small and middle size businesses?
=;-)
By
Anonymous, at 10:44 PM
Post a Comment
<< Home