how long locked ?

**Sureshy** · 08-20-2002, 06:01 AM

Hi friends,

Is there a way of determinig how long an object has been locked for ?

Thanks

Suresh

**TimHall** · 08-20-2002, 06:09 AM

The CTIME column of the V$LOCK view tells you how long the lock has been in that mode. That's about the best I can do off the top of my head.

Cheers

**Sureshy** · 08-20-2002, 06:13 AM

Thanks Tim

**agasimani** · 08-20-2002, 06:17 AM

Yes CTime specifies the time since the current mode was occupied. The time is stored in 100th of a second.

**ctcyl** · 08-20-2002, 08:15 AM

Dear Friends..

Will you please tell me CTIME is showing in Minutes or Seconds in the time for Duration of Locking the table.

Thanks

Rajeev

**pando** · 08-20-2002, 08:53 AM

i thought someone said 100th of seconds

oh yes it is there

**st2000** · 08-20-2002, 10:41 AM

Is it 1/100th of a second, or seconds as is... ? (ctime)

Thanks, ST2000

**julian** · 08-21-2002, 02:26 AM

Originally posted by st2000
Is it 1/100th of a second, or seconds as is... ? (ctime)

Thanks, ST2000

It is SECONDS, not 1/100th of a second.
Reference: look at the last two replies in Metalink Doc ID: 2805.999.

Thread: how long locked ?