This wait event occurs when the session needs a free buffer, so it can bring a data block into the buffer cache, and is waiting for a buffer that is not dirty to become available. This can occur if DBWR is not writing dirty buffers to disk fast enough.
While bulk loading significantly reduces the amount of I/O activity required for loading large amounts of data to the database inside of a single transaction, this operations still takes a relatively long time to complete.
© 2020 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz