Update: In Oracle 11g upwards you can use V$DIAG_INFO for getting your own session’s trace file name too (diag.sql script). But on earlier versions or if you want to see the current tracefile name of another, you still need to … 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