RE: [EXTERNAL] Re: Strange query behavior
Date: Sat, 14 Aug 2021 22:03:08 +0000
Message-ID: <CH0PR14MB5012DB56DC388F7E32742E4BE0FB9_at_CH0PR14MB5012.namprd14.prod.outlook.com>
Hi Mladen,
The table is not cached.
Thanks
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Gogala, Mladen
Sent: Saturday, August 14, 2021 3:32 PM
To: oracle-l_at_freelists.org
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>
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Aug 15 2021 - 00:03:08 CEST