query execution time
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: query execution time

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    Hi friends,
    When I execute a procedure from sql plus, it takes approximately 24 minutes for getting the message that the procedure executed successfully. But, it shows that elapsed time is 14 minutes.(i had put the 'set timing on').
    Can someone throw light, why it takes 10 minutes more to get the message than what oracle has actually taken for execution?My guess is, it is something related with server side operation, but I need to get this right before attempting to reduce it.
    Also, I think the execution time includes both parsing and fetching times. In sql worksheet, I get these separately. What is needed to be done to get them separately in sql plus , also?
    My database is 8.1.6 running on a compaq tru64 and is using parallel server option with 2 instances.
    T hanks
    manjunath

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    It could be a network slow down too.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Oct 2000
    Posts
    211
    Thanks Sam,
    but is there a way to find out that the delay is because of network slowdon. And can you suggest how to reduce it?
    The two instances are on two separate boxes and most of the time the activity is heavy insertion of inserts.
    Thanks
    manjunath

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