SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Procedure execution time

Bollineni86Jan 13 2016 — edited Jan 25 2016

Hi All,

I am executing one procedure from SQL Developer, while monitoring externally, it takes around 10 mins to complete.

I have place dbms_output.put_line('Testing Time' ||CURRENT_TIMESTAMP) command in starting of the procedure(after Begin) and end of the procedure(Before END), it displays just 3 mins difference.

will it take time to transfer code from client to server..?

I am not able to find the solution.. Could you pleas help me.

in Procedure we are printing number of messages, may be due to this it will take time ..?

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit

PL/SQL Release 12.1.0.2.0 - Production

"CORE 12.1.0.2.0 Production"

SQL DEVELOPER:

Version 4.1.3.20

Thanks,

Gopi

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 22 2016

Added on Jan 13 2016

6 comments

4,320 views