Whats new in Oracle Database 10g?
This feature now requires less setup and maintenance. • A package body and its spec do not need to be compiled with the same setting for code type. For example, a package body can be compiled natively while the package spec is compiled interpreted. • Natively compiled subprograms are stored in the database, and the corresponding shared libraries are extracted automatically as needed. You do not need to worry about backing up the shared libraries, cleaning up old shared libraries, and so on. • The initialization parameters and command setup for native compilation have been simplified. The only required parameter is plsql_native_library_dir. The parameters related to the compiler, linker, and make utility have been obsoleted. The $ORACLE_HOME/plsql/spnc_commands commands file is used for native compilation. It contains commands and options for compiling and linking. here is no longer a dependency on a make utility. The parameters plsql_native_make_utility and plsql_native_make_file_name
