Oracle ORA-00054 origin

-- 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

0 vote185 views1 answer
Split string by comma in sql server
SQL
0 vote199 views1 answer
Postgres data location
SQL
2 votes257 views2 answers
MySql FULL OUTER JOIN
SQL
1 vote207 views1 answer
Mysql curdate between two dates
SQL
15 votes182 views2 answers
Sql order by multiple columns
SQL
13 votes212 views4 answers
Command line mysql import
SQL
21 votes189 views3 answers
Average sql
SQL
9 votes188 views2 answers
Mysql change value
SQL
0 vote210 views1 answer
Oracle running queries
SQL
1 vote192 views1 answer
Sql server find tables referenced foreign key
SQL