Does Oracle Database have more than one edition? Yes, I know it has been like this for many years, but I think it is worth pointing this out again. When looking at the Oracle Database - there are actually a few options available to you. Some might not actually know this, as the only option they might be presented with by default could be Oracle Enterprise Edition (EE). Don’t get me wrong, it is an amazing solution with a plethora of options. But it does in fact, as I always say, have a little brother – Oracle Standard Edition 2, which actually is worth looking at. It might not have all the features - or bells and whistles as some say; but it is feature-rich and at the core still, an amazing database edition which if you look closely, it could be the right fit for you.

Oracle Database Standard Edition 2 (SE2) can be licensed and used on servers with a maximum capacity of 2 CPU sockets. There is no limit to the number of cores. It is important to note though that Oracle Database Standard Edition 2 automatically limits the maximum number of CPU threads to 16 at any one time. To some, this might be seen as a limitation, but for most this should be more than sufficient to run workloads - especially if later faster CPU models are used. One important thing when the initial version of Standard Edition 2 was released was that it came bundled with Oracle Real Application Clusters (RAC). This unfortunately has changed since Oracle released the 19c update. As of 19c, Oracle Standard Edition 2 does not include the Oracle RAC option, which was a big shock to most of us. However, since the release of SE2 and the limitations on 16 threads using Oracle RAC with SE2 became a less attractive option, many new installations of Oracle SE2 tend to be more single instance than Oracle RAC. Plenty of companies that still had the Oracle Standard Edition (SE) option (usually running 11.2.0.4 database patched version) which allowed up to 4 CPU sockets with no thread limitation, started looking at keeping this more long term. Short term this might seem like a good plan while you review the options going forward. It is recommended to make sure you have a support agreement in place - and always keep an eye on this Oracle support note: Release Schedule of Current Database Releases (Doc ID 742060.1).

Does Oracle Database have more than one edition? Yes, I know it has been like this for many years, but I think it is worth pointing this out again. When looking at the Oracle Database - there are actually a few options available to you. Some might not actually know this, as the only option they might be presented with by default could be Oracle Enterprise Edition (EE). Don’t get me wrong, it is an amazing solution with a plethora of options. But it does in fact, as I always say, have a little brother – Oracle Standard Edition 2, which actually is worth looking at. It might not have all the features - or bells and whistles as some say; but it is feature-rich and at the core still, an amazing database edition which if you look closely, it could be the right fit for you.

Oracle Database Standard Edition 2 (SE2) can be licensed and used on servers with a maximum capacity of 2 CPU sockets. There is no limit to the number of cores. It is important to note though that Oracle Database Standard Edition 2 automatically limits the maximum number of CPU threads to 16 at any one time. To some, this might be seen as a limitation, but for most this should be more than sufficient to run workloads - especially if later faster CPU models are used. One important thing when the initial version of Standard Edition 2 was released was that it came bundled with Oracle Real Application Clusters (RAC). This unfortunately has changed since Oracle released the 19c update. As of 19c, Oracle Standard Edition 2 does not include the Oracle RAC option, which was a big shock to most of us. However, since the release of SE2 and the limitations on 16 threads using Oracle RAC with SE2 became a less attractive option, many new installations of Oracle SE2 tend to be more single instance than Oracle RAC. Plenty of companies that still had the Oracle Standard Edition (SE) option (usually running 11.2.0.4 database patched version) which allowed up to 4 CPU sockets with no thread limitation, started looking at keeping this more long term. Short term this might seem like a good plan while you review the options going forward. It is recommended to make sure you have a support agreement in place - and always keep an eye on this Oracle support note: Release Schedule of Current Database Releases (Doc ID 742060.1).

Does Oracle Database have more than one edition? Yes, I know it has been like this for many years, but I think it is worth pointing this out again. When looking at the Oracle Database - there are actually a few options available to you. Some might not actually know this, as the only option they might be presented with by default could be Oracle Enterprise Edition (EE). Don’t get me wrong, it is an amazing solution with a plethora of options. But it does in fact, as I always say, have a little brother – Oracle Standard Edition 2, which actually is worth looking at. It might not have all the features - or bells and whistles as some say; but it is feature-rich and at the core still, an amazing database edition which if you look closely, it could be the right fit for you.

