Infrastructure at your Service

All Posts By

Jérôme Dubar

Jérôme Dubar

Boost your CPU speed with Standard Edition 2 on ODA

By | Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction There is no need to decrease the number of cores on your ODA when using Standard Edition 2, because your license is based on the number of physical CPU. So why would you do that? Obviously, the more cores you have, the more performance you should get. But that simply isn’t always true. Base CPU speed and Turbo Boost If you didn’t read my previous blog, please do so to understand how Xeon processors…

Read More
Jérôme Dubar

Oracle Database Appliance and CPU speed

By | Database Administration & Monitoring, Development & Performance, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction A complaint I heard from customers about ODA is the low core speed of the Intel Xeon processor embedded in the X8-2 servers: Intel(R) Xeon(R) Gold 5218 CPU @ 2.30GHz. 2.30GHz only? Because of its comfortable number of cores (16 per processor), the cruise speed of each core is limited. Is it a problem compared to a home made server with less cores? Why clock speed is important? As you may now, the faster…

Read More
Jérôme Dubar

ODA: odacli now supports Data Guard in 19.8

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | 2 Comments

Introduction I’ve been dreaming of this kind of feature: just because most of the ODA configurations now include Disaster Recovery capabilities, through Data Guard or Dbvisit standy. If Dbvisit will obviously never be integrated to odacli, the lack of Data Guard features is now solved by the very latest 19.8 ODA software appliance kit. How Data Guard was implemented before 19.8? Those who have been using ODA and Data Guard for a while know that…

Read More
Jérôme Dubar

Oracle Cloud basics for beginners

By | Cloud, Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | 2 Comments

Introduction Cloud, Cloud, Cloud. Everyone is talking about the Cloud but a lot of people are still in the fog with Cloud technologies. Let’s talk about basic features of the Oracle Cloud, called OCI for Oracle Cloud Infrastructure. What is really OCI? OCI is physically a lot of servers in datacenters all around the world. These servers are not very different from the servers you probably have in your own datacenter. Some of these servers…

Read More
Jérôme Dubar

6 things Oracle could do for a better ODA

By | Cloud, Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction With the latest ODA X8 range, at least 80% of the customers could find an ODA configuration that fits their needs. For the others, either they can’t afford it, either they are already in the Cloud, or they need extremely large storage or EXADATA performance. Among these 80% of customers, only a few choose ODA. Let’s see how Oracle could improve the ODA to make it a must. 1) Make robust and reliable releases…

Read More
Jérôme Dubar

Oracle Database Appliance: which storage capacity to choose?

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction If you’re considering ODA for your next platform, you surely already appreciate the simplicity of the offer. 3 models with few options, this is definitely easy to choose from. One of the other benefit is also the hardware support of 5 years, and combined with software updates generally available for up to 7 years old ODAs, you can keep your ODA running even longer for non-critical databases and/or if you have a strong Disaster…

Read More
Jérôme Dubar

Terraform and Oracle Cloud Infrastructure

By | Cloud, Database Administration & Monitoring, Development & Performance, Operation systems, Oracle | No Comments

Introduction When you learn a cloud technology, like OCI, the one from Oracle, you start building your demo infrastructure with the web interface and numerous clicks. It’s convenient and easy to handle, even more if you’re quite used to infrastructure basics: network, routing, firewalling, servers, etc. But when it comes to build complex infrastructures with multiple servers, subnets, rules, databases, it’s more than a few clicks to do. And rebuilding a clone infrastructure (for example…

Read More
Jérôme Dubar

ODA 19.6 is available

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | 6 Comments

Introduction It’s been 1 year now that 19c is available on-premise. Finally, 19c is now available today on ODA too, in a real production release. Let’s have a glance of what’s inside. Is 19.6 available for my old ODA? The 19.6 release, like most recent releases, is the same for all ODAs. But oldest ODAs will not support it. First-gen ODA (now 8 years old), X3-2 (7yo) and X4-2 (6yo) won’t support this very latest…

Read More
Jérôme Dubar

Patching ODA from 18.3 to 18.8

By | Database Administration & Monitoring, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction 19c will soon be available for your ODAs. But you may not be ready. Here is how to patch your ODA from 18.3 to 18.8, the very latest 18c release. This patch has here been applied on X7-2M hardware. Download the patch files Patch number is 30518425. This patch is composed of 2 zipfiles you will copy on your ODA. Check free space on disk Applying a patch requires several GB, please check free…

Read More
Jérôme Dubar

Speed up datapump export for migrating big databases

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | 3 Comments

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 datapump, you can easily migrate to a new filesystem (ASM for example), rethink your tablespace organization, reorganize all the segments, exclude unneeded components, etc. All of these tasks in one operation. But datapump export can…

Read More