Oracle Database 18c will be the world's first autonomous database. It will be self-driving, self-tuning, self-scaling, self-securing and self-repairing. This session will have a closer look at those features that build the foundation for the self-driving and self-repairing nature of Oracle Database 18c, as those features are meant to enable the database to meet user-defined…

Oracle Database 18c will be the world's first autonomous database. It will be self-driving, self-tuning, self-scaling, self-securing and self-repairing. This session will have a closer look at those features that build the foundation for the self-driving and self-repairing nature of Oracle Database 18c, as those features are meant to enable the database to meet user-defined…

Oracle Real Application Clusters (RAC) provides a rich feature set on all supported platforms. There are, however, some Oracle RAC features that are only available on Oracle's Engineered Systems, in particular, the Oracle Exadata Database Machine. If you are interested to see what you get extra in those environments and how various functionalities are designed to…

Oracle Real Application Clusters (RAC) provides a rich feature set on all supported platforms. There are, however, some Oracle RAC features that are only available on Oracle's Engineered Systems, in particular, the Oracle Exadata Database Machine. If you are interested to see what you get extra in those environments and how various functionalities are designed to…

With an ever-growing number of available virtualization and container solutions as well as cloud computing orchestration tools, the question arises which of these solutions and tools are best suited to operate an Oracle Database, in particular an Oracle RAC database? This session will therefore provide an overview of supported solutions and tools to operate an…

With an ever-growing number of available virtualization and container solutions as well as cloud computing orchestration tools, the question arises which of these solutions and tools are best suited to operate an Oracle Database, in particular an Oracle RAC database? This session will therefore provide an overview of supported solutions and tools to operate an…

While Oracle Real Application Clusters (RAC) was not available in the Oracle Cloud for the longest time, it now has found its way into the Oracle Cloud in form of multiple, integrated RAC offerings, which differ in their infrastructure and yet all aim to deliver the same level of service that Oracle RAC is known…

While Oracle Real Application Clusters (RAC) was not available in the Oracle Cloud for the longest time, it now has found its way into the Oracle Cloud in form of multiple, integrated RAC offerings, which differ in their infrastructure and yet all aim to deliver the same level of service that Oracle RAC is known…

This presentation is about SQL statement parsing, what it is, how it affects database performance, and how to detect and correct parsing problems.  We begin by defining what parsing is, and then walking through it in detail.  This includes the initial checks (syntax, semantics, permissions), SQL_ID generation, and pointer creation from client process to private…

This presentation is about SQL statement parsing, what it is, how it affects database performance, and how to detect and correct parsing problems.  We begin by defining what parsing is, and then walking through it in detail.  This includes the initial checks (syntax, semantics, permissions), SQL_ID generation, and pointer creation from client process to private…