Author Archives: Bobby

Whenever I need to test a query that has bind variables I usually go to the development team to ask them what typical values are or what the values were the last time the query ran.  I’m pretty sure that … Continue reading →

Here is a link to my updated Exadata PowerPoint presentation. I’ve been trying to improve my Exadata talk for the Collaborate 13 conference.  I’ve done this talk at work and at the ECO conference in October but I’m not completely … Continue reading →

I spent a lot of time yesterday digging into performance issues on a new database only to find a simple issue where two tables were joined on a column that was a number on one table and a varchar2 on … Continue reading →

OK.  This is really cool.  I found an archive of my old geocities blog: archive I thought geocities was gone forever but it isn’t.  Quite cool. – Bobby

I don’t focus on the Oracle optimizer’s cost of a particular execution plan when I’m tuning a query and I’m worried that many of the developers and DBAs that I’ve talked with about query tuning are too focused on lowering … Continue reading →

My company is trying out a new product called Delphix. We have had Delphix installed for about a month and I wanted this post to contain my first impressions for others who may be considering it.  Essentially Delphix provides fast … Continue reading →

My Exadata talk got accepted by the IOUG and the deadline for the slides and paper is rapidly approaching.  I’ve had the slides for a while but have never written the presentation down as a paper before.  So, I’ve posted … Continue reading →

We have event 27401 level 16384 set on some of our systems and it appears that this is preventing the scheduler from changing the active resource manager plan when the window opens. I haven’t been able to find any documentation … Continue reading →

I want to use this post to document a confusing issue we have had with the init parameter resource_manager_plan.  We had a situation where we had used an alter system command to set a particular plan to be active, but … Continue reading →

This is a followup to my previous post about using a Datapump export to ASM on an Exadata system.  I’m finalizing my backup of a large table that I’m modifying this weekend. I’ve been comparing notes with another team member … Continue reading →