What causes 'Global Cache CR' to hang?

From: upuaut <upuaut_at_yahoo.com>
Date: 12 Mar 2002 14:56:10 -0800
Message-ID: <c1a86e59.0203121456.3096388a@posting.google.com>

We're running Oracl parallel server instances (don't know which version)
Upon trying to run any statement from SQLPLUS prompt, it takes forever to get a response. Our DBA said the reason is that a 'system monitoring' job was waiting on 'global cache CR'. Not enough info to troubleshoot our app problme of hanigng foreaver.

The question: What IS that 'global cache CR' thing? What would cause is to hang or go fishing?

I realise the above info is not enough, but that's all the DBA devulged.

Any clue? quick before I lose my job.
thanks. Received on Tue Mar 12 2002 - 16:56:10 CST