Re: SQL running very slow

From: Amit Saroha <eramitsaroha_at_gmail.com>
Date: Mon, 25 Oct 2021 13:37:18 -0400
Message-ID: <CAG67e6TEKHK=8PNu41YYcabSzePKH1WXpo2L5HJ=S1Dv-9wENw_at_mail.gmail.com>



Thanks, Andy.

I can't cancel the query or kill the session to inject hints because it's part of a batch and more processes has to complete after this query. Is it possible to do some workaround?

Best Regards,
AMIT On Mon, Oct 25, 2021 at 1:30 PM Andy Sayer <andysayer_at_gmail.com> wrote:

> 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,
> Andy
>
> On Mon, 25 Oct 2021 at 18:15, Amit Saroha <eramitsaroha_at_gmail.com> wrote:
>
>> Hi Listers,
>>
>> 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-l
Received on Mon Oct 25 2021 - 19:37:18 CEST

Original text of this message