Result cache hint not being used
From: Chris Dunscombe <cdunscombe_at_yahoo.com>
Date: Fri, 8 Jun 2012 16:07:11 +0100 (BST)
Message-ID: <1339168031.44868.YahooMailNeo_at_web29702.mail.ird.yahoo.com>
Hi,
We have a stored procedure with a cursor. This cursor has the result_cache hint. When the stored proc is called from SQLPlus the execution plan uses the result cache. However when the stored proc is called by the app the result cache isn't used.
Date: Fri, 8 Jun 2012 16:07:11 +0100 (BST)
Message-ID: <1339168031.44868.YahooMailNeo_at_web29702.mail.ird.yahoo.com>
Hi,
We have a stored procedure with a cursor. This cursor has the result_cache hint. When the stored proc is called from SQLPlus the execution plan uses the result cache. However when the stored proc is called by the app the result cache isn't used.
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.
Database version: 11.1.0.7.5
OS: AIX 6.1
Any ideas appreciated.
Thanks,
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 08 2012 - 10:07:11 CDT