Re: Strange query behavior

From: "Gogala, Mladen" <gogala.mladen@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Sat, 14 Aug 2021 15:31:49 -0400

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

Follow-Ups:
- RE: [EXTERNAL] Re: Strange query behavior
  - From: Hameed, Amir

References:
- Strange query behavior
  - From: Hameed, Amir

Other related posts:

» Strange query behavior- Hameed, Amir
» Re: Strange query behavior- Jonathan Lewis
» Re: Strange query behavior - Gogala, Mladen