Skip to main content

Posts

Showing posts from January, 2012

Difference between Oracle SE and SE1

Oracle RAC & Automatic Workload Management can be built on Oracle Standard Edition (SE). This is not possible on SE1. Oracle SE can be deployed on the top of 4 Sockets where as Oracle SE1 can be deployed on the top of 2 Sockets only. Note : Oracle RAC is not included in the Standard Edition of releases prior to Oracle Database 10g, nor is it an available option with those earlier releases.

Oracle Golden Gate - benefits

1. Database integration between Oracle / Non Oracle database environment. Work with Heterogeneous database environment irrespective of database vendor. 2. Easy data migration between Production database environment to non-production database environment. (Important value addition to Quality assurance dept) 3. Load balancing between different database environment. 4. High data availability/ reduce downtime. 5. Zero downtime migration & upgrades 6. Disaster recovery / data protection 7. Data distribution 8. Query Offloading 9. Operational reporting