-
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
-
how long?
did you trace the session and see what it is actually doing?
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Hi,
It is running for more than 10hrs.
I did not trace the session. Did the query gives you any valid info?
-
No. only thing we can see is you are executing a pl/sql block. could you please explain what that block suppose to do?
also, please provide Oracle version and operating system details.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
That's a pl/sql what yopu need is the top SQL which is/are causing this.
When you find them, take a trace and see.
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
|