Plan for recursive query
From: Krishnaprasad Yadav <chrishna0007_at_gmail.com>
Date: Mon, 6 Nov 2023 15:23:09 +0530
Message-ID: <CAO8FHeX=iSF5Zomhb11uWAoxQy62S=90qZagdqy=kCWNSoJgLA_at_mail.gmail.com>
Dear Gurus,
Date: Mon, 6 Nov 2023 15:23:09 +0530
Message-ID: <CAO8FHeX=iSF5Zomhb11uWAoxQy62S=90qZagdqy=kCWNSoJgLA_at_mail.gmail.com>
Dear Gurus,
We have isue during mv refresh , we see spike of Cpu waits , we see recursive querys are top waiting for cpu
We see two plan for recursive querys , one is using FTS and other is Index range Scan ,Need to understand , is attaching good plan for recursive query is fine , or it is not good practise to follow for recursive query and does it can creates any issue
Regards,
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 06 2023 - 10:53:09 CET