v$lock question

From: rjamya <rjamya_at_gmail.com>
Date: Wed, 23 Mar 2005 15:52:14 -0500
Message-ID: <9177895d05032312523c7b1682@mail.gmail.com>

for lock type 'CU' what do values id1 and id2 indicate?

We had a developer experience DBDS (death by dynamic sql). The session is waiting on 'global cache cr request' waiting for more than 3000 seconds, 10046 trace file doesn't get updated, and v$lock shows type
'CU'.

BTW using oradebug to dump processstate for the process in question doesn't work, I had to kill the dump processstate command after 4 minutes. So, I dumped the systemstate and found some more information.

So once again the question is what do the values of id1 and id2 indicate for lock type 'CU'.

After looking 'CU' I had developer put in 'cs=exact' in the code and the report finished in expected time (as against 5 hours and counting).

I am just curious I guess.
TIA
Raj

---

select standard_disclaimer from company_requirements where category =
'MANDATORY';

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 23 2005 - 15:55:55 CST