v$lock question

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 23 Mar 2005 15:52:14 -0500

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

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

I am just curious I guess. 
select standard_disclaimer from company_requirements where category =

Other related posts: