DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    How Oracle Execute

    If I run the procedure from the client connecting to the database server via VPN, it take 10 hours to run but if I run the same procedure at the client site it took only 1 hours, the question is VPN is problem here???? But I thought it doesn't matter where I kid off the procedure since the process resides and run right on the database server.

  2. #2
    Join Date
    Sep 2002
    use sql_trace and trac it.

    Is it returning data to the client?

    If so you could have a network issue as its taking ages to return the data to you

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.