优化与调整plsqlnativecompilation说明.docxVIP

相关概述在之前的Bulk的那篇blog里提到了Oracle 的2个引擎：PL/SQL 引擎和SQL 引擎。Oracle PL/SQL 优化与调整 -- Bulk 说明/tianlesoftware/article/details/Oracle?使用2个引擎来执行SQL和代码块：SQL?引擎和PL/SQL?引擎，?Oracle?使用这2个引擎来执行PL/SQL blocks?和?subprograms。那么在执行的时候，PL/SQL?引擎把DML?语句发送给SQL?引擎，然后由SQL?引擎执行，执行完毕后，SQL?引擎把结果集在发送给PL/SQL?引擎。因此在不同引擎之间切换就需要进行context switch，过多的context switch是会影响SQL性能的。而bulk?就是从减少引擎之间context switches的方式来提高sql的效率。?把对SQL?进行打包处理。?这里看另一个处理角度，使用PL/SQL Native Compilation(PL/SQL的本地编译)。官网的链接如下：PL/SQL Native Compilation/cd/E11882_01/server.112/e23633/changes.htm#UPGRD12523Compiling PL/SQL Units for Native Execution/cd/E11882_01/appdev.112/e25519/tuning.htm1.1 PL/SQL Native CompilationStarting with Oracle Database 10g?Release 1 (10.1), the configuration of initialization parameters and the command setup for native compilation has been simplified. The important parameters now arePLSQL_NATIVE_LIBRARY_DIR?and?PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT. The parameters related to the compiler, linker, and make utility have been made obsolete. Native compilation is turned on and off by a separate initialization parameter,?PLSQL_CODE_TYPE, rather than being one of several options in the?PLSQL_COMPILER_FLAGS?parameter, which is now deprecated. The?spnc_commands?file, located in theORACLE_HOME/plsql directory, contains the commands and options for compiling and linking, rather than a makefile.--在Oracle 10g以后，配置native compilation 相对简单很多，最重要的参数是：PLSQL_NATIVE_LIBRARY_DIR?和?PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT. 关联complier，linker 的参数已经过期。 Native compilation 通过一个PLSQL_CODE_TYPE 参考来控制启动和关闭。在10g 之前是使用PLSQL_COMPILER_FLAGS参数。spnc_commands?文件存在ORACLE_HOME/plsql目录下。如：[oracle@rac1 plsql]$ pwd/u01/app/oracle/product/10.2.0/db_1/plsql[oracle@rac1 plsql]$ lsadmin include lib mesg public spnc_commands[oracle@rac1 plsql]$ lltotal 24drwxr-x--- 2 oracle oinstall 4096 Mar 22 2011 admindrwxr-x--- 2 oracle oinstall 4096 Mar 22 2011 includedrwxr-x--- 2 oracle oinstall 4096 May 12 2011 libdrwxr-x--- 2 oracle oinstall 4096 Mar 22 2011 mesgdrwxr-x