Oracle result cache - Implementing concerns
Hi,
We have four node 11.2.0.3 Oracle RAC database and we hope to consider implementing Oracle 'result cache'. The clients are connecting to two node application servers and those are connected to the database. Therefore the application server will be the client for the database.
With the intention of reducing the no. of hits to the db we are thinking to implement client result cache, so that results will be cached in the application server (client of the db).
I would like to know what are the practical implementation considerations of client result cache. I would also like to know where I can find detailed documentation, case studies about client result cache.
0