Infrastructure at your Service

Tag

Oracle 18c Archives - Page 3 of 3 - Blog dbi services

Oracle Team

Enabled, Accepted, Fixed SQL Plan Baselines

By | Oracle | 4 Comments

By Franck Pachot . When the documentation is not always clear, I prefer to build a test case to be sure about the behavior in different context and different versions. Here is a test on SQL Plan Management to show which plan is chosen among the different states of SQL Plan Baselines: Enabled, Accepted, Fixed. Thanks to Oracle ACE program, I have some Oracle Cloud credits to quickly provision a database, so I tested that…

Read More
Oracle Team

18c new Lost Write Protection

By | Oracle | 5 Comments

By Franck Pachot . There are many layers between the Oracle Database pwrite() calls and the physical sector written on disk: filesystem, logical volume, SAN or NAS, with a lot of smart software running for Virtualisation, Compression, Snapshotting, Synchronisation… Are you sure that the changes you made to your data is actually persisted on disk, completely and without any corruption? In case of bug or crash in the storage layer, it may happen that only…

Read More
Oracle Team

18c dbms_xplan note about failed SQL Plan Baseline

By | Oracle | No Comments

By Franck Pachot . SQL Plan Baselines is a great feature for plan stability: you capture the plans that you accept. However, if the data model changes and the accepted plans cannot reproduce, the optimizer will come with a new plan. In 18c we have a note from DBMS_XPLAN when the optimization ‘failed to use SQL plan baseline for this statement’.

Read More
Oracle Team

18c, Cloud First and Cloud Only features: think differently

By | Cloud, Database Administration & Monitoring, Oracle | One Comment

By Franck Pachot . Remember the times when the Oracle Software features were the same on all platforms? Where Oracle databases could be ported to any relevant platform? Where we were able to try any feature, freely, by downloading the latest release software? Now we need to think differently. Because: The new software is released on Cloud first The major new features will never be available on-premises The Cloud here means the Oracle Cloud –…

Read More
Oracle Team

PDB upgrade from 12c to 18c

By | Oracle | 4 Comments

By Franck Pachot . Oracle 18c is out, in the Oracle Cloud, and the first thing I do with a new version is testing how long it takes to upgrade a previous version PDB by unplug/plug. Faster upgrade should be the benefit of having a slim dictionary where the system objects are reduced to metadata links and data links. However, it looks like upgrading the PDB dictionary still takes the same time as upgrading the…

Read More
Oracle Team

18c Read Only Oracle Home

By | Oracle | 2 Comments

By Franck Pachot . This is the big new feature of Oracle 18c about database software installation. Something that was needed for decades for the ease of software deployment. Piet de Visser raised this to Oracle a long time ago, and we were talking about that recently when discussing this new excitement to deploy software in Docker containers. Docker containers are by definition immutable images. You need a Read Only Oracle Home, all the immutable…

Read More
Oracle Team

Oracle Database Multilingual Engine (MLE)

By | Oracle | 2 Comments

By Franck Pachot . My ODC appreciation blog post was about Javascript in the database running in the beta of the Oracle Database Multilingual Engine (MLE). Here I’ll detail my first test which is a comparison, in performance, between a package written in Javascript, running in the MLE, and one written and running in PL/SQL.

Read More
Oracle Team

Autonomous Database

By | Oracle | 3 Comments

By Franck Pachot . Larry Ellison has announced Oracle 18c to be the Autonomous Database, the no-human labor, and self-driven, database. Here is a quick recap of what it is behind the marketing words. My opinion only.

Read More