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 vote213 views1 answer
Frename oracle
SQL
0 vote352 views1 answer
The differnece between to values in sql
SQL
8 votes199 views1 answer
Oracle all_source package body
SQL
0 vote201 views1 answer
Phpmyadmin mysql conflict
SQL
6 votes201 views2 answers
Oracle trigger
SQL
3 votes190 views2 answers
Sql asc
SQL
0 vote228 views1 answer
Arithmetic expression in sql
SQL
0 vote243 views1 answer
Updating database in sql
SQL
1 vote174 views1 answer
Launch sql script from docker in mysql
SQL
0 vote223 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL