Oracle Server Editions and versions

Oracle Server Editions

1. Enterprise Edition (EE) - All features available from 32 & 64 bits
2. Standard Edition (SE) - Limited to 4 CPUs
3. Standard Edition One (SE1) - Limited to 2 CPUs
4. Express Edition - Limited to 1 CPU, 1GB of RAM, database size 11 GB

Oracle Server Versions

• Version 2 - first commercial RDBMS
• Version 3 - rewritten in the C programming language
• Version 4 - improved query performance
• Version 5 - added a networking stack for client-server computing
• Version 6 - OLTP improvements, oracle parallel server
• Version 7 - first “Modern” Oracle
  • New security Model - roles & privileges
  • PL/SQL and SQL improvements
  • Datatypes for videos and images
  • 64-bit architectures
• Version 8
  • Object relational Database
  • Java Support
  • Linux Support
• Version 8i - ‘Internet Database’
  • New suffixing standard (Optimal Flexible Architecture OFA)
  • More support for HTTP, HTML and Java
  • Function-based indexes
  • Materialized views
• Version 9i
  • Over 750 new features
  • Oracle Real Application Cluster (RAC)
  • Began regular security patches
• Version 10g
  • ‘g’ for Grid Computing
  • Improvements in RAC
  • Automatic Storage Management - ASM
• Version 11g
  • Even More features
  • Real Application Testing
  • Partitioning improvements
  • Online patching
• Version 12c - Cloud Database
• Six year development cycle
• Multi-tenant architecture
• Virtualization becomes a part of the database

Oracle Version Numbering