Stored proc running very slow..........
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Stored proc running very slow..........

  1. #1
    Join Date
    Aug 2002
    Posts
    15
    Hi,
    I have a stored proc which is running very slow.The tkprof
    output for the fetch call is

    call count cpu elapsed disk query current rows
    ---- ------ --- ------- ----- ----- ------- ----
    fetch 1 0.48 3.25 1637 1679 4 5



    Kindly give me advice on how to fix this.(like pinning stored proc etc...)

    Regards,
    Sal.


  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Before you start pinning procs in Memory, your first point of calll should be the CODE in the Proc. Find out what is slowing it doen, mybe it's performing a Full Table Scan on a table or something.
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Sep 2000
    Posts
    305
    there might be possible that your query is taking time so just
    execute the statements seperatly from the procedure and then find out which query is taking time


    shailendra

Posting Permissions

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



Click Here to Expand Forum to Full Width