SQL running very slow

From: Amit Saroha <eramitsaroha_at_gmail.com>
Date: Mon, 25 Oct 2021 13:15:15 -0400
Message-ID: <CAG67e6Quyi1GaU9N-Nhyu7s3nh5000+8wZR=A2CtpBttGO6H6Q_at_mail.gmail.com>

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




text/plain attachment: Sqlm-3zkuqckakdbsb.txt



text/html attachment: sqlm_3zkuqckakdbsb.html



text/plain attachment: Plan-3zkuqckakdbsb.txt

Received on Mon Oct 25 2021 - 19:15:15 CEST

This message: [ Message body ]
Next message: Andy Sayer: "Re: SQL running very slow"
Previous message: Pap: "Re: Question on concurrency waits"
Next in thread: Andy Sayer: "Re: SQL running very slow"
Reply: Andy Sayer: "Re: SQL running very slow"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message