Category Archives: Uncategorized

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 →