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.
 
Search WWH ::




Custom Search