Re: SQL running very slow
From: Andy Sayer <andysayer_at_gmail.com>
Date: Mon, 25 Oct 2021 18:30:23 +0100
Message-ID: <CACj1VR7G8CtEXMmYO1C-4onjdyYM+Rq9=kDQZgWzYrvXT4exuQ_at_mail.gmail.com>
Date: Mon, 25 Oct 2021 18:30:23 +0100
Message-ID: <CACj1VR7G8CtEXMmYO1C-4onjdyYM+Rq9=kDQZgWzYrvXT4exuQ_at_mail.gmail.com>
Hi Amit,
You are doing a nested loop full index scan. Either get it to do that as a
hash join or find it a better index which can be accessed with the join
predicates.
Thanks,
On Mon, 25 Oct 2021 at 18:15, Amit Saroha <eramitsaroha_at_gmail.com> wrote:
> Hi Listers,
Andy
>
> Database version - 12.0.1
>
> I have a query that is running from long but couldn't understand the
> reason for the long run. I have enclosed the SQL monitoring and SQL plan
> for reference.
>
> In LongOps it shows its reading blocks but doesn't know why reading is so
> slow. Could you please suggest what could cause such an issue?
>
>
> Best Regards,
> AMIT
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 25 2021 - 19:30:23 CEST