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

I should have mentioned that MOS ID #334822.1 is just an example as it affects various Oracle versions in different ways.  

> Stefan Koehler <contact_at_soocs.de> hat am 5. Juni 2017 um 21:23 geschrieben:
>
> Hi,
> are these waits the summary or from the specific INSERT?
>
> I would expect to see this kind of picture in case of TRUNCATE (MOS ID #334822.1) and not for the INSERT. You speed up the process and maybe your
> clean-up/reset procedure screws it up now but it is hard to say without knowing what your business process is exactly doing.
>
> 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

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