APPS.ICX_CAT_INTERMEDIA_INDEX_PVT dependencies on V$PARAMETER

Line 340: FROM v$parameter

336: -- Get the parameters to be used for create index to make it faster.
337: -- The SQL to get degree of parallelism is:
338: SELECT MIN(TO_NUMBER(value))
339: INTO l_parallel
340: FROM v$parameter
341: WHERE name IN ('parallel_max_servers', 'cpu_count');
342:
343: l_err_loc := 1500;
344: -- The SQL to get memory / worker is:

Line 347: FROM v$parameter sys_params, ctx_parameters ctx_params

343: l_err_loc := 1500;
344: -- The SQL to get memory / worker is:
345: SELECT ROUND(LEAST((LEAST(2147483648 , TO_NUMBER(sys_params.value)/3) / l_parallel), ctx_params.par_value) / 1048576)
346: INTO l_mem
347: FROM v$parameter sys_params, ctx_parameters ctx_params
348: WHERE sys_params.name IN ('pga_aggregate_target')
349: AND ctx_params.par_name = 'MAX_INDEX_MEMORY';
350: EXCEPTION
351: WHEN OTHERS THEN