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