in case of store procedure ,u can keep the pkg in shared pool using dbms_shared_pool . performance will be better.