Re: Result cache hint not being used

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: cdunscombe@xxxxxxxxx
  • Date: Fri, 8 Jun 2012 16:26:05 +0100

Does Dom's article on VPD and Result cache help?
http://orastory.wordpress.com/2009/02/19/a-bit-of-vpd-and-a-dollop-of-result-cache/

Just a little bit extra to try to avoid the overquoting sin

On Fri, Jun 8, 2012 at 4:07 PM, Chris Dunscombe <cdunscombe@xxxxxxxxx>wrote:

> Hi,
> We have a stored procedure with a cursor. This cursor has the result_cache
> hint.
>


> The app is Oracle App Server 10.1.3 and connects using application connect
> pools to the database via a proxy user with role information etc coming
> from OID.
> OLS is being used.
>
>


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


--
//www.freelists.org/webpage/oracle-l


Other related posts: