DBA Data[Home] [Help]

APPS.CS_SR_SYNC_INDEX_PKG dependencies on V$PARAMETER

Line 350: SELECT to_number(nvl(VALUE, 0)) INTO l_worker FROM v$parameter

346: FUNCTION get_max_parallel_worker RETURN NUMBER
347: IS
348: l_worker NUMBER := 0;
349: BEGIN
350: SELECT to_number(nvl(VALUE, 0)) INTO l_worker FROM v$parameter
351: WHERE NAME = 'job_queue_processes';
352:
353: RETURN l_worker;
354: EXCEPTION