Pls /Sql Native compilation on R12.2 / 11.2.0.4

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Pls /Sql Native compilation on R12.2 / 11.2.0.4

Vithal
Hi,
We have a R12.2.5  / 11.2.0.4 Ebs system.

What are the steps to convert this to Pls/sql native compilation mode from an interepreted mode ?

Regards,
Vithal.
Reply | Threaded
Open this post in threaded view
|

Re: Pls /Sql Native compilation on R12.2 / 11.2.0.4

ErmanArslansOracleBlog
Administrator
well.. you can use  Oracle E-Business Suite 12 PL/SQL database objects natively compiled.
See  "Compiling PL/SQL Program Units for Native Execution" section of Chapter 12 of Oracle Database PL/SQL Language Reference 11g Release 2 (11.2) for this.

Here is the link -> https://docs.oracle.com/cloud/latest/db112/LNPLS/title.htm

Compiling PL/SQL Units for Native Execution ............................................................................ 12-51
Determining Whether to Use PL/SQL Native Compilation .................................................. 12-52
How PL/SQL Native Compilation Works................................................................................ 12-52
Dependencies, Invalidation, and Revalidation......................................................................... 12-53
Setting Up a New Database for PL/SQL Native Compilation............................................... 12-53
Compiling the Entire Database for PL/SQL Native or Interpreted Compilation ............... 12-53