Re: table doesn't get cached

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Fri, 18 Oct 2013 13:43:21 -0700 (PDT)
Message-ID: <3d3e4587-cf6b-444d-a74f-0d8ad3fd7397_at_googlegroups.com>


The query selects only one column - non-LOB, so I assume that it doesn't need to read LOB segments. The LOB segments also have caching enabled (DBA_LOBS.CACHE='YES'). The server where this db is running has 10 GB memory, so we couldn't set SGA to 16 GB. Received on Fri Oct 18 2013 - 22:43:21 CEST

Original text of this message