Author Archives: Bobby

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 →

Today I was trying to see if upgrading from 11.2.0.2 to 11.2.0.4 would change the SYS.WRH$_SQL_PLAN table.  This table is large on our production system so I wanted to find out if some time-consuming update to this table would occur … Continue reading →

The Unix utilities ps and top report memory differently with HugePages than without. Without HugePages ps -eF seems to include the SGA memory under the SZ column: UID        PID  PPID  C    SZ   RSS PSR STIME TTY          TIME CMD … oracle    … Continue reading →

On Monday we had some performance problems on a system that includes a database which uses shared servers.  The top wait was “virtual circuit wait”.  Here are the top 5 events for a 52 minute time frame: Top 5 Timed … Continue reading →