RE: Question - any parameter or hint to FORCE Physical Read (bypass buffer cache)
From: <Christopher.Taylor2_at_parallon.net>
Date: Mon, 22 Apr 2013 15:49:27 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8879CFE568C_at_NADCWPMSGCMS10.hca.corpad.net>
Forgot a piece - Yes I knew about the FULL requirements on table/index scans and the query is using a simple full tablescan. Chris
Date: Mon, 22 Apr 2013 15:49:27 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8879CFE568C_at_NADCWPMSGCMS10.hca.corpad.net>
Forgot a piece - Yes I knew about the FULL requirements on table/index scans and the query is using a simple full tablescan. Chris
From: Taylor Christopher - Nashville
Sent: Monday, April 22, 2013 3:48 PM
To: 'Tanel Poder'; Alex Fatkulin
Cc: ORACLE-L
Subject: RE: Question - any parameter or hint to FORCE Physical Read (bypass buffer cache)
The amount of IOs per execution I haven't checked. I should/will check that.
The plans for the query I'm interested in are really simple and are the same on all 3 nodes.
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 22 2013 - 22:49:27 CEST