Home » Database » Oracle Database » PL SQL Native Compilation
PL SQL Native Compilation
754
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
4598
Oracle
category Database » Oracle Database
platform programs at Oracle . are built to Oracle 39 s specifications pre configured and pre tested at Sun and delivered as a .
1572
Oracle Implements NetApp Storage For Its Global IT Infrastructure
category Database » Oracle Database
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 .
1399
CommVault Galaxy Data Protection 6 1 For Oracle Database Systems
category Database » Oracle Database
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 .
2029
Oracle Performance
category Database » Oracle Database
Oracle and related technologies including sample chapters and. code examples. . Apparently Oracle system. performance is a very difficult problem. .
1933
Making Oracle Database 10g R2 Rac Even More Unbreakable
category Database » Oracle Database
history of providing robust cluster platforms for Oracle Real Application Clusters . Insurance Company of China as well as Oracle. .
