Oracle by default caching the query results and function results(Buffer cache).
I have noticed this with
AutoTrace utility, where the physical reads are huge on first execution, but from next execution onward it reduced dramatically.
Then what is the importance of query result cache, function result cache?
I have also noticed that the buffer cache does not gets invalidated even when I try to update physical table. But still I noticed physical reads are 0.
Could some one help on this to understand better?