You can speed up PL/SQL subprograms by compiling them into native code residing in shared libraries.
You can use native compilation with both the supplied packages and the subprograms you write yourself. Subprograms compiled this way work in all server environments, such as the shared server configuration (formerly known as multithreaded server) and Oracle Real Application Clusters (Oracle RAC).
This technique is most effective for computation-intensive subprograms that do not spend much time executing SQL, because it can do little to speed up SQL statements invoked from these subprograms.
With Java, you can use the ncomp tool to compile your own packages and classes.
|
See Also:
|