RE: "free buffer waits" when inserting into a GTT

Thank you Stefan and Jonathan.

-----Original Message-----
From: Stefan Koehler [mailto:contact_at_soocs.de] Sent: Wednesday, June 07, 2017 12:16 PM To: Hameed, Amir <Amir.Hameed_at_xerox.com>; 'ORACLE-L' <oracle-l_at_freelists.org> 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: _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

†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Wed Jun 07 2017 - 21:06:13 CEST