Skip to content

Tag Archives: performance

gather_plan_statistics – 2

Some time ago – actually a few years ago – I wrote a note about the hint /*+ gather_plan_statistics */ making some informal comments about the implementation and relevant hidden parameters. I’ve recently discovered a couple of notes from Alexander Anokhin describing the feature in far more detail and describing some of the misleading side […]

Posted 22 May 2013 † Jonathan Lewis § Oracle § Uncategorized ‡ Comments Off ° Also tagged:

High Performance Tuning Tools

Performance Tuning

Obligatory Melodrama No matter how much time goes by I still remember it. The day my database was crippled beyond reckoning. That moment when I saw my hopes for a bright and shining future with my database spill through my fingers like so many cracker crumbs falling on a clean and well pressed pair of [...]

The post High Performance Tuning Tools appeared first on Steve Karam :: The Oracle Alchemist.

Posted 21 May 2013 † The Oracle Alchemist § Oracle § Uncategorized ‡ Comments Off ° Also tagged:

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:

Parse Time

Dominic Brooks published a note recently about some very nasty SQL – originally thinking that it was displaying a run-time problem due to the extreme number of copies of the lnnvl() function the optimizer had produced. In fact it turned out to be a parse-time problem rather than a run-time problem, but when I first read … … Continue reading →

Posted 13 May 2013 † Jonathan Lewis § Oracle § Uncategorized ‡ Comments Off ° Also tagged:

SLOB

Anyone who has used Kevin Closson’s “Silly Little Oracle Benchmark” will want to know about his significantly updated SLOB2.

Posted 05 May 2013 † Jonathan Lewis § Oracle § Uncategorized ‡ Comments Off ° Also tagged: