Database Software

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!

Oracle Job running slow vs sqlplus fast

perecdSep 15 2017 — edited Oct 29 2017

Hi guys, I've got a problem with one of the job, so any help would be great. I created a procedure that performs inserts as select operation. When I run this procedure in sql Plus(exec stat.copy_stt;), it takes about 30 seconds. If the oracle jobs scheduler runs it takes about 25 minutes. When i digged deeper I saw write complete waits with this job. Why is this job running hunging ?
Oracle DB ver.12.1.0.2

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 26 2017

Added on Sep 15 2017

#database-key-features, #performance, #scheduler

6 comments

2,753 views