DBA Data[Home] [Help]

APPS.ICX_CAT_INTERMEDIA_INDEX_PVT dependencies on CTX_PARAMETERS

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