Hi Mladen,
The table is not cached.
Thanks
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Gogala, Mladen
Sent: Saturday, August 14, 2021 3:32 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: [EXTERNAL] Re: Strange query behavior
CAUTION: External source
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<https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdbwhisperer.wordpress.com%2F&data=04%7C01%7Camir.hameed%40sleepnumber.com%7Cc53a70f9ee964610121d08d95f5a2da6%7Ced8aabd514de49829fb6d6528851af5e%7C0%7C0%7C637645664228446165%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=iAM2D39%2FcNZrBoYdzdLxeHktuX3V6KH%2FdY7ecL6BFbY%3D&reserved=0>