RE: sreadtim and mreadtim < 1ms

From: Allen, Brandon <>
Date: Tue, 3 Nov 2009 15:35:13 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E112E6AF9F1_at_ONEWS06.oneneck.corp>

Hey Rich, please see responses below.


> you're sure that the low values are due to OS caching?

        It's mostly OS caching, but some SAN caching also - either way Oracle's 'physical reads' are very rarely true physical reads so they are almost always occurring in < 1ms

> I tried to see what a 10053 trace says for me, but that info doesn't appear to be available in the trace on 10.1

        It was added in according to Jonathan Lewis' Cost-Based Oracle Fundamentals (p.18)

> It could always be a reporting problem in the trace

        True, I'm doing more testing to see if the values are actually being used or not.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

Received on Tue Nov 03 2009 - 16:35:13 CST

Original text of this message