Oracle Database Standard Edition 2 (SE2) can be licensed and used on servers with a maximum capacity of 2 CPU sockets. There is no limit to the number of cores. It is important to note though that Oracle Database Standard Edition 2 automatically limits the maximum number of CPU threads to 16 at any one time. To some, this might be seen as a limitation, but for most this should be more than sufficient to run workloads - especially if later faster CPU models are used. One important thing when the initial version of Standard Edition 2 was released was that it came bundled with Oracle Real Application Clusters (RAC). This unfortunately has changed since Oracle released the 19c update. As of 19c, Oracle Standard Edition 2 does not include the Oracle RAC option, which was a big shock to most of us. However, since the release of SE2 and the limitations on 16 threads using Oracle RAC with SE2 became a less attractive option, many new installations of Oracle SE2 tend to be more single instance than Oracle RAC. Plenty of companies that still had the Oracle Standard Edition (SE) option (usually running 11.2.0.4 database patched version) which allowed up to 4 CPU sockets with no thread limitation, started looking at keeping this more long term. Short term this might seem like a good plan while you review the options going forward. It is recommended to make sure you have a support agreement in place - and always keep an eye on this Oracle support note: Release Schedule of Current Database Releases (Doc ID 742060.1).

Does Oracle Database have more than one edition? Yes, I know it has been like this for many years, but I think it is worth pointing this out again. When looking at the Oracle Database - there are actually a few options available to you. Some might not actually know this, as the only option they might be presented with by default could be Oracle Enterprise Edition (EE). Don’t get me wrong, it is an amazing solution with a plethora of options. But it does in fact, as I always say, have a little brother – Oracle Standard Edition 2, which actually is worth looking at. It might not have all the features - or bells and whistles as some say; but it is feature-rich and at the core still, an amazing database edition which if you look closely, it could be the right fit for you.

Oracle Database Standard Edition 2 (SE2) can be licensed and used on servers with a maximum capacity of 2 CPU sockets. There is no limit to the number of cores. It is important to note though that Oracle Database Standard Edition 2 automatically limits the maximum number of CPU threads to 16 at any one time. To some, this might be seen as a limitation, but for most this should be more than sufficient to run workloads - especially if later faster CPU models are used. One important thing when the initial version of Standard Edition 2 was released was that it came bundled with Oracle Real Application Clusters (RAC). This unfortunately has changed since Oracle released the 19c update. As of 19c, Oracle Standard Edition 2 does not include the Oracle RAC option, which was a big shock to most of us. However, since the release of SE2 and the limitations on 16 threads using Oracle RAC with SE2 became a less attractive option, many new installations of Oracle SE2 tend to be more single instance than Oracle RAC. Plenty of companies that still had the Oracle Standard Edition (SE) option (usually running 11.2.0.4 database patched version) which allowed up to 4 CPU sockets with no thread limitation, started looking at keeping this more long term. Short term this might seem like a good plan while you review the options going forward. It is recommended to make sure you have a support agreement in place - and always keep an eye on this Oracle support note: Release Schedule of Current Database Releases (Doc ID 742060.1).

Oracle Database Personal Edition Oracle Database Personal Edition supports single-user development and deployment environments that require full compatibility with Oracle Database Standard Edition One, Oracle Database Standard Edition, and Oracle Database Enterprise Edition.

Personal Edition includes all of the components that are included with Enterprise Edition, as well as all of the options that are available with Enterprise Edition, with the exception of the Oracle Real Application Clusters option, which cannot be used with Personal Edition. Personal Edition is available on Windows platforms only. The Management Packs are not included in Personal Edition.

But the link from Andris is better for restriction

Oracle Database Enterprise Edition Options are designed to address the most demanding business and IT challenges. They offer advanced capabilities in performance, availability, security, and compliance. These options include Real Application Clusters (RAC), Partitioning, Advanced Compression, and Advanced Security

