| dba_locks [message #237438] |
Mon, 14 May 2007 08:48  |
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
|
Senior Member |
|
|
Hi all,
From the documentation:
DBA_LOCK
DBA_LOCK lists all locks or latches held in the database, and all outstanding requests for a lock or latch.
Column Datatype NULL Description
SESSION_ID NUMBER Session holding or acquiring the lock
LOCK_TYPE VARCHAR2(26) Lock type See Also: For a listing of lock types, see Appendix D, "Oracle Enqueue Names"
MODE HELD VARCHAR2(40) Lock mode
MODE REQUESTED VARCHAR2(40) Lock mode requested
LOCK_ID1 VARCHAR2(40) Type-specific lock identifier, part 1
LOCK_ID2 VARCHAR2(40) Type-specific lock identifier, part 2
LAST_CONVERT NUMBER The last convert
BLOCKING_OTHERS VARCHAR2(40) Whether the lock is currently blocking others
(oracle documentation 10g release 2)
My question is what are lock_ID1 and lock_id2 2 relating to.
I did a (not to extensive) search on the web, but came out with nothing.
Some pointers to documentation which describes the answer to my question would be appreciated
|
|
|
|
|
|
|
|
| Re: dba_locks [message #237447 is a reply to message #237438] |
Mon, 14 May 2007 09:13  |
 |
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
ID1 and ID2 meaning depends on lock type.
There is no full documentation on this.
You can have from time to time a clue of what it is.
Search for all occurrence of v$lock and dba_lock in Oracle documentation and Metalink.
Regards
Michel
[edit: add missing "NO"]
[Updated on: Tue, 15 May 2007 01:42] Report message to a moderator |
|
|
|
| Re: dba_locks [message #237587 is a reply to message #237446] |
Tue, 15 May 2007 01:05 |
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
|
Senior Member |
|
|
Hi thanks for your answer.
As soon as I am able to login metlink again I will read the documents you suggested.
|
|
|
|
| Re: dba_locks [message #237589 is a reply to message #237447] |
Tue, 15 May 2007 01:06 |
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
|
Senior Member |
|
|
I was allready afraid for something like this 
Anyway... I will study documentation.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
