locked_object

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
SELECT
    s.USERNAME ,
    s.STATUS ,
    s.SCHEMANAME ,
    s.OSUSER ,
    s.PROCESS ,
    s.MACHINE ,
    s.PROGRAM
FROM
    v$session s
WHERE
    s.STATUS = 'ACTIVE';

SELECT * FROM "V$TRANSACTION" ;

SELECT
    s.username,
    s.status,
    s.OSUSER,
    do.object_name,
    do.object_type,
    s.process,
    s.machine,
    s.PROGRAM,
    lo.PROCESS
FROM
    v$locked_object lo
LEFT JOIN DBA_OBJECTS do ON
    lo.OBJECT_ID = do.OBJECT_ID
LEFT JOIN v$session s ON
    lo.ORACLE_USERNAME = s.USERNAME
    AND lo.OS_USER_NAME = s.OSUSER;

ALTER TABLE <表名> UNLOCK;