Oracle Database Enterprise Edition offers industry-leading scalability and reliability in both clustered and single system configurations. It provides the most comprehensive features for OLTP and business intelligence, and delivers the lowest total cost of ownership. Enterprise Edition includes high performance business intelligence services such as ETL, data warehousing, OLAP, and data mining; comprehensive, open access to Web Services through SQL, Java, XML and standard Web interfaces; continuous availability despite system failures, site failures, and disasters, human errors, and planned maintenance.

Oracle Database Enterprise Edition delivers record-breaking performance and scalability on systems from small departmental servers running Windows or Linux to the largest UNIX servers and mainframes.

Oracle Database Enterprise Edition Options are designed to address the most demanding business and IT challenges. They offer advanced capabilities in performance, availability, security, and compliance. These options include Real Application Clusters (RAC), Partitioning, Advanced Compression, and Advanced Security  Oracle Database Enterprise Edition offers industry-leading scalability and reliability in both clustered and single system configurations. It provides the most comprehensive features for OLTP and business intelligence, and delivers the lowest total cost of ownership. Enterprise Edition includes high performance business intelligence services such as ETL, data warehousing, OLAP, and data mining; comprehensive, open access to Web Services through SQL, Java, XML and standard Web interfaces; continuous availability despite system failures, site failures, and disasters, human errors, and planned maintenance.  Oracle Database Enterprise Edition delivers record-breaking performance and scalability on systems from small departmental servers running Windows or Linux to the largest UNIX servers and mainframes.

Oracle Database Enterprise Edition Options are designed to address the most demanding business and IT challenges. They offer advanced capabilities in performance, availability, security, and compliance. These options include Real Application Clusters (RAC), Partitioning, Advanced Compression, and Advanced Security.

Oracle Database Enterprise Edition offers industry-leading scalability and reliability in both clustered and single system configurations. It provides the most comprehensive features for OLTP and business intelligence, and delivers the lowest total cost of ownership. Enterprise Edition includes high performance business intelligence services such as ETL, data warehousing, OLAP, and data mining; comprehensive, open access to Web Services through SQL, Java, XML and standard Web interfaces; continuous availability despite system failures, site failures, and disasters, human errors, and planned maintenance.

Oracle Database Enterprise Edition delivers record-breaking performance and scalability on systems from small departmental servers running Windows or Linux to the largest UNIX servers and mainframes.

Oracle Database Enterprise Edition will greatly benefit customers deploying private database clouds and SaaS vendors looking for the power of Oracle database in a secure and isolated multitenant model. The multitenant database architecture enables higher levels of consolidation on the Cloud, without the need to change existing applications, Automatic Data Optimization features efficiently manage more data, lower storage costs and improve database performance, and scalable discovery of business event sequences with enhanced in-Database MapReduce capabilities for Big Data.

Oracle Database Enterprise Edition Options are designed to address the most demanding business and IT challenges. They offer advanced capabilities in performance, availability, security, and compliance. These options include Real Application Clusters (RAC), Partitioning, Advanced Compression, and Advanced Security.

Oracle Database Enterprise Edition offers industry-leading scalability and reliability in both clustered and single system configurations. It provides the most comprehensive features for OLTP and business intelligence, and delivers the lowest total cost of ownership. Enterprise Edition includes high performance business intelligence services such as ETL, data warehousing, OLAP, and data mining; comprehensive, open access to Web Services through SQL, Java, XML and standard Web interfaces; continuous availability despite system failures, site failures, and disasters, human errors, and planned maintenance.

Oracle Database Enterprise Edition delivers record-breaking performance and scalability on systems from small departmental servers running Windows or Linux to the largest UNIX servers and mainframes.

Oracle Database Enterprise Edition will greatly benefit customers deploying private database clouds and SaaS vendors looking for the power of Oracle database in a secure and isolated multitenant model. The multitenant database architecture enables higher levels of consolidation on the Cloud, without the need to change existing applications, Automatic Data Optimization features efficiently manage more data, lower storage costs and improve database performance, and scalable discovery of business event sequences with enhanced in-Database MapReduce capabilities for Big Data.