DBA Data[Home] [Help]

APPS.ICX_CAT_INTERMEDIA_INDEX_PVT dependencies on CTX_PARAMETERS

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