“gc cr request” waits - - Check your query - you're query large data ? - Check traffic at InterConnect (private) - Do you use Gigabit NIC? Surachart Opun http://surachartopun.com On Wed, Dec 16, 2009 at 9:27 AM, Rajesh Rao <Rajesh.Rao@xxxxxxxxxxxx> wrote: > 10.2.0.3 RAC. Looking to get more insight into this latch as I see seek > to troubleshoot and check for co-relation to an issue with sessions > experiencing “gc cr request” waits. Especially, what causes sessions to wait > on this latch? > > > > Regards > > Raj > > This communication is for informational purposes only. It is not intended > as an offer or solicitation for the purchase or sale of any financial > instrument or as an official confirmation of any transaction. All market > prices, data and other information are not warranted as to completeness or > accuracy and are subject to change without notice. Any comments or > statements made herein do not necessarily reflect those of JPMorgan Chase & > Co., its subsidiaries and affiliates. This transmission may contain > information that is privileged, confidential, legally privileged, and/or > exempt from disclosure under applicable law. If you are not the intended > recipient, you are hereby notified that any disclosure, copying, > distribution, or use of the information contained herein (including any > reliance thereon) is STRICTLY PROHIBITED. Although this transmission and any > attachments are believed to be free of any virus or other defect that might > affect any computer system into which it is received and opened, it is the > responsibility of the recipient to ensure that it is virus free and no > responsibility is accepted by JPMorgan Chase & Co., its subsidiaries and > affiliates, as applicable, for any loss or damage arising in any way from > its use. If you received this transmission in error, please immediately > contact the sender and destroy the material in its entirety, whether in > electronic or hard copy format. Thank you. Please refer to > http://www.jpmorgan.com/pages/disclosures for disclosures relating to > European legal entities. >