Oracle

Find the SQL Plan Baseline for a plan operation

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(…)

Starting an Oracle Database when a first connection comes in

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(…)

Cleanup a failed Oracle XE installation on Linux Mint

On this Blog I described on how to install Oracle XE on a current Linux Mint version (19.3. Tricia when writing the Blog). After the conversion of the Oracle provided rpm to a deb installation file with the tool(…)

Setup Oracle XE on Linux Mint – a funny exercise

On my old Laptop (Acer Travelmate with an Intel Celeron N3160 CPU) I wanted to install Oracle XE. Currently the available XE version is 18.4. My Laptop runs on Linux Mint 19.3 (Tricia). The Blog will describe the steps I(…)

Oracle recovery concepts

I’ve published a while ago a twitter thead on some Oracle recovery concepts. For those who are not following twitter, I’m putting the whole thread here:   🔴⏬ Here I start a thread(…)

A change in full table scan costs in 19c?

During tests in Oracle 19c I recently experienced this: cbleile@orcl@orcl> select * from demo4 where m=103; cbleile@orcl@orcl> select * from table(dbms_xplan.display_cursor); ... --------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | --------------------------------------------------------------------------- |(…)

Oracle disables your multitenant option when you run on EC2

I have installed Oracle 19.6 on an EC2 for our Multitenant Workshop training. And of course, during the workshop we create a lot of PDBs. If you don't have paid for the Enterprise Edition plus the(…)

Oracle 20c SQL Macros: a scalar example to join agility and performance

By Franck Pachot . Let’s say you have a PEOPLE table with FIRST_NAME and LAST_NAME and you want, in many places of your application, to display the full name. Usually my name will be displayed as ‘Franck Pachot’ and(…)

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(…)

Oracle 20c Data Guard : Validating a Fast Start Failover Configuration

By Mouhamadou Diaw In Oracle 20c, we can now validate a Fast Start Failover configuration with the new command VALIDATE FAST_START FAILOVER. This command will help identifying issues in the configuration. I tested this new feature. The Fast Start(…)