SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQl query issue

711499Jan 11 2011 — edited Jan 13 2011

Hi all,

The below SQL query ran from an application process it is eating up 30 - 35% of the CPU time.. It executed 134,145,746 times and transferred about 15GB data. The service that runs this process polls the database to get the data but the interval that it runs seems to be excessive..

SELECT    jpt_id, seq_no, card_read
     FROM uttrn
    WHERE uttrn.code = 1 AND uttrn.ptr_read = 'AE'
ORDER BY jpt_id,seq_no

At this point, I'm not able to run a trace on this system it makes it more complicated to see what is wrong..
I would appreciate any feedback on the workarounds for this issue.

Thanks much

Edited by: user10192995 on Jan 11, 2011 5:18 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 10 2011

Added on Jan 11 2011

7 comments

155 views