Skip to Main Content

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

Comments

Timo Hahn
Answer

Isn't this exactly what you told the pivot table to do?

The two records can't be distinguished with the given values of startdate,  hat and sipno.

You can add the starttime to the row edge and you should see the two rows.

Timo

Marked as Answer by Okan Sutcuoglu · Sep 27 2020
Okan Sutcuoglu

Main problem here is i misunderstood pivot table's work principles. Thank you.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 26 2017
Added on Sep 15 2017
6 comments
2,667 views