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

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.

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.

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