Stored proc running very slow..........

[Copernicus]

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.

[grjohnson]

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.

[shailendra]

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