TKPROF interpretation - High cpu and high consistency reads on simple DELETE statement

Hi,

We have one application responsible for cleaning up (deleting) rows in "work tables" once the application processing has completed.

It appears that the Oracle session of this application is CPU intensive and performs poorly, to the point that the items to be processed pile up waiting to be deleted.

Below is an extract of the TKPROF report of the session of this application (trace taken over a span of a few minutes), ordered by EXECPU:

SQL ID: 9knawpyjd5d8b Plan Hash: 1781080856

DELETE FROM TMP_DB.PROCESSINGTABLE
WHERE OID = :1

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------