Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: 11g: how to get Client Result Cache to work?
Vsevolod Afanassiev wrote:
> I am trying to get Client Result Cache to work in Oracle 11g database.
> This feature is described in OCI Programmer's Guide, pages 10-22 -
> 10-27.
>
> 1. Parameter CLIENT_RESULT_CACHE_SIZE has been set to 1000000 and
> database restarted. I can see new value in V$PARAMETER.
> 2. Parameter RESULT_CACHE_MODE has been set to FORCE.
>
> I am definitely getting results cached on the server: I can see it in V
> $RESULT_CACHE_* views and performance of large table scans is sub-
> second. However, view CLIENT_RESULT_CACHE_STATS$ is empty, so I assume
> that
> results do not get cached on the client. Any idea what is missing?
>
> How the teste were done:
> - Using SQL*Plus running on the same server as database. I tried
> Bequeath
> connections and connections though listener (listener is also 11g).
> - Large table is created (no indexes)
> - Full table scan is performed using SELECT COUNT(*)
> so result set consists of one row.
> - There is no sqlnet.ora
Run the RESULT CACHE demos in Morgan's Library at www.psoug.org.
They work.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Oct 10 2007 - 08:02:31 CDT
![]() |
![]() |