/SQL/Ora-00054 resource busy and acquire with nowait

Ora-00054 resource busy and acquire with nowait

-- ORA-00054 origin (resource busy and acquire with nowait)
SELECT l.SESSION_ID || ',' || v.SERIAL#     AS sid_serial,
       l.ORACLE_USERNAME                    AS ora_user,
       o.OBJECT_NAME,
       o.OBJECT_TYPE,
       DECODE(l.LOCKED_MODE,
              0, 'None',
              1, 'Null',
              2, 'Row-S (SS)',
              3, 'Row-X (SX)',
              4, 'Share',
              5, 'S/Row-X (SSX)',
              6, 'Exclusive',
              TO_CHAR(l.LOCKED_MODE)
           )                                AS lock_mode,
       o.STATUS,
       to_char(o.LAST_DDL_TIME, 'dd.mm.yy') AS last_ddl
FROM DBA_OBJECTS o, GV$LOCKED_OBJECT l, V$SESSION v
WHERE o.OBJECT_ID = l.OBJECT_ID
  AND l.SESSION_ID = v.SID
ORDER BY 2, 3;

Source: community.oracle.com

Similar codes

1 vote559 views2 answers
Sql unique rows
SQL
3 votes339 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote359 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote355 views1 answer
Sql replace id with name from another table
SQL
0 vote349 views2 answers
How to tun mysql on ubunto
SQL
0 vote347 views1 answer
Show table structure mysql console
SQL
0 vote391 views1 answer
Mariadb cast to int
SQL
17 votes318 views2 answers
How to assign date field for table in mysql
SQL
21 votes351 views1 answer
Cheatsheet for sql
SQL
14 votes366 views5 answers
Sql oracle limit
SQL