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

From: Fergal Taheny <ftaheny_at_gmail.com>
Date: Mon, 22 Apr 2013 22:12:16 +0100
Message-ID: <CAOuMUT6fiKRJ4WfwoLVXP9H7aA9Omah9XJJev0wy0TCJDowCrw_at_mail.gmail.com>

And when you have a minute,
James Morle is just after publishing 2 super papers that explain IO features really well.

http://www.scaleabilities.co.uk/wp-content/uploads/downloads/2013/04/UKOUG_OracleScene48_OptScanPt1.pdf http://www.scaleabilities.co.uk/wp-content/uploads/downloads/2013/04/UKOUG_Oracle-Scene49_OptScanPt2.pdf

Paper 2 explains how direct path IO works and how it is affected by partially cached tables.

Regards,
Fergal

Fergal Taheny
Pentec IT Limited

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

Received on Mon Apr 22 2013 - 23:12:16 CEST