Re: Strange query behavior
From: Gogala, Mladen <gogala.mladen_at_gmail.com>
Date: Sat, 14 Aug 2021 15:31:49 -0400
Message-ID: <7d6edc42-abe2-5a5b-b209-d5d78b3b6142_at_gmail.com>
Date: Sat, 14 Aug 2021 15:31:49 -0400
Message-ID: <7d6edc42-abe2-5a5b-b209-d5d78b3b6142_at_gmail.com>
Is the table cached? Do you have keep pool or big table cache defined?
Regards
On 8/12/2021 11:17 PM, Hameed, Amir wrote:
> I am trying to understand when the statement was run manually and it
> did do FTS of the table, why there were no physical reads reported.
-- Mladen Gogala Oracle DBA Tel: (347) 321-1217 Blog: https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Sat Aug 14 2021 - 21:31:49 CEST