Parallel Query change from smart scan to cell single block access
From: Ls Cheng <exriscer_at_gmail.com>
Date: Wed, 15 Jun 2022 00:26:17 +0200
Message-ID: <CAJ2-Qb8wUxHRbCMzthu_qPMUCrgJOZXyZOgg7w-8BnaTMeQWiQ_at_mail.gmail.com>
Hi all
Date: Wed, 15 Jun 2022 00:26:17 +0200
Message-ID: <CAJ2-Qb8wUxHRbCMzthu_qPMUCrgJOZXyZOgg7w-8BnaTMeQWiQ_at_mail.gmail.com>
Hi all
I have a strange situation where a very simple query (no join, a single FROM table) sometimes is fast (seconds) and sometimes slow (hours). After digging a bit It seems that one of PQ slave instead of accessing the table using cell smart table scan is accessing by cell single blocks.
This is 19.10, has anyone observed or faced such a problem?
Thanks
--http://www.freelists.org/webpage/oracle-l Received on Wed Jun 15 2022 - 00:26:17 CEST