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.