PL SQL Native Compilation
Category : Database » Oracle Database
with Oracle 9i , PL/SQL program units can be compiled to native . Procedural logic like IF/THEN , loops and jumps bypass Oracle's. PL/SQL byte code interpreter. .
Download File
Free PDF eBooks Download
Database
Oracle Database
Content Summary :
PL/SQL Native Compilation When a PL/SQL program unit is loaded into the server , it is compiled to byte codewhich is stored in the database and interpreted at run-time by a virtual machine implemented within Oracle which in turn runs natively on the given platform. Starting with Oracle 9i , PL/SQL program units can be compiled to native code shared libraries , which are linked into the kernel resulting in performance increase for the procedural code. Native Compilation results faster execution of PL/SQL program units like stored procedures , functions packages , triggers. This improvement in the execution speed is due to the following factors: -Elimination of the overhead associated with interpreting byte code. -Better, faster Control flow in native code than in interpreted code. The compiled code corresponds to PGA as opposed to SGA
Favorite Oracle Database PDF File
platform programs at Oracle . are built to Oracle 39 s specifications pre configured and pre tested at Sun and delivered as a .
Fortune 500 company Oracle has annual. revenues in excess of 9 billion and over . OEBSOD Oracle hosts its industry leading E Business Suite software for .
Oracle database systems are at the core of key. business operations and activities. . Oracle data is often the most critical part of an IT. team 39 s .
Oracle and related technologies including sample chapters and. code examples. . Apparently Oracle system. performance is a very difficult problem. .
history of providing robust cluster platforms for Oracle Real Application Clusters . Insurance Company of China as well as Oracle. .