-
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?
-
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
-
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"
-
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,
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|