Yes.. its Oracles MRU and LRU queues. There is a lot of info on this
available online that you should find but to get you started take a look at
this article..
http://www.adp-gmbh.ch/ora/concepts/cache.html
Joe
-----Original Message-----
From: Pruitt, Christopher (Bank of America Account)
Sent: Wednesday, March 07, 2012 3:54 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Query Cache Question. Where is it happening?
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"