Welcome, Guest
Username: Password: Remember me

TOPIC: How to reduce parse time

How to reduce parse time 3 years 2 months ago #261

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?

Thanks
Amir
The administrator has disabled public write access.

Re:How to reduce parse time 3 years 5 days ago #276

  • Jeff Holt
  • Jeff Holt's Avatar
  • OFFLINE
  • Posts: 103
  • Thank you received: 2
Sorry for the delay.

I'm pretty sure that you might get some benefit by doing something like this after instance startup:
SQL> alter package body x compile;
SQL> exec dbms_shared_pool.keep('x') -- which may not be required
HTH
Last Edit: 3 years 5 days ago by Ron Crisco. Reason: removing smiley
The administrator has disabled public write access.

Re:How to reduce parse time 2 years 11 months ago #283

Hey Jeff - what do you think about using the SQL Plan management: dbms_spm?

Steve
The administrator has disabled public write access.