| v$lock & v$session - columns info [message #64177] |
Mon, 27 December 2004 23:53 |
patrick
Messages: 83
Registered: December 2000
|
Member |
|
|
Hi,
I'm wondering and I'm not sure about the meaning of some columns in V$LOCK and V$SESSION views:
V$LOCK:
-------
ADDR & KADDR:
Manual description: Address of lock state object & Address of lock.
--> What kind of address are they? Is it a kind of lock state-object ID & lock ID? Is it a pointer to the locked row? What can be these columns used for?
ID1 & ID2:
Manual description: Lock identifier #1 & Lock identifier #2.
--> What does it mean more "explicitely"? How could we interprete these 2 columns and what are their use?
V$SESSION:
----------
SADDR & PADDR & TADDR:
Manual description: Session address & Address of the session that owns this session & Address of transaction state object.
--> What does it mean more "explicitely"? Is it a pointer? What is their meaning and how/what are they used for?
LOCKWAIT:
Manual description: address of lock waiting for; NULL if NONE.
--> What kind of address is it? Is it a pointer to the locked row? NONE if the session is not blocked? What can be these columns used for?
Thank you so much in advance!
Best regards,
Patrick.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
