Category Archives: Uncategorized

I am working on an SR with Oracle support and they asked me to do a 10128 trace to look at how the optimizer is doing partition pruning.  I did some quick research on this trace and wanted to pass … Continue reading →

I had a five-minute conversation with Oracle development Friday that rocked my world.  I found out that parsing blocks stats which blocks parsing. We have a system with queries that are taking minutes to parse.  These queries include the main … Continue reading →

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 →