sql - Is procedures should be removed after use? -


i have many procedures in database execute every night (with cron) batch runs sql*plus , run them.

so question is, best practice between :

  1. create, execute , drop procedures batch
  2. let procedures in database, , execute them

the best practice leave stored procedures in database , execute them. allows server cache execution plan, more importantly allows run cron job limited user privileges requiring execute permissions. first option requires permissions drop , edit procedures , not idea, if production server. bug in code result in other procedures unrelated cron job being dropped.


Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -