Re: CTIME zero in v$lock

In my Oracle 8i and 9i instances on Sun Solaris, the CTIME column is non-zero. I don't have Tru64 to test out on.

HTH,
Brian

Sadik Aral Bozkirli wrote:
>
> Hi,
>
> I have oracle 9.2.0.0.0 on Compaq Tru64 UNIX V5.1.
>
> We are having problems with one of our applications but can't exactly
> pinpoint the problem. Though, I'm not sure there is a problem with
> the database, I have something like the following in my v$lock view...
> Notice CTIMEs are zereo for MR and RT locks. Is this normal?
>
> Thank...
>
> ADDR KADDR SID TY ID1 ID2
> LMODE REQUEST CTIME BLOCK
> ---------------- ---------------- ---------- -- ---------- ----------
> ---------- ---------- ---------- ----------
> 00000004009B7D58 00000004009B7D78 2 MR 5 0
> 4 0 0 0
> 00000004009B7C78 00000004009B7C98 2 MR 1 0
> 4 0 0 0
> 00000004009B7C08 00000004009B7C28 2 MR 2 0
> 4 0 0 0
> 00000004009B7B98 00000004009B7BB8 2 MR 3 0
> 4 0 0 0
> 00000004009B7B28 00000004009B7B48 2 MR 4 0
> 4 0 0 0
> 00000004009B7DC8 00000004009B7DE8 3 RT 1 0
> 6 0 0 0
> 00000004009B7CE8 00000004009B7D08 5 TS 3 16777218
> 3 0 170371 0

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"