[Home] [Help]
1126: IF (l_parallel IS NOT NULL and l_parallel > 0) THEN
1127: return l_parallel;
1128: END IF;
1129:
1130: /* Not set by customer, so query v$pq_sysstat */
1131:
1132: begin
1133:
1134: select value INTO l_parallel
1131:
1132: begin
1133:
1134: select value INTO l_parallel
1135: from v$pq_sysstat where trim(statistic) = 'Servers Idle';
1136:
1137: exception when no_data_found then
1138: l_parallel := 1;
1139: end;