-
LOong running query
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|