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