Hardware & Storage

Speed up datapump export for migrating big databases

Introduction Big Oracle databases (several TB) are still tough to migrate to another version on a new server. For most of them, you’ll probably use RMAN restore or Data Guard, but datapump is always a cleaner way to migrate. With(…)

odacli create-database extremely slow on ODA X8-2 with 19.5

Introduction ODA X8-2, in the S, M or HA flavour, is the new database appliance from Oracle. But as a brand new product, you can experience troubles due to the lack of maturity. This time, it concerns database creation that(…)

NVMe the afterburner for your database

Over 1 million IOPS (@8 KByte) and more than 26 GByte/s (@1MByte): Read more to see all impressive benchmark figures from a server with 14 NVMe drives and read why this is still not the best you could get...

Should I go for ODA 19.5 or should I wait until 19.6?

Introduction As you may know, Oracle Database 19c is available for new (X8-2) or older Oracle Database Appliances since several weeks. Current version is 19.5. But when you go to the official ODA documentation , it(…)

Make Oracle database simple again!

Introduction Let’s have a look at how to make Oracle database as simple as it was before. Oracle database is a great piece of software, yes it’s quite expensive, but it’s still the reference and most of the companies can(…)

ODA X8-2: the new generation

Introduction ODA X7-2 marked the maturity of the Oracle Database Appliance evolution, with 3 models suitable for nearly all customers using Oracle databases. The X7-2M was my favorite, with a lots of cores available (and restrainable), enough memory for dozens(…)

Patching or reimaging your ODA?

Introduction One of the key features of the ODA (Oracle Database Appliance) is the ability to patch the entire stack every three months, the goal being to keep all the components up-to-date. Most of the customers won’t patch so often,(…)

Huawei Dorado 6000 V3 benchmark

I had the opportunity to test the new Dorada 6000 V3 All-Flash storage system. See what the all-new Dorado 6000 V3 All-Flash Storage system is capable as storage for your database system.

When you change the UNDO_RETENTION parameter, the LOB segment’s retention value is not modified

Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show(…)

How to patch your ODA lite to 18.3.0.0.0

Even you don’t need 18c, or you’re not ready for this release, this patch will also update your 11gR2, 12cR1 and 12cR2 databases to the latest PSU available on ODA, it means for example the patchset from last July if(…)