spool spools/deterministic_ssc_&2-&1.sql
alter session set "_query_execution_cache_max_size" = &1;
col postfix new_val postfix noprint
select '&2'||'_'||'&1' postfix from dual;
---- Test for 1-&2,1-&2 - SSC
truncate table t_params;
exec dbms_application_info.set_client_info(0);
select 
  sum((select 1 from dual where f_ssc(n)=1)) ssc
from 
  xmltable('1 to &2, 1 to &2' 
           columns n int path '.'
          );
create table t_params_ssc_&postfix as select * from t_params;
---- Test for 1-&2,1-&2 - Deterministic
truncate table t_params;
exec dbms_application_info.set_client_info(0);
select 
  sum(f_deterministic(n)) fd
from 
  xmltable('1 to &2, 1 to &2' 
           columns n int path '.'
          );
create table t_params_dtrm_&postfix as select * from t_params;
spool off