APPS.ICX_CAT_INTERMEDIA_INDEX_PVT dependencies on V$PARAMETER

Line 331: FROM v$parameter

327: -- Get the parameters to be used for create index to make it faster.
328: -- The SQL to get degree of parallelism is:
329: SELECT MIN(TO_NUMBER(value))
330: INTO l_parallel
331: FROM v$parameter
332: WHERE name IN ('parallel_max_servers', 'cpu_count');
333:
334: l_err_loc := 1500;
335: -- The SQL to get memory / worker is:

Line 338: FROM v$parameter sys_params, ctx_parameters ctx_params

334: l_err_loc := 1500;
335: -- The SQL to get memory / worker is:
336: SELECT ROUND(LEAST((LEAST(2147483648 , TO_NUMBER(sys_params.value)/3) / l_parallel), ctx_params.par_value) / 1048576)
337: INTO l_mem
338: FROM v$parameter sys_params, ctx_parameters ctx_params
339: WHERE sys_params.name IN ('pga_aggregate_target')
340: AND ctx_params.par_name = 'MAX_INDEX_MEMORY';
341: EXCEPTION
342: WHEN OTHERS THEN