Re: Improve Query sqlm_bshtdhgmsvqad

Hello Amit,

I've been quickly glanced at your SQL monitor report, the most slowest step is on line 81 and next line 59 from execution plan behind column "Activity" (the former occupied 45.09% and the latter spent 42.40%).

Are you having statistics collector this action?

[image: image.png]

[image: image.png]

Best Regards
Quanwen Zhao

Amit Saroha <eramitsaroha_at_gmail.com> 于2024年11月1日周五 23:40写道：

> Hi All,
>
> I have another query which takes hours to run hence I am requesting that
> you check the included SQL monitoring data and let me know if there is
> anything we can do to optimize the run time.
>
> Thank you for your assistance and advice in advance.
>
>
> Best Regards,
> AMIT
>

--
http://www.freelists.org/webpage/oracle-l




image/png attachment: image.png



image/png attachment: image.png