Infrastructure at your Service

Tag

Exadata Archives - Blog dbi services

Jérôme Dubar

Get prepared to move your Oracle databases to OCI

By | Cloud, Database Administration & Monitoring, Database management, Oracle | No Comments

Introduction Cloud often raises in the top 3 solutions when thinking about Oracle infrastructure renewal. For obvious reasons: you do not need to buy any server, platform is already available, you pay as a subscription, you drastically reduce time to go to production and you can scale up and down. Oracle Cloud Infrastructure, or OCI, is a Cloud provider you should consider if you’re using Oracle databases. But what do you need to plan before…

Read More
Casimir Schmid

Exadata X9M release

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

I would like to share some personal thoughts. September 28th 2021, Oracle released the eleventh Exadata data machine called “X9M-2” (2 CPU sockets), X9M-8 (8 sockets) and ZDLRA X9M. Exadata is a computing platform to run Oracle RDBMS, zero data loss recovery appliance (ZDLRA) is a platform to backup Oracle RDBMS and based on Exadata hardware.

Read More
Jérôme Dubar

OBUG 2019 – First event from Oracle Users Group in Belgium!

By | Database Administration & Monitoring | No Comments

Introduction It’s the first edition of the Techdays, the Oracle community event in Belgium. This event happened in Antwerp these past 2 days, and a lot of speakers came from around the world to talk about their experience on focused subjects. Really amazing to heard such high-level conferences. And it was a great pleasure for me because I’ve been working in Belgium for several years before. I’ll will try to give you a glimpse of…

Read More
Oracle Team

10th CH Exadata Community Meeting

By | Database Administration & Monitoring | One Comment

By William Sescu Yesterday (15th of March), the 10th Switzerland Exadata Community Meeting took place. It was not a meeting only about Exadata, but also about the Oracle Database Appliances which became more and more popular. It is interesting, how many companies in Switzerland already use Exadata’s or ODA’s. A big topic was the Exadata 12.2.1.1.0 software release which includes over 30 unique software features and enhancements, like better analytics, better transaction processing, better consolidation,…

Read More
Oracle Team

Exadata Express Cloud Service: MAX_PDB_STORAGE

By | Cloud, Database Administration & Monitoring | No Comments

By Franck Pachot . The separation of roles between system DBA and application DBA is the way to go for agile development and the PDBaaS managed service is an excellent way to play with this concept: You are PDB administrator but not the CDB administrator. Here is an example about tablespace creation/deletion, and the kind of problems that may arise with this architecture.

Read More
Oracle Team

Running SLOB on Exadata Express Cloud Service

By | Database Administration & Monitoring | One Comment

By Franck Pachot . The Exadata Express Cloud Service is a managed PDBaaS: Oracle is the system admin and the CDB database administrator, you are the PDB administrator. You connect with a local user, PDB_ADMIN, which is no SYSDBA privilege but has a PDB_DBA which has nearly all DBA rights, but with some features disabled by lockdown profile. I have no worry about the performance on this service: it is an Exadata X5 half rack…

Read More
Oracle Team

Exadata X-5 Bare Metal vs. OVM performance

By | Database Administration & Monitoring | No Comments

By Franck Pachot . The Exadata X5 can be installed Bare Metal or Virtualized. The latter one, Oracle VM allows to create multiple clusters on one machine, is more complex for installation and for storage capacity planning. But it allows a small flexibility on options licencing. Those are the real challenges behind the choice. However, when we talk about virtualization, most of questions are about the overhead. Last week, we did some tests on same…

Read More
Oracle Team

GTT in Exadata are eligible to SmartScan

By | Database Administration & Monitoring | No Comments

By Franck Pachot . I wanted to check if Exadata predicate offloading can occur on Global Temporary Tables. Actually, I thought it did not and I was wrong. I was ready to post that as an hypothesis for https://community.oracle.com/thread/3903836 but, before any post to forums, I try to test what I say because I may be wrong, or things may have changed from versions to versions. Here I will show how it’s easy to quickly…

Read More