1. 首页
  2. IT资讯

PLSQL_CODE_TYPE

http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10755/initparams158.htm[@more@]

PLSQL_CODE_TYPE

PropertyDescription
Parameter typeString
SyntaxPLSQL_CODE_TYPE = { INTERPRETED | NATIVE }
Default valueINTERPRETED
ModifiableALTER 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. 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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/450962/viewspace-1027864/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/194774.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code