RE: "free buffer waits" when inserting into a GTT
Date: Wed, 7 Jun 2017 18:16:04 +0200 (CEST)
Message-ID: <1242333229.44287.1496852164466_at_ox.hosteurope.de>
Hey Amir,
with direct path inserts (APPEND_VALUES) but this has several other effects as well.
Franck Pachot has written a blog post about some of these effects: https://blog.dbi-services.com/insert-into-gtt-bulk-with-appendvalues/
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 7. Juni 2017 um 17:44 geschrieben:
>
> Thanks Jonatan for the clarification.
> The table is created with ON COMMIT DELETE ROWS and therefore, we start with an empty segment.
>
> I have a follow-up question. Under what circumstances a GTT will do "direct path reads/write" apart from when reading and writing for sorting?
>
> Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 07 2017 - 18:16:04 CEST