Vidya Bala's Blog

Search My Blog

Add RSS Feed

Monday, December 04, 2006

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.

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 Blogger Gary Myers, 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 Blogger 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 Blogger 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 Blogger 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 Blogger lutz_hartmann, at 10:44 PM  

Post a Comment

<< Home