ASMM Pitfalls

Earlier this month, Jonathan Lewis revisited an earlier post of his about the problems of automatic SGA management. It was a great read, and one all too near to (and a wound so fresh in) my heart. I've yet to actually find a bug number to confirm the suggestion, other... [Read More]

Feuerstein on Error Tracing

I'm still catching up on some readme bookmarks, and find myself once again face-to-face with PL/SQL sensei Steven Feuerstein. This man has some of the best headshots I've ever seen.This time Steven is dropping some science regarding the DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function, new in Oracle 10g, for better exception handling in PL/SQL.... [Read More]


Found this from Tom Kyte. The subject alone tells everyone that this dude is serious and you are lucky to even have the chance to help him: URGENT URGENT PLZ READ B4 OTHERS VERY URGENT NO TIME WASTERSThe poster uses an perfect storm of IM speak, arrogance, stupidity, and the... [Read More]
Tags: help oracle

Oracle PL/SQL Best Practices and Common Mistakes

Eddie Awad dug up some videos from Quest Software of PL/SQL-god and Borat-hater Steve Feuerstein talking about the best and worst of PL/SQL programming.The videos offer some tasty advice, including tips on writing cleaner, more modular code, and use of BULK COLLECT and FORALL to improve mass data processing performance,... [Read More]

Quick Review of Oracle on CentOS (RHEL) 5

Hampus Linden, the Swedish werewolf in London, has posted a light review of Oracle on CentOS 5, the latest release to match the new RedHat Enterprise Linux 5. CentOS is basically RHEL without the paid support, great for testing/development environments.