Re: Result cache hint not being used
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 8 Jun 2012 16:26:05 +0100
Message-ID: <CABe10sbUjFYfKgw2ddbZfgr6F9e3USBViYisGmL5tNH3aFtDig_at_mail.gmail.com>
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/
Date: Fri, 8 Jun 2012 16:26:05 +0100
Message-ID: <CABe10sbUjFYfKgw2ddbZfgr6F9e3USBViYisGmL5tNH3aFtDig_at_mail.gmail.com>
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_at_yahoo.com>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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 08 2012 - 10:26:05 CDT