Category Archives: Uncategorized

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 →

Just got the invitation to the first AZORA (Arizona Oracle user group) meeting on October 23.  Here is the link: url It’s 2 pm at Oracle’s office, 2355 E Camelback Rd Ste 950, Phoenix, AZ. I’m looking forward to it! … Continue reading →

I have an example of paging in some Exadata OS Watcher log files.  We got an error in the alert log about a high load but reviewing AWR reports it did not seem like we had an unusual number of … Continue reading →

Yesterday and today I’ve read or heard two people mention the force_match => TRUE parameter value for DBMS_SQLTUNE.IMPORT_SQL_PROFILE and how it forces a profile to work on all SQL statements that are the same except for their literal values.  So, … Continue reading →

I saw this fun blog post about the Arizona Oracle User Group getting organized: blog post(updated with meetup page). I’m definitely interested in being involved.  Please pass this on to any Oracle DBAs, developers, etc. that you know in the … Continue reading →