Re: Slow Update

Hello,

1. I would start by running dbms_sqltune for that sql_id "1fw8tsdwvmg0g".
2. Is this a big table "po_line_locations"?
3. Can you increase the size of the SGA? To help reduce wait time: db file scattered read.
4. Test create an index for this predicate because this is the part that presents the highest cost for execution:

( "ORG_ID" = TO_NUMBER ( sys_context('multi_org2', 'current_org_id') )
AND nvl("CLOSED_CODE", 'OPEN') <> 'FINALLY CLOSED'
AND nvl("CANCEL_FLAG", 'N') = 'N')

5. If the use of this table is constant, check the buffer availability and test changing the table's buffer_pool to "keep".

Some other things can be done, and these are just a few...

Att.

*Juliano Ribeiro*
http://linkedin.com/in/supernoi <http://br.linkedin.com/in/supernoi>

Em qui., 2 de nov. de 2023 às 16:38, Amit Saroha <eramitsaroha_at_gmail.com> escreveu:

> Hi All,
>
> We have an issue where users are taking a long time to cancel a purchase
> order line. Using AH data, I was able to identify one of the queries that
> was taking a while in this procedure. I've attached the monitoring report
> for your perusal, and I ask that you let me know if you have any
> suggestions on how to make the query run better.
>
> I appreciate your support and assistance in advance.
>
>
> Best Regards,
> AMIT
>

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