| || |
Is there a concept of cache in oracle(2 tier) as we do have in Web protocol.
Re: Database cache
Oracle does cache things. It certainly caches SQL statements and I think it will cache responses as well if it can. From what I remember (it has been while), the cache is a memory stack so if items are not used they just drop off the end of the cache when new items are added in.
The cache does differ from web caching though in that it is all at the server. I don't think there is any client side caching. Generally the difference in response time between cached and uncached responses is in the hundredths or thousandths of seconds.
Try looking in the enterprise manager performance section. I think you may be able to get stats on cache usage from there.
Hope this helps,