Just a brief note to share with you that if you are performing an RMAN duplication over an existing instance, you'll want to delete your temporary tablespace tempfiles first. Metalink Note 374934.1 can tell you the whys and wherefores. The note also seems to suggest that the problem exists solely... [Read More]
In his paper "Using DBMS_STATS in Access Path Optimization", Wolfgang Breitling writes:Histograms are like drugs -- An overdose [of histograms] can kill [performance].I've gotten a crash course on this recently. More on that in a bit.
I'm Kind of a Big Deal Around Here
Yesterday Justin Kestelyn over at the OTN blog announced a re-org of the blogs.oracle.com homepage. I was pleasantly surprised to see my own name listed among the likes of Werner Puschitz, Jonathan Lewis, Howard Rogers and my new locker buddy Laurent Schneider. Jeremy Schneider is conspicuously absent, hopefully that gets... [Read More]
What Is NULL?
Today in #oracle, Burk0 asked:<Burk0> mmm... got another problem... I'm using a "insert or update" trigger for my previous task. When I'm inserting a new row, I'd like the varchar field "oldvalue" to report "NA". I put an IF inside the trigger, checking if :old.id=null but that doesn't seem to... [Read More]
Oracle Licensing (or: WTF Partitioning?!)
I came across this post about Oracle partitioning licensing a couple weeks ago (yes I'm catching up with all the blogging). In it, Mathias basically doesn't think that partitioning should be separately licensed at all, and included in ALL versions of Oracle.For those of you who haven't had the pleasure:To... [Read More]