PLSQL_OPTIMIZE_LEVEL

原创 2008年10月03日 10:45:00
PLSQL_OPTIMIZE_LEVEL specifies the optimization level that will be used to compile PL/SQL library units. The higher the setting of this parameter, the more effort the compiler makes to optimize PL/SQL library units.
Values:
0
Maintains the evaluation order and hence the pattern of side effects, exceptions, and package initializations of Oracle9i and earlier releases. Also removes the new semantic identity of BINARY_INTEGER and PLS_INTEGER and restores the earlier rules for the evaluation of integer expressions. Although code will run somewhat faster than it did in Oracle9i, use of level 0 will forfeit most of the performance gains of PL/SQL in Oracle Database 10g.
1
Applies a wide range of optimizations to PL/SQL programs including the elimination of unnecessary computations and exceptions, but generally does not move source code out of its original source order.
2
Applies a wide range of modern optimization techniques beyond those of level 1 including changes which may move source code relatively far from its original location.
Generally, setting this parameter to 2 pays off in better execution performance. If, however, the compiler runs slowly on a particular source module or if optimization does not make sense for some reason (for example, during rapid turnaround development), then setting this parameter to 1 will result in almost as good a compilation with less use of compile-time resources.
The value of this parameter is stored persistently with the library unit.

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

参数 PLSQL_OPTIMIZE_LEVEL

196. QUESTION 32 In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. Wh...
  • xiadingling
  • xiadingling
  • 2012年12月19日 11:05
  • 1055

PLSQL_OPTIMIZE_LEVEL

PLSQL_OPTIMIZE_LEVEL specifies the optimization level that will be used to compile PL/SQL library u...
  • firefoxboy
  • firefoxboy
  • 2008年10月03日 10:45
  • 733

批量SQL操作之批量获取

PL/SQL中的批量操作,能一次操作和处理许多行,而不是一次一行。批量获取操作是指一次调用把数据库一组行读入PL/SQL结构中,而不是每读入一行就要发起一次对数据库的调用。...
  • u010035907
  • u010035907
  • 2016年02月29日 18:43
  • 1509

参数 PLSQL_OPTIMIZE_LEVEL .

QUESTION 32 In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What wo...
  • kai27ks
  • kai27ks
  • 2013年01月25日 11:04
  • 919

oracle+PLSQL 的安装与卸载

安装:卸载: plsql配置
  • u014523777
  • u014523777
  • 2016年12月01日 14:14
  • 3248

oracle+plsql的配置

1、oracle 11g的安装与卸载 卸载:                plsql的环境变量配置: tnsnames.ora: vvvv...
  • u014523777
  • u014523777
  • 2016年10月23日 18:06
  • 136

Oracle 关键字(保留字) 大全

Oracle 关键字(保留字) 大全 其实这个东西可以在oracle 上输入一个sql语句就可以得到: select * from v$reserved_words order by keywor...
  • pingyan158
  • pingyan158
  • 2013年01月31日 14:00
  • 24990

Oracle PL/SQL 概述

官网的链接:Overview of PL/SQLhttp://docs.oracle.com/cd/E11882_01/appdev.112/e25519/overview.htm Server-Si...
  • tianlesoftware
  • tianlesoftware
  • 2011年12月27日 20:54
  • 4777

plsql导入excel时无odbc importer中无dsn选项

导入win10 plsql 导入excel ,odbc importer中没选项, 解决办法, 控制面板->管理工具->  ODBC 数据源(32 位)->系统dsn->添加相应的驱动...
  • gaixiaojiejia
  • gaixiaojiejia
  • 2018年02月04日 11:44
  • 40

plsql的例子(2)

5、 编写一个程序块,利用%type属性,接受一个雇员号,从emp表中显示该雇员的整体薪水(即,薪水+佣金) SET SERVEROUTPUT ON DECLARE v_empno emp.empno...
  • Jacinthe7064
  • Jacinthe7064
  • 2009年10月13日 20:17
  • 513
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:PLSQL_OPTIMIZE_LEVEL
举报原因:
原因补充:

(最多只允许输入30个字)