Is it Necessary to Change the Standard Settings for Global Temporary Tables?
(Doc ID 2185137.1)
Last updated on MAY 30, 2019
Applies to:Oracle Agile Engineering Data Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
By default, the Global Temporary Tables are created with these parameters:
ON COMMIT PRESERVE ROWS
RESULT_CACHE (MODE DEFAULT)
Very often the first search of a part is very slow, while a second try is fast. Is this the result of using nocache?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document