Category Archives: Uncategorized

cell single block physical read

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

Posted in Uncategorized | 15 Comments

Session cursor cache bug results in high latch waits?

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

Posted in Uncategorized | 3 Comments