LOong running query
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: LOong running query

  1. #1
    Join Date
    Mar 2010
    Location
    Los Angeles
    Posts
    20

    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

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  3. #3
    Join Date
    Mar 2010
    Location
    Los Angeles
    Posts
    20
    Hi,

    It is running for more than 10hrs.

    I did not trace the session. Did the query gives you any valid info?

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  5. #5
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    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.
    http://www.perf-engg.com
    A performance engineering forum

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width