The idea of this post is to show how to handle errors using SQLCODE function. That function shows the code error for the latest exception when running a PL/SQL code. Here is a small example of code that raises an…

On October 31, 2019, I blogged about How To Use CreateGoldImage For Cloning In 19c. CreateGoldImage seems like a nice new feature; however, it’s also very buggy. Here are a few bugs: 2641469.1 27432355.8 27432338.8 I received a suggestion to use tar…

In this post, I’ll present the statspack_top_sqls.sql script, which returns SQL performance statistics by mining the Statspack repository. In a previous blog post, I presented the statspack_load_trends.sql and the AWR_load_trends.sql scripts, which provide a high-level overview of workload dynamics on…

There are various ways that we can approach the analysis of a past database performance problem. The initial steps usually differ based on their scope. Is it limited to a certain SQL/process/task, or is it perceived as a database-wide slowdown?…

Here we will see how the deployment process of the new Exadata X8M works.   RoCE issues from the factory Exadata X8M servers are coming from the factory with the RoCE private network disabled. In case the Field Engineer assigned…

Background A common question from Oracle customers is whether they can configure the Oracle Database to use: Two-Factor Authentication (2FA) Multi-Factor Authentication (MFA) A “Time-based One-time Password” (TOTP) code, which is usually a six-digit code generated from a hardware or…

Hello! I recently noticed that: What if I’m not happy with the Oracle algorithm and I want to drop and auto-index on 19c? It should be easy, I initially thought. For example, something like “drop index XXXX;” right? Wrong. However,…

Managing Oracle on AWS has some twists. Here are five daily DBA activities that have changed on AWS: Kill Sessions: begin rdsadmin.rdsadmin_util.kill( sid => &sid, serial => &serial, method => ‘IMMEDIATE’); end; /   Flush shared_pool or buffer_cache: exec rdsadmin.rdsadmin_util.flush_shared_pool;…

In a new 12c environment (which actually includes 18c and 19c, as per the 12c family), the datapatch failed on the following: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1 ORA-65108: invalid use of a cursor…

There are multiple documented methods for installing the Oracle Cloud Infrastructure command line utilities (oci). Some methods work better than others, but sometimes none of them meet your needs. This is a story of getting the installation done to meet our needs.