since 11g
Store and sharing across sessions query result in SGA or client application memory
|
1 |
select /*+ RESULT_CACHE */ from TABLE; |
could be:
server – shared via shared pull on server
client (jdbc) – shared in client process area