Author Archives: Bobby

I’ve uploaded a monitoring script that I have worked on: zip. The script alerts you when the optimizer runs a SQL statement with a potentially new and inefficient plan so you can intervene.  This script improves upon my earlier script … Continue reading →

I found a broken link to an Oracle help document in one of my posts and when I went to the Oracle 12c database documentation to find the new URL to put in my post I found that Oracle had … Continue reading →

Saw an interesting post related to work I am doing locking in plans and finding plans that have changed: Carlos Sierra post on queries with changing performance. Our DBA team uses versions of my sqlstat.sql(updated) script to find queries whose … Continue reading →

This is pretty simple, but I thought I would share it since it is helpful to me.  I have been preparing for a large migration which involves table, index, type, function, package, and procedure changes.  When I run a big … Continue reading →

Yesterday was the first meeting of the newly restarted Arizona Oracle User Group, AZORA.  It was a good first meeting to kick off what I hope will turn into an active club. We met in the Tempe Public Library in … Continue reading →

Fellow Phoenicians (citizens of the Phoenix, Arizona area): This is a reminder that tomorrow is the first meeting of the newly reborn (risen from the ashes) Arizona Oracle User Group.  Here are the meeting details: url I hope to meet … Continue reading →

Here’s a zip of a script I modified today: zip Here’s an example output:  QUERY_NUM SQL_ID        PLAN_HASH_VALUE EXECUTIONS AVG_ELAPSED OPTIMIZER_COST AVG_FETCHES  AVG_SORTS AVG_DISK_READS AVG_BUFFER_GETS   AVG_ROWS    AVG_CPU AVG_IOWAIT AVG_DIRECT_WRITES AVG_PHYS_READS AVG_PHYS_WRITES ———- ————- ————— ———- ———– ————– ———– ———- ————– ————— … Continue reading →

I modified the bind variable extraction script that I normally use to make it more helpful to me. Here was my earlier post with the old script: blog post Here is my updated script: set termout on set echo on … Continue reading →

I was testing SQL plan baselines on a base 11.2.0.3 release of Oracle on a 64 bit Linux virtual machine.  I ran DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE to create a SQL plan baseline for a test query after running that query once to get … Continue reading →

I have a number 0f SQL Profiles on a database I’m working on and I wanted to know the sql_id of the SQL statements that they relate to.  Here is what I came up with: select distinct p.name sql_profile_name, s.sql_id … Continue reading →