Home » RDBMS Server » Server Administration » dba_locks
dba_locks [message #237438] Mon, 14 May 2007 08:48 Go to next message
martijn
Messages: 283
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 #237439 is a reply to message #237438] Mon, 14 May 2007 08:50 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
mmm wrong forum. Should be in sql I guess.
Sorry for this.
Re: dba_locks [message #237446 is a reply to message #237439] Mon, 14 May 2007 09:11 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Check Docids 557091.994 and 465334.999 on metalink
Re: dba_locks [message #237447 is a reply to message #237438] Mon, 14 May 2007 09:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
martijn
Messages: 283
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 Go to previous message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
I was allready afraid for something like this Smile

Anyway... I will study documentation.
Previous Topic: Shutdown Database
Next Topic: dbstart
Goto Forum:
  


Current Time: Sat Dec 10 20:41:32 CST 2016

Total time taken to generate the page: 0.08145 seconds