Oracle

Clone a Terabyte Database in Seconds

Introduction Have you ever cloned a database using RMAN? Have you ever gotten the advice not to clone during daytime to avoid performance downgrade on the entire storage or network? For a proof of concept, we wanted to(…)

Some Artificial Intuition in Oracle SQL_ID?

By Franck Pachot . This post is something I discovered by chance when writing about tagging SQL statement with recognizable comments. We know that Oracle is introducing more and more artificial intelligence and machine learning in the database engine,(…)

Oracle Data Integrator Cloud

Data and applications integration is always a technical challenge for most of the companies. All data integration tool ensures that information is timely, accurate, and consistent across complex systems. Oracle Data Integrator (ODI) is different than traditional data integration tools(…)

Adding nmon to Oracle OSWatcher

nmon (nmon is short for Nigel’s performance Monitor for Linux on POWER, x86, x86_64, Mainframe & now ARM (Raspberry Pi)) is a nice tool to monitor a Linux system. Originally it came from the AIX-platform, where it is very(…)

Foreign Keys in MySQL, SQL, NoSQL, NewSQL

By Franck Pachot . In the NoSQL times, it was common to hear thinks like “SQL is bad”, “joins are bad”, “foreign keys are bad”. Just because people didn’t know how to use them, or they were running on(…)

Oracle – testing resource manager plans?

By Franck Pachot . I never remember that in order to use instance caging you need to set a Resource Manager Plan but don’t need to set CPU_COUNT explicitly (was it the case in previous versions?). Here is how(…)

How to migrate Oracle Reports to Oracle BI Publisher ?

According to the Oracle Lifetime Support Policy , Oracle is not planning any functional enhancements for Oracle Reports in its terminal release, or any subsequent releases. Oracle Fusion Middleware 12cR2 (12.2.1.3.0) will be Oracle Reports terminal release. Oracle Report(…)

ODA: Move a DB to ASM after migrating from 11g to 19c

Introduction Modern Oracle Database Appliances still support 11gR2, but there are several drawbacks using this old version: if you want/need support for your databases, you should pay for Market Driven Support (11gR2 is even no more under extended support –(…)

Oracle Database Appliance: ODA patch 19.10 is out

Introduction 4 months after the 19.9, here comes the 19.10 version of the Oracle Database Appliance patch. Let’s have a look at what’s new. Will my ODA supports this 19.10 patch? The 19.10 release will be the same for all(…)

How to configure additional listeners on ODA

Introduction Oracle Database Appliance has quite a lot of nice features, but when looking into the documentation, at least one thing is missing. How to configure multiple listeners? Odacli apparently doesn’t know what’s a listener. Let’s find out how to(…)