Hi Guys,

Could you tell me why this query is taking so long t run?

DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN FND_SVC_COMPONENT.EXECUTE_REQUEST (p_component_request_id => 10000); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END


CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total DB Time
66,890 73,383 6 11,148.26 8.3