Enhancements to PL/SQL Native Compilation

This entry is part 6 of 13 in the series New Pl/Sql features 10g

This topic is rather scarcely explained. Simply because it’s part of a much larger topic of native compilation. So the only information here is what has been changed. Showing examples here would be to comprehensive.

With Oracle 10g the configuration of initialization parameters and the command setup for native compilation has been simplified.

  • The only required parameter is PLSQL_NATIVE_LIBRARY_DIR. The parameters related to the compiler, linker, and make utility have been obsoleted.
  • 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 $ORACLE_HOME/plsql/spnc_commands file contains the commands and options for compiling and linking, rather than a makefile. The spnc_commands file.
  • A new script, dbmsupgnv.sql, has been provided to recompile all the PL/SQL modules in a database as NATIVE.
  • The dbmsupgin.sql script recompiles all the PL/SQL modules in a database as INTERPRETED.
  • A package body and its specification do not need to be compiled with the same setting for native compilation.
  • Natively compiled subprograms are stored in the database, and the corresponding shared libraries are extracted automatically as needed.
  • Any errors that occur during native compilation are reflected in the USER_ERRORS dictionary view and by the SQL*Plus command SHOW ERRORS.
Series Navigation<< FORALL Support for Non-Consecutive IndexesAutomatic PL/SQL optimization >>

Posted in Pl/Sql Tagged with: , ,

Leave a Reply