This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

We are having high memory/cpu wait for a query

Hello,

As per below screenshots, it says the parses are equal to no. of executions. is it referring to hard parse or soft parse?

how can we try to reduce the memory/cpu wait which is huge for this particular query

pastedImage_1.png

pastedImage_0.png

  • Full Table Scan - as the DPA Advice says, probably first thing to look at is whether there are any suitable indexes?  If so, are the table and index statistics up to date?

    If not, can you add a new index or modify an existing index?

    Can the SQL be re-written to be more efficient?

    Have you checked the execution plan?

    It doesn't seem to be bringing lots of data back, so the inefficiency of scanning the entire table to return 1-2 rows per execution is going to be costly (even though it averages about 0.4 seconds per execution).