Tag: Oracle

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…

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;…

Hi everyone! It’s been a very busy year for me, so I haven’t had much time to blog. But, here we go! This isn’t a technical post, but more of an opinion piece. I’ve split this post into two parts….

You can run Oracle anywhere. It’s very flexible, which means anywhere you can get a VM, you can run it, including a virtual box on your laptop. There’s even have a free edition (XE) if you don’t have large data…

How do you know your Oracle Backups can be used to restore a database? Here is how to find out.

Backups of Oracle Databases can be made directly to s3, without licensing additional software.