Databases Reference
In-Depth Information
In step 4, we execute the
STRESS
procedure with a value of 100000 for its
ANUM
parameter,
obtaining the results shown in the following screenshot:
In step 5, we change a parameter in the current session—the same statement can be
executed, with the necessary grants, to change the parameter in the whole system—to
enable the native compilation of PL/SQL.
In step 6, we create the function
C_N_K
again—with the native compilation enabled—and
in step 7 we create the procedure
STRESS
.
In step 8, we execute the
STRESS
procedure as in step 4, obtaining the following result:
In step 9, we alter our session parameter
PLSQL_CODE_TYPE
again to reset the default
behavior and drop the
C_N_K
function and
STRESS
procedure.