In this recipe, we will see how to instruct the database to compile our stored procedures in native form—rather than interpreted—to speed up the execution time.
To be sure that our database is not using native compilation by default, we can execute the following command from a SQL*Plus Session:
SHOW PARAMETER PLSQL_CODE_TYPE
If the result is
NATIVE, we can execute the following statement to return to the original default value:
ALTER SYSTEM SET PLSQL_CODE_TYPE = INTERPRETED;
The following steps will demonstrate how to use native compilation:
C_N_K, which calculates the number of k-combinations in a set of n elements:
CREATE OR REPLACE ...