Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    46

    Unanswered: Performance problem

    Hi,

    I have one function which returns ref cursor. The function seem to perform well. I generated TKPROF, and also logged start & end timestamp in a table from begining & end of the function. It looks perfectly ok. But When I run this function 50 times in a second. The CPU goes 100%. I increased SGA size, it did not help. I was using union at one place, I changed it to union all, but that did not help either. What could be the problem?

    Thanks

    Prashant

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Perhaps the SQL takes 0.02 CPU seconds or more to run each time?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •