BE SHARING

Oracle 20c

20c: AWR now stores explain plan predicates

13.05.2020 by Oracle Team

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

Database Administration & Monitoring

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

03.05.2020 by Oracle Team

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

Oracle Support: Easy export of SQL Testcase

20.04.2020 by Oracle Team

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

Oracle

Find the SQL Plan Baseline for a plan operation

17.04.2020 by Oracle Team

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

Development & Performance

Refactoring procedural to SQL – an example with MySQL Sakila

01.03.2020 by Open source Team

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

Cloud

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

24.02.2020 by Oracle Team

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

Database Administration & Monitoring

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

19.02.2020 by Oracle Team

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

Database Administration & Monitoring

Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD

18.02.2020 by Oracle Team

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

Cloud

Oracle Cloud: script to stop all PaaS services

02.08.2017 by Oracle Team

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

Database management

AWR does not store explain plan predicates

11.11.2014 by Oracle Team

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