For sure oracle does caching as long as the query is performed with same variables, values could be different. This is something called bind variables in oracle. As long as they are same oracle does not have to parse and calculate the execution plan again. Also I guess it stores the data in cache for some time so the same query second time would get results faster. For ARS other than forms/workflow it would not cache any data.
On Wednesday, March 7, 2012 2:54:39 PM UTC-6, Pruitt, Christopher (Bank of America Account) wrote: > > There was a question posed during a meeting today based on some new > servers we are setting up. > > When we perform a query on a form for the first time it takes a long time > to run. > We then perform the exact same query again and it runs much, much faster. > > The question was posed. It the Oracle database doing the query caching or > is the AR System Server doing the caching or is it a combination of both? > > Server: HP-UX Initium > DB: Oracle 10g > AR System Server 7.1 Patch 11 > > > > Christopher Pruitt > HP Enterprise Services > Bank of America Account | CIA - Integrated Applications | IW > Infrastructure Team > +1.972.605.7702 office | christopher.pru...@hp.com > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"