Oracle

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

Introduction to Oracle Big Data Services

Since few years, Oracle decided to move forward in the Big Data area, as their main competitor. The goal of this blog post is to explain you, how the Oracle Big Data offering is composed. As the Oracle Big Data(…)

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

Using WebLogic 12C RESTful management for monitoring WebLogic Domains

WebLogic 12.2.1 provides a new RESTful management interface with full accesses to all WebLogic Server resources. This interface offers an alternative to the WLST scripting or JMX developments for the management and the monitoring of WebLogic Domains. The following of(…)

Am I a DBA 3.0 or just an SQL*DBA?

By Franck Pachot . There are currently a lot of new buzz words and re-namings which suggest that our DBA role is changing, most of them escorted with a #cloud hashtag. Oracle Technology Network is now called Oracle Developer Community.

Wrong result with multitenant, dba_contraints and current_schema

By Franck Pachot . Multitenant architecture is not such a big change and this is why I recommend it when you start a project in 12c or if you upgrade to 12.2 - of course after thoroughly testing your application.

Active Data Guard services in Multitenant

By Franck Pachot . A database (or the CDB in multitenant) registers its name as the default service. When a standby database is on the same server, or same cluster, you have no problem because this database name is the(…)

12c Access Control Lists

By Franck Pachot . There is already enough information about the new simplified 12c way to define Access Control Lists, such as in oracle-base. I'm just posting my example here to show how it is easy.

Create constraints in your datawarehouse – why and how

By Franck Pachot . We still see some developers not declaring referential integrity constraints in datawarehouse databases because they think they don't need it (integrity of data has been validated by the ETL). Here is a small demo I did(…)