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:23:35 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8879CFE55D5_at_NADCWPMSGCMS10.hca.corpad.net>

I tried setting:
"_serial_direct_read"=TRUE and that does not do it.

First execution = 30s, second execution = 1s on raw devices. Clearly the data is being cached _somewhere_ in the system in this scenario.

Chris

From: Sayan Malakshinov [mailto:xt.and.r_at_gmail.com] Sent: Monday, April 22, 2013 3:16 PM
To: Taylor Christopher - Nashville
Cc: ORACLE-L
Subject: Re: Question - any parameter or hint to FORCE Physical Read (bypass buffer cache)

You can do it, for example, with forcing direct path reads.

--

Best regards,
Sayan Malakshinov
Senior performance tuning engineer
PSBank
http://orasql.org

--

http://www.freelists.org/webpage/oracle-l Received on Mon Apr 22 2013 - 22:23:35 CEST

This message: [ Message body ]
Next message: Alex Fatkulin: "Re: Question - any parameter or hint to FORCE Physical Read (bypass buffer cache)"
Previous message: Sayan Malakshinov: "Re: Question - any parameter or hint to FORCE Physical Read (bypass buffer cache)"
In reply to: Sayan Malakshinov: "Re: Question - any parameter or hint to FORCE Physical Read (bypass buffer cache)"
Next in thread: Alex Fatkulin: "Re: Question - any parameter or hint to FORCE Physical Read (bypass buffer cache)"
Reply: Alex Fatkulin: "Re: Question - any parameter or hint to FORCE Physical Read (bypass buffer cache)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message