Re: bloom filter not used after 19C upgrade
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 09 May 2024 08:36:39 -0400
Message-ID: <d8406391e6b6fb7e5a043cf333a42aa0b7fb4437.camel_at_gmail.com>
Date: Thu, 09 May 2024 08:36:39 -0400
Message-ID: <d8406391e6b6fb7e5a043cf333a42aa0b7fb4437.camel_at_gmail.com>
On Thu, 2024-05-09 at 08:30 +0200, Lothar Flatz wrote:
> Malden,
>
> explain plan is out of question. Please stop wasting my time by
> mentioning it.
I mentioned explain plan because Laurentiu mentioned the event 10053. The event 10053 traces oracle optimizer. The SQL executor, which is separate from the CBO, can decide on its own to do or not to do Bloom filter. Consequently, the event 10053 can never show Bloom filters.
-- Mladen Gogala Database SME https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 09 2024 - 14:36:39 CEST