Oracle query optimization: RESULT_CACHE

since 11g

Store and sharing across sessions query result in SGA or client application memory

could be:
server – shared via shared pull on server
client (jdbc) – shared in client process area

Leave a comment

Your email address will not be published. Required fields are marked *