 |
|
Oracle Tips by Burleson |
Oracle 10g plsql_code_type
Parameter type – String
Syntax – plsql_code_type = {INTERPRETED |
NATIVE}
Default value – INTERPRETED
Modifiable – ALTER SESSION, ALTER SYSTEM
plsql_code_type specifies
the compilation mode for PL/SQL library units.
Values:
-
INTERPRETED – PL/SQL library units will be
compiled to PL/SQL bytecode format. The PL/SQL interpreter
engine executes such modules.
-
NATIVE – PL/SQL library units
(with the possible exception of top-level anonymous PL/SQL
blocks) will be compiled to native (machine) code. Such modules
will be executed natively without incurring any interpreter
overhead.
When the value of this parameter is changed, it
has no effect on PL/SQL library units that have already been
compiled. The value of this parameter is stored persistently with
each library unit. If a PL/SQL library unit is compiled native, all
subsequent automatic recompilations of that library unit will use
native compilation.
Get the complete Oracle10g story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details:
http://www.dba-oracle.com/service_oracle_backup.htm
|
