- DBA_BLOCKERS -- Shows non-waiting sessions holding locks being waited on
- DBA_DDL_LOCKS -- Shows all DDL locks held or being requested
- DBA_DML_LOCKS -- Shows all DML locks held or being requested
- DBA_LOCK_INTERNAL -- Displays one row for every lock or latch held or being requested
- DBA_LOCKS -- Shows all locks or latches held or being requested
- DBA_WAITERS -- Shows all sessions waiting on, but not holding waited for locks
The DBA_LOCK_INTERNAL view is best to show locks for a specific user, and you can specify the query in the form:
SELECT NVL(b.username,'SYS') username, session_id,lock_type,mode_held, mode_requested,lock_id1,lock_id2 FROM sys.dba_lock_internal a, sys.v_$session b where . . .For a complete list of over 600 Oracle scripts, I would recommend the Ault Oracle script location at www.oracle-script.com.
Dig Deeper on Oracle and SQL
Related Q&A from Don Burleson
I have created a table, Party, and in it there are two main fields, party_code and party_name, and around 2,500 records are available in it. I passed... Continue Reading
Suppose you have a table which has only two columns, namely locid (not primary) and place. In Oracle, which query should I run to get the output as ... Continue Reading
I have a query that retrieves around 10 records. I have a task to concatenate the values separated with ','. I would like to know if Oracle has any ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.