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.

Primavera P6 Professional Project Management gives today’s project managers and schedulers the one thing they value most: control. Primavera P6 Professional Project Management, the recognised standard for high-performance project management software, is designed to handle large-scale, highly sophisticated and multifaceted projects. It can be used to organise projects up to 100,000 activities, and it provides unlimited resources and an unlimited number of target plans. Massive data requires sophisticated, yet highly flexible organisation tools to provide you a multitude of ways to organize, filter and sort activities, projects, and resources.

Oracle Primavera P6 is a project, program and portfolio management tool that's used for planning, managing and executing your project work. It's designed to handle large and small projects in many diverse industries, such as construction, manufacturing, energy, and IT

The Standard for Planning and SchedulingRobust, and easy-to-use, Primavera P6 EPPM is the solution for globally prioritizing, planning, managing, and executing projects, programs, and portfolios. Find hidden risks in your project schedule before they become showstoppers.

Primavera P6 Professional Project Management gives today’s project managers and schedulers the one thing they value most: control. Primavera P6 Professional Project Management, the recognised standard for high-performance project management software, is designed to handle large-scale, highly sophisticated and multifaceted projects. It can be used to organise projects up to 100,000 activities, and it provides unlimited resources and an unlimited number of target plans. Massive data requires sophisticated, yet highly flexible organisation tools to provide you a multitude of ways to organize, filter and sort activities, projects, and resources.

Primavera P6 Enterprise Project Portfolio Management is an integrated project portfolio management (PPM) solution comprising role-specific functionality to satisfy each team member’s needs, responsibilities, and skills. This 100% web-based solution can be used to manage projects of any size, adapt to various levels of complexities within a project, and intelligently scale to meet the needs of various roles, functions, or skill levels in your organisation and on your project team. Primavera P6 EPPM can easily scale from a single user on a small project to tens of thousands of users engaged in millions of activities across hundreds of projects both on premise and in the cloud.

Primavera P6 Enterprise Project Portfolio Management is an integrated project portfolio management (PPM) solution comprising role-specific functionality to satisfy each team member’s needs, responsibilities, and skills. This 100% web-based solution can be used to manage projects of any size, adapt to various levels of complexities within a project, and intelligently scale to meet the needs of various roles, functions, or skill levels in your organisation and on your project team. Primavera P6 EPPM can easily scale from a single user on a small project to tens of thousands of users engaged in millions of activities across hundreds of projects both on premise and in the cloud.

MySQL licensing works through a combination of open-source and commercial options:

• MySQL License Models: Offers open-source GPL and commercial licenses. GPL allows public use, modification, and redistribution of source code under GPL terms. Commercial license suits those needing extra support or source code privacy.
• MySQL Editions: Various editions like MySQL Classic (embedded only), MySQL Standard, and MySQL Enterprise cater to different requirements.
• License Costs: Prices vary based on the edition and server sockets. Licensing is available through Oracle partners under ASFU or ESL agreements. Specific pricing is set by Independent Software Vendors (ISVs).

MySQL Enterprise Edition includes the most comprehensive set of advanced features, management tools and technical support to achieve the highest levels of MySQL scalability, security, reliability, and uptime. It reduces the risk, cost, and complexity in developing, deploying, and managing business-critical MySQL applications.

MySQL Enterprise Transparent Data Encryption (TDE)

MySQL Enterprise Transparent Data Encryption (TDE) enables data-at-rest encryption by encrypting the physical files of the database. Data is encrypted automatically, in real time, prior to writing to storage and decrypted when read from storage.

MySQL Enterprise Masking and De-identification

MySQL Enterprise Masking and De-identification provides an easy to use, built-in database solution to help organizations protect sensitive data from unauthorized uses by hiding and replacing real values with substitutes.

MySQL Enterprise Backup

MySQL Enterprise Backup reduces the risk of data loss by delivering online "Hot" backups of your databases. It supports full, incremental and partial backups, Point-in-Time Recovery and backup compression.

MySQL Enterprise High Availability

MySQL InnoDB Cluster delivers an integrated, native, HA solution for your databases. It tightly integrates MySQL Server with Group Replication, MySQL Router, and MySQL Shell, so you don’t have to rely on external tools, scripts or other components.

MySQL Enterprise Scalability

MySQL Enterprise Scalability enables you to meet the sustained performance and scalability requirements of ever increasing user, query and data loads. MySQL Thread Pool provides an efficient, thread-handling model designed to reduce overhead in managing client connections, and statement execution threads.

MySQL Enterprise Authentication

MySQL Enterprise Authentication provides ready to use external authentication modules to easily integrate MySQL with existing security infrastructures including PAM and Windows Active Directory. MySQL users can be authenticated using Pluggable Authentication Modules ("PAM") or native Windows OS services.

MySQL Enterprise Encryption

MySQL Enterprise Encryption provides encryption, key generation, digital signatures and other cryptographic features to help organizations protect confidential data and comply with regulatory requirements.

MySQL Enterprise Firewall

MySQL Enterprise Firewall guards against cyber security threats by providing real-time protection against database specific attacks, such as an SQL Injection. MySQL Enterprise Firewall monitors for database threats, automatically creates an allowlist of approved SQL statements and blocks unauthorized database activity.

MySQL Enterprise Audit

MySQL Enterprise Audit enables you to quickly and seamlessly add policy-based auditing compliance to new and existing applications. You can dynamically enable user level activity logging, implement activity-based policies, manage audit log files and integrate MySQL auditing with Oracle and third-party solutions.

MySQL Enterprise Monitor

The MySQL Enterprise Monitor and the MySQL Query Analyzer continuously monitor your databases and alerts you to potential problems before they impact your system. It's like having a "Virtual DBA Assistant" at your side to recommend best practices to eliminate security vulnerabilities, improve replication, optimize performance and more. As a result, the productivity of your developers, DBAs and System Administrators is improved significantly.

MySQL Document Store

MySQL Document Store gives users maximum flexibility developing SQL and NoSQL, schema-free document database applications. This eliminates the need for a separate database for NoSQL data.

Oracle Enterprise Manager for MySQL

The Oracle Enterprise Manager for MySQL provides real-time monitoring and delivers comprehensive performance, availability and configuration information for your MySQL databases.

MySQL Router

MySQL Router is lightweight middleware that provides transparent routing between your application and any backend MySQL Servers. It can be used for a wide variety of use cases, such as providing high availability and scalability by effectively routing database traffic to appropriate backend MySQL Servers.

MySQL Workbench

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. It provides data modeling, SQL development, database migration and comprehensive administration tools for server configuration, user administration, and much more.

MySQL Technical Support

MySQL Technical Support Services provide 24x7 direct access to our expert MySQL Support engineers who are ready to assist you in the development, deployment, and management of MySQL applications.