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.
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.