620:
621: l_rows_processed INTEGER;
622:
623: -- Limit the indexing memory in case the default parameter max value is higher.
624: --l_Index_Memory ctx_parameters.par_value%TYPE := '67108864'; -- '64M'
625: l_Index_Memory ctx_parameters.par_value%TYPE := '134217728'; -- '128M'
626: l_Index_Memory_Max ctx_parameters.par_value%TYPE;
627:
628: l_idx_docid_count NUMBER;
621: l_rows_processed INTEGER;
622:
623: -- Limit the indexing memory in case the default parameter max value is higher.
624: --l_Index_Memory ctx_parameters.par_value%TYPE := '67108864'; -- '64M'
625: l_Index_Memory ctx_parameters.par_value%TYPE := '134217728'; -- '128M'
626: l_Index_Memory_Max ctx_parameters.par_value%TYPE;
627:
628: l_idx_docid_count NUMBER;
629: l_idx_status VARCHAR2(256);
622:
623: -- Limit the indexing memory in case the default parameter max value is higher.
624: --l_Index_Memory ctx_parameters.par_value%TYPE := '67108864'; -- '64M'
625: l_Index_Memory ctx_parameters.par_value%TYPE := '134217728'; -- '128M'
626: l_Index_Memory_Max ctx_parameters.par_value%TYPE;
627:
628: l_idx_docid_count NUMBER;
629: l_idx_status VARCHAR2(256);
630:
773:
774: -- Determine indexing memory limit parameter value
775: BEGIN
776: SELECT par_value INTO l_Index_Memory_Max
777: FROM ctx_parameters
778: WHERE par_name = 'MAX_INDEX_MEMORY';
779: EXCEPTION
780: WHEN no_data_found THEN
781: Log_Line (l_api_name || ': Error: MAX_INDEX_MEMORY parameter record not found.');