Thank you Stefan and Jonathan.
-----Original Message-----
From: Stefan Koehler [mailto:contact@xxxxxxxx] ;
Sent: Wednesday, June 07, 2017 12:16 PM
To: Hameed, Amir <Amir.Hameed@xxxxxxxxx>; 'ORACLE-L' <oracle-l@xxxxxxxxxxxxx>
Subject: RE: "free buffer waits" when inserting into a GTT
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: @OracleSK
Upcoming online seminar: http://tinyurl.com/17-06-13-Shared-Pool-Internals
"Hameed, Amir" <Amir.Hameed@xxxxxxxxx> 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