Oracle

Dbvisit replicate – SQL Developer chart

By Franck Pachot . Here is a quick SQL Developer report which display a chart about the Dbvisit replicate lag over the last hours(…)

Max PDBs in Standard Edition

By Franck Pachot . Here is a small warning. In Standard Edition, you may expect that the features that are not available for your edition are blocked, but in 12.2 you can create more than one PDB in Standard Edition,(…)

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