Thanks all, I have the answer I needed.
Christopher Pruitt Business Consulting III HP Enterprises Services [email protected] www.hp.com<http://www.hp.com/> [cid:[email protected]] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of patchsk Sent: Wednesday, March 07, 2012 3:01 PM To: [email protected] Subject: Re: Query Cache Question. Where is it happening? ** 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug12 www.wwrug12.com<http://www.wwrug12.com> ARSList: "Where the Answers Are" _attend WWRUG12 www.wwrug.com<http://www.wwrug.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"
<<inline: image001.png>>
