Category Archives: Uncategorized

If you use DBMS_STATS.GATHER_SCHEMA_STATS or DBMS_STATS.GATHER_DATABASE_STATS with options=> ‘GATHER AUTO’ then the preferences for the tables whose statistics are gathered are ignored. See this testcase which includes a SQL*Plus script and log demonstrating that GATHER_SCHEMA_STATS  ignores a preference.  I’ve seen the … Continue reading →

These are two Oracle Database usergroup presentations that I have done related to Oracle performance tuning.  Each has a Powerpoint presentation and a Word document. First usergroup presentation – Profile of waitsand cpu First usergroup paper – Profile of waits and … Continue reading →

We starting seeing a ton of these waits on an Exadata system: cell single block physical read Normally the predominant wait is cell smart table scan Simple table full scans were doing the single block reads, whereas they normally would … Continue reading →

We are hitting this bug: Bug 6510615  REF CURSOR opened by PLSQL does not use session cursor cache An application I work on does a ton of executions of packages with cursor variables returning ref cursors.  Apparently the session cursor cache … Continue reading →