Re: Request taking long time

Posted by Samia on Feb 20, 2025; 4:18pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Request-taking-long-time-tp12917p12930.html

Hi Erman,

I'm sorry, I miss to give more details about the issue :)

So it's about an EBS r12.2.4 request.

In the AWR released in the exécution time of the request, I deduced the sql_id:

569n2zsswkp8p:

I have done the execution plan for this sql_id however I couldn't see anything :) It's a bit complicated for me to analyze it :)

Anyway, I took the tables in this plan and I rebuilded indexes and I asked the customer to test again. Until now no news, may be it's OK !

Please here you are some informations.

Thanks in advance for your advice.

Regards,
Samia
l42753802.req
explan_plan_569n2zsswkp8p.txt