Oracle

Database is more than persistence. It is shared. My thoughts about Microservice Database.

By Franck Pachot . The development teams often see the database as a 'persistence layer' only. And sometimes it is mentioned that the database is always the cause of the problems, especially when implementing continuous integration and trying to be(…)

Archivelog deletion policy on Data Guard configuration

By Franck Pachot . The deletion policy on a dataguard configuration should be: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; for the site where you don't backup. It can be the standby or the primary. and: CONFIGURE ARCHIVELOG(…)

Managing Oracle Big Data Cloud – CE with REST API

In this blog post, we will see how to manage Oracle Public Cloud Big Data service Compute Edition with REST API. Scheduling the start/stop/restart of a metered PaaS in the Oracle Cloud can be interesting for managing efficiently the consumption(…)

Oracle Database Multilingual Engine (MLE)

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,(…)

ODC Appreciation Day : Javascript in the database

By Franck Pachot . Tim Hall has launched the idea to post small blogs this day, from all the Oracle community, about an Oracle feature. I choose one feature that is only released in beta test(…)

Autonomous Database

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.

ODA X7

By Franck Pachot . ODA X6-2 So, the ODA X6 End of Life seems to be planned for October, and be careful, as far as I know, this concerns also the storage expansion. The main feedback from the X6-2 series(…)

Oracle 18c RU and RUR for pioneers and followers

By Franck Pachot . In a previous post, I explained the announcement of the new release model, with Release Updates and Release Update Revisions replacing Proactive Bundle Patch and PSUs. Here is a description that will(…)

“_suppress_identifiers_on_dupkey” – the SAP workaround for bad design

By Franck Pachot . In SQL, 'upsert' is a conditional insert or update: if the row is there, you update it, but if it is not there, you insert it. In Oracle, you should use a MERGE statement for that.

Oracle Big Data Cloud Service – Compute Edition

In this blog post, we will see how to create a Big Data cluster through the Oracle Cloud Services. If you want more details about the Oracle Big Data cloud services offering, you can refer to my previous blog(…)