"ctime" and "block" column in V$LOCK!!
510293Aug 2 2007 — edited Aug 2 2007Hi. all.
What does "block" column in V$LOCK mean?
The following is from manual.
"A value of either 0 or 1, depending on whether or not the lock in question
is the blocker"
However, V$LOCK.block in my db is all "2".
As far as I konw, if request = 0 , this is lock holder, if request > 0, this is lock waiter.
One more question!!
What is the time unit of ctime column in V$LOCK?
For example, "594873" for ctime means what seconds?
Thanks and Regards.