Oracle 20c

20c: AWR now stores explain plan predicates

By Franck Pachot . In a previous post https://www.dbi-services.com/blog/awr-dont-store-explain-plan-predicates/ I explained this limitation in gathering filter and access predicates by Statspack and then AWR because of old bugs about reverse parsing of predicates. Oracle listens(…)

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

By Mouhamadou Diaw 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(…)

Oracle Support: Easy export of SQL Testcase

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

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

Refactoring procedural to SQL – an example with MySQL Sakila

By Franck Pachot What I want to show in this blog post is that, as in mathematics where you have to apply some algebra rules to transform an equation to an equivalent one, the database developer must translate the business(…)

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

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

Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD

By Mouhamadou Diaw As you may know, Oracle 20c is in the cloud with new features. The one I have tested is the PREPARE DATABASE FOR DATA GUARD. This command configures a database for use as a primary database(…)

Oracle Cloud: script to stop all PaaS services

By Franck Pachot . With metered cloud services, keeping all your instances running may become expensive. The goal is to start them only when you need them. Here is a script that stops all instances you have on the Oracle(…)

AWR does not store explain plan predicates

By Franck Pachot . What is the most important part in an execution plan? It’s probably the predicate section. It helps to see implicit conversions. It helps to understand why an index is used or not. Or to see(…)