Infrastructure at your Service

Category

Oracle

Franck Pachot

The myth of NoSQL (vs. RDBMS) agility: adding attributes

By | AWS, Database Administration & Monitoring, NoSQL, Oracle, Postgres, SQL Server | 3 Comments

By Franck Pachot . There are good reasons for NoSQL and semi-structured databases. And there are also many mistakes and myths. If people move from RDBMS to NoSQL because of wrong reasons, they will have a bad experience and this finally deserves NoSQL reputation. Those myths were settled by some database newbies who didn’t learn SQL and relational databases. And, rather than learning the basics of data modeling, and capabilities of SQL for data sets…

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
Mouhamadou Diaw

Migrating From Oracle Non-CDB 19c to Oracle 20c

By | Database Administration & Monitoring, Oracle | 2 Comments

With Oracle 20c, the non-multitenant architecture is no longer supported. So, people will have to migrate their databases to container if they want to use Oracle 20c. There are many methods to transform a non-cdb database to a pluggable one. -Datapump -Full Trabsportable Tablespaces -Plugging non-cdb database , upgrade the plugged database and then convert -Upgrading the non-cdb database, then plug it the container and then convert it ( But I am not sure that…

Read More
Jérôme Dubar

ODA 19.6 is available

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | 2 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
Franck Pachot

티베로 – The most compatible alternative to Oracle Database

By | Oracle | 6 Comments

By Franck Pachot . Do you remember that time where we were able to buy IBM PC clones, cheaper than the IBM PC but fully compatible? I got the same impression when testing Tibero, the TmaxSoft relational database compatible with the Oracle Database. Many Oracle customers are looking for alternatives to the Oracle Database, because of unfriendly commercial and licensing practices, like forcing the usage of expensive options or not counting vCPU for licensing. Up…

Read More
Franck Pachot

Oracle Support: Easy export of SQL Testcase

By | Oracle | No Comments

By Franck Pachot . Many people complain about the quality of support. And there are some reasons behind that. But before complaining, be sure that you provide all information. Because one reason for inefficient Service Request handling is the many incomplete tickets the support engineers have to manage. Oracle provides the tools to make this easy for you and for them. Here I’ll show how easy it is to provide a full testcase with DBMS_DIAG….

Read More
Franck Pachot

“Segment Maintenance Online Compress” feature usage

By | Oracle | No Comments

By Franck Pachot . On Twitter, Ludovico Caldara mentioned the #licensing #pitfall when using the Online Partition Move with Basic Compression. Those two features are available in Enterprise Edition without additional option, but when used together (moving online a compressed partition) they enable the usage of Advance Compression Option: Will it be reflected in dba_feature_usage_statistics? — Niels Jespersen (@njesp) April 19, 2020 And there was a qustion about detection of this feature. I’ll show how…

Read More
Franck Pachot

Find the SQL Plan Baseline for a plan operation

By | Oracle | No Comments

By Franck Pachot . If you decide to capture SQL Plan Baselines, you achieve plan stability by being conservative: if the optimizer comes with a new execution plan, it is loaded into the SQL Plan Management base, but not accepted. One day, you may add an index to improve some queries. Then you should check if there is any SQL Plan Baseline for queries with the same access predicate. Because the optimizer will probably find…

Read More
Clemens Bleile

Starting an Oracle Database when a first connection comes in

By | Oracle | 2 Comments

To save resources I thought about the idea to start an Oracle database automatically when a first connection comes in. I.e. if there are many smaller databases on a server, which are not required during specific times, then we may shut them down and automatically start them when a connection comes in. The objective was that even the first connection should be successful. Is that possible? Yes, it is. Here’s what I did: First of…

Read More