V$SESSION's TADDR
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: V$SESSION's TADDR

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    V$SESSION's TADDR

    If V$Session's TADDR column is Null for a session, it means there is no transaction lock. Can I safely assume this session does not place a lock on any object at all?

  2. #2
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96
    TADDR is "Address of transaction state object" and with this column you can use to join V$TRANSACTION ADDR Column.

    To find out all locked objects of Database you can use following SQL

    select a.oracle_username, a.object_id, b.object_name
    from v$locked_object a, dba_objects b
    where a.object_id = b.object_id
    Dilip Patel
    OCP 8i

    Catch me online at Yahoo: ddpatel256

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: V$SESSION's TADDR

    Originally posted by a128
    Can I safely assume this session does not place a lock on any object at all?
    Yes, if TADDR is null, it suggests there aint any objects locked by this session.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Apr 2001
    Posts
    257
    But then, what about share locks for statements such as SELECT ...FROM...?

    Is it not considered to be a 'transaction' but it still places locks on tables it's reading from?

    Thanks,

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by a128
    But then, what about share locks for statements such as SELECT ...FROM...?
    "Select From Table" will not lock the table..in any mode.
    Its only read only..where did you find the info that the statements like SELECT..From..Table.. will lock in SHARE(S) mode?

    "Select..For..Update", for this u will see a value in TADDR.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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