Here’s a code snippet for identifying current tracefile name using SQL. Yep I know there are many such examples online, but I haven’t found any so far which also account for TRACEFILE_IDENTIFIER variable. Luckily the value of this variable is … Continue reading
Monthly Archives: May 2008
My friend asked today a question that how to identify why his Oracle 9.2 database has suddenly started generating loads more redo than usual. So obviously I recommended him Snapper as first thing, it’s perfect for ad-hoc analysis like that! … Continue reading
I have uploaded the slides of my “Performance and Scalalability Improvements in Oracle 10g and 11g” presentation here.
There was a question in a recent Oracle-L thread about various uses of autonomous transactions. Autonomous transactions can be very useful for a PL/SQL application logging, but sometimes they are also abused to cope with bad application design (like avoiding … Continue reading