We have a PL/SQL package that is used by the warehouse scanners when scanning items. After the dabase comes up after the nightly backup, the first execution of the package takes about 4-5 seconds, the subsequent executions are fine. The 4-5 seconds of the first execution time is not acceptable to the business. Is there a way to pre-parse a package/procedure/function before making the first call to execute it?
The administrator has disabled public write access.
Re:How to reduce parse time
5 years 19 hours ago #276