RE: INSERT into temp table causing "log file switch (checkpoint incomplete)"

Hey Amir,
you should see the reason (or at least the correlation) in the raw SQL trace file.

If not you can combine SQL trace and stack traces - only for this particular wait event (e.g. check my slide on page 17: http://www.soocs.de/public/talk/160616_DOAG_Regio_NUE_Identifying_Performance_Issues_Beyond_The_Oracle_Wait_Interface_PPT.pdf)  

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK
Upcoming online seminar: http://tinyurl.com/17-06-13-Shared-Pool-Internals

> "Hameed, Amir" <Amir.Hameed_at_xerox.com> hat am 5. Juni 2017 um 21:36 geschrieben:
>
> These waits are coming from a specific INSERT statement.
> I am assuming that since this GTT has been created with "ON COMMIT DELETE ROWS", there are multiple commits done by the insert statement and with
> each commit, the table is getting truncated? But, I am not able to find out how many commits are associated with this insert statement.
>
> Thanks,
> Amir

--
http://www.freelists.org/webpage/oracle-l