Skip to content

Tag Archives: Oracle

SQL Plan Stability and CBO Statistics Myths Busted

Carlos Sierra: Since lack of Histograms or freezing CBO Statistics do not guarantee Plan Stability, do not rely on these two myths. If what you are looking for is Plan Stability use then SQL Plan Management available since 11g or SQL Profiles available from 10g. ★ © Eddie Awad’s Blog, 2013. | Permalink | Add [...]★

Posted 14 May 2013 † Eddie Awad § Oracle § Uncategorized ‡ Comments Off ° Also tagged:

Logger: a PL/SQL Logging and Debugging Framework

Martin D’Souza: Logger is a PL/SQL logging and debugging framework. It’s used in many organizations to instrument code in their Oracle applications. Tyler Muth created Logger a few years ago and has since released several upgrades, the last being 1.4.0. After some great feedback, I’m pleased to announce that we’ve just launched Logger 2.0.0 Beta. Instrumentation, logging [...]★

Posted 06 May 2013 † Eddie Awad § Oracle § Uncategorized ‡ Comments Off ° Also tagged: ,

Not a Fan of Public Synonyms, Here is Why

Tom is not not a fan of public synonyms, here is why: public synonyms pollute the namespace. public synonyms can lead to security issues. public synonyms can lead to a maintenance headache. public synonyms are public – no one owns them. So, instead of public synonyms… Continue reading… © Eddie Awad’s Blog, 2013. | Permalink [...]★

Posted 04 May 2013 † Eddie Awad § Oracle § Uncategorized ‡ Comments Off ° Also tagged:

When You Should Consider Flash for Database Storage

@flashdba: If any of this is ticking boxes for you, it’s time to consider what flash could do for the performance of your database: I/O wait times are high. Essentially we are looking for high latency from the existing storage system. Flash memory systems should deliver I/O with sub-millisecond latency, so if you see an [...]★

Posted 30 April 2013 † Eddie Awad § Oracle § Uncategorized ‡ Comments Off ° Also tagged: , ,