RE: sreadtim and mreadtim < 1ms
From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Wed, 4 Nov 2009 12:10:12 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E112E6AFFC7_at_ONEWS06.oneneck.corp>
Good idea, thanks. I'll give it a try with one modification - I'll just flush the Oracle and Linux buffer caches prior to testing rather than waiting for a day. I've got a test server identical to the production server where I can do this without affecting performance for the users. I suppose I might still get some caching at the SAN level, so if I still get unrealistic numbers, then I'll try waiting a while since I don't have access to flush the SAN cache.
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.
Date: Wed, 4 Nov 2009 12:10:12 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E112E6AFFC7_at_ONEWS06.oneneck.corp>
Good idea, thanks. I'll give it a try with one modification - I'll just flush the Oracle and Linux buffer caches prior to testing rather than waiting for a day. I've got a test server identical to the production server where I can do this without affecting performance for the users. I suppose I might still get some caching at the SAN level, so if I still get unrealistic numbers, then I'll try waiting a while since I don't have access to flush the SAN cache.
Regards,
Brandon
From: Michael Wehrle [mailto:michaelw436_at_gmail.com]
. . . create a set of large tables . . .
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 04 2009 - 13:10:12 CST