Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Wed, 10 Oct 2007 06:02:31 -0700 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: 11g: how to get Client Result Cache to work? References: <1191978458.740529.295650@o80g2000hse.googlegroups.com> In-Reply-To: <1191978458.740529.295650@o80g2000hse.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1192021337.760836@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@216.162.218.178 X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 33 X-Complaints-To: abuse@csolutions.net Xref: usenetserver.com comp.databases.oracle.server:436162 X-Received-Date: Wed, 10 Oct 2007 09:02:18 EDT (text.usenetserver.com) 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@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org