how long locked ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: how long locked ?

  1. #1
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Hi friends,

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

    Thanks

    Suresh
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  3. #3
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Thanks Tim
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  4. #4
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Yes CTime specifies the time since the current mode was occupied. The time is stored in 100th of a second.
    Agasimani
    OCP(10g/9i/8i/8)

  5. #5
    Join Date
    May 2001
    Posts
    25
    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

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    i thought someone said 100th of seconds

    oh yes it is there

  7. #7
    Join Date
    Oct 2000
    Posts
    449
    Is it 1/100th of a second, or seconds as is... ? (ctime)

    Thanks, ST2000

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width