Wednesday, July 9, 2008

Benefits of Oracle Database Enterprise Edition for Grid Control

Zaffer Khan (DBA, ISCO, Kuwait) wrote:
"This blog is promising in elaboration of EM for all the DBAs around the world. Thanks Porus for such an effort."

Zaffer, thanks for the thanks.

"1 query!!! We are to migrate to 10gr2 from 9i Standard Edition License. Can I use Grid Control Feature under Oracle DB Standard Edition License?"

Regarding your query, the Oracle Price List supplement states that Enterprise Manager is included in Oracle Standard Edition, but remember Enterprise Manager can mean Database Control (for managing one database) as well as Grid Control (for multiple databases).

I feel this refers to Database control. Why? Because Grid Control has built-in partitions when it is installed, and you can't use partitioning without the Enterprise Edition (EE), so I feel Grid Control requires the Enterprise Edition and not the Standard Edition.

Also, even if you can use Grid Control with Enterprise Edition, remember to pay a licence to Oracle if you use any of the Management Packs in production/test, such as the Diagnostic, Tuning packs etc.

In all I would recommend to speak with your Oracle representative for your company on licencing, since he/she would give you the 100% correct picture, we can only guess. Please do this before using Grid Control in production/test.

There are various other benefits of moving to EE. You should convince your management of upgrading your licence to EE. I have listed a few below.

EE Includes:

<> Normal Dataguard
= Standby database for purpose of:
+ Disaster Recovery
+ High Availability
= Can be opened for reporting purposes for some window of time.
= Requires EE licence on standby server.

<> Advanced Backup and Recovery via these RMAN features:
= Incremental Backups – very important to avoid full backups each day.
= Block Level Media Recovery.
= Trial Recovery.

<> Parallel Query
= Ability to break large queries into chunks handled by multiple processes.
= Very important for large tables (more than 1GB in size).

<> Automatic Storage Managmeent (ASM)
= Manages storage as file system and volume manager.
= No need to buy 3rd party file system and volume management software.
= Automatic I/O balancing and hot spot fixing, no other volume mgr can do so automatically

<> Streams
= Oracle’s new method of replication between 2 databases.
= Can be 2-way replication (multimaster).
= Multi-master must be programmed to resolve conflicts, not out-of-box.

No comments:


Opinions expressed in this blog are entirely the opinions of the writers of this blog, and do not reflect the position of Oracle corporation. No responsiblity will be taken for any resulting effects if any of the instructions or notes in the blog are followed. It is at the reader's own risk and liability.

Blog Archive