Tuning a stored procedure

[raviva]

Hi,

This is Ravi again. We have some jobs running in Oracle 9i. We have that stored procedures in TOAD. Right now we are expreriencing a degration in the performance of the procedure. It is taking unusually long time to run. Can you please direct me in this issue on how to improve the performance level.

Thanks,
Ravi

[Saii]

This is a very generic statement. please elaborate about the SQL, objects etc you are using.
Meanwhile, check the SQL in procedure and run an explain plan on it for initial analysis of low response time.