Oracle Team

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

VirtualBox 5.2 exports the VM to the Oracle Cloud

By Franck Pachot . The new release of Oracle VM VirtualBox (aka VirtualBox) is there with a new functionality to export a VM to the Oracle Cloud Compute (aka Oracle Cloud Infrastructure). That can be interesting(…)

PostgreSQL Index Suggestion With Powa

By Mouhamadou Diaw A few time ago my colleague Daniel did a blog about POWA. In a nice article he shown how this tool can be used to monitor our PostgreSQL. In this present(…)

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.

When deterministic function is not

By Franck Pachot . When you declare a function-based index, the function is deterministic, which means that calling it with same arguments will always return the same result. This is required because the indexed values, which are the result of(…)