Database Administration (MOSC)

MOSC Banner

How to check if any table is locked

edited Feb 12, 2018 4:01AM in Database Administration (MOSC) 11 commentsAnswered

Hi,

Can you please let me know the query, How to check if any table is locked in Oracle.

I serached ad found this query

SELECT a.sid,a.serial#, a.username,c.os_user_name,a.terminal, b.object_id,substr(b.object_name,1,40) object_name

from v$session a, dba_objects b, v$locked_object c where a.sid = c.session_id and b.object_id = c.object_id;

Below is the result

I didnot get what this is saying.

Can you please let me know the query which I check and that will give the result which tables are locked.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center