[20211116]plsql_code_type=native补充.txt

[20211116]plsql_code_type=native补充.txt --//以前曾经测试过设置plsql_code_type=native会编译的过程和包在/dev/shm,补充一些测试： 1.环境： SCOTT@book> @ ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production SCOTT@book>  show parameter plsql NAME                   TYPE      VALUE ---------------------- --------- -------------- plsql_ccflags          string plsql_code_type        string    INTERPRETED plsql_debug            boolean   FALSE plsql_optimize_level   integer   2 plsql_v2_compatibility boolean   FALSE plsql_warnings         string    DISABLE:ALL 2.测试： SCOTT@book> alter session set plsql_code_type=native ; Session altered. SCOTT@book> select * from dba_plsql_object_settings where plsql_code_type = 'NATIVE'; no rows selected --//当前没有编译的报是类型NATIVE。 create or replace package bla as   procedure foo; end; / create or replace package body bla as   procedure foo is begin null; end; end; / SCOTT@book> select * from dba_plsql_object_settings where plsql_code_type = 'NATIVE'   2  @ prxx ============================== OWNER                         : SCOTT NAME                          : BLA TYPE                          : PACKAGE PLSQL_OPTIMIZE_LEVEL          : 2 PLSQL_CODE_TYPE               : NATIVE PLSQL_DEBUG                   : FALSE PLSQL_WARNINGS                : DISABLE:ALL NLS_LENGTH_SEMANTICS          : BYTE PLSQL_CCFLAGS                 : PLSCOPE_SETTINGS              : IDENTIFIERS:NONE ============================== OWNER                         : SCOTT NAME                          : BLA TYPE                          : PACKAGE BODY PLSQL_OPTIMIZE_LEVEL          : 2 PLSQL_CODE_TYPE               : NATIVE PLSQL_DEBUG                   : FALSE PLSQL_WARNINGS                : DISABLE:ALL NLS_LENGTH_SEMANTICS          : BYTE PLSQL_CCFLAGS                 : PLSCOPE_SETTINGS              : IDENTIFIERS:NONE PL/SQL procedure successfully completed. --//可以通过视图确定那些包编译是NATIVE的。 $ ls -l /dev/shm/ total 4 -rwx------ 1 oracle oinstall 424 2021-11-16 09:39:36 PESLD_book_32d0004_082c567c00000000 --//java类通过native编译可以通过如下查询。 select * from dba_java_methods where is_native = 'YES' ; --//或者查询: select * from sys.ncomp_dll$ n, dba_objects o where n.obj# = o.object_id;