RE: Question - any parameter or hint to FORCE Physical Read (bypass buffer cache)

  • From: <Christopher.Taylor2@xxxxxxxxxxxx>
  • To: <tanel@xxxxxxxxxxxxxx>, <afatkulin@xxxxxxxxx>
  • Date: Mon, 22 Apr 2013 15:49:27 -0500

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

--
//www.freelists.org/webpage/oracle-l


Other related posts: