Skip to Main Content

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.

Post Details
Added on Sep 15 2017