PLSQL_CODE_TYPE

最新推荐文章于 2024-01-02 15:55:32 发布

原创最新推荐文章于 2024-01-02 15:55:32 发布 · 927 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#library #compilation #exception #each

Oracle 专栏收录该内容

101 篇文章

订阅专栏

本文详细介绍了PL/SQL中的两种编译模式：解释执行模式与本地代码模式。解释执行模式将PL/SQL库单元编译为字节码并由解释器执行；本地代码模式则将库单元直接编译为机器码，执行效率更高。

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. Such modules are executed by the PL/SQL interpreter engine.
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.

本文转自
http://cs.ifmo.ru/~ad/Documentation/oracle-10g-lib-doc/server.101/b10755/initparams158.htm