By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
- 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
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 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
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.