select a.sid,a.serial#,a.status,a.last_call_et,b.type,d.OWNER,d.OBJECT_NAME,d.OBJECT_TYPE
from v$session a,v$lock b,v$locked_object c,dba_objects d
where a.sid=b.sid
from v$session a,v$lock b,v$locked_object c,dba_objects d
where a.sid=b.sid
and b.sid=c.session_id
and c.object_id=d.object_id
-----------------------------------------
结果:
SID | SERIAL# | STATUS | LAST_CALL_ET | TYPE | OWNER | OBJECT_NAME | OBJECT_TYPE | |
20 | 2093 | 53938 | INACTIVE | 112832 | TM | INFORES_TEST | T_WORK_SHEET | TABLE |
21 | 2093 | 53938 | INACTIVE | 112832 | TM | INFORES_TEST | T_WORK_SHEET | TABLE |
18 | 3249 | 36025 | ACTIVE | 112832 | TX | INFORES_TEST | T_WORK_SHEET | TABLE |
19 | 3249 | 36025 | ACTIVE | 112832 | TM | INFORES_TEST | T_WORK_SHEET | TABLE |
2 | 2093 | 53938 | INACTIVE | 112832 | TM | INFORES_TEST | SYS_RES_OPERLOG | TABLE |
1 | 2093 | 53938 | INACTIVE | 112832 | TM | INFORES_TEST | SYS_RES_OPERLOG | TABLE |
22 | 2093 | 53938 | INACTIVE | 112832 | TX | INFORES_TEST | T_WORK_SHEET | TABLE |
3 | 2093 | 53938 | INACTIVE | 112832 | TX | INFORES_TEST | SYS_RES_OPERLOG | TABLE |
14 | 2067 | 57185 | ACTIVE | 112821 | TX | INFORES_TEST | T_WORK_SHEET | TABLE |
15 | 2067 | 57185 | ACTIVE | 112821 | TM | INFORES_TEST | T_WORK_SHEET | TABLE |
13 | 2428 | 48472 | ACTIVE | 112761 | TM | INFORES_TEST | T_WORK_SHEET | TABLE |
16 | 1878 | 17803 | ACTIVE | 112761 | TX | INFORES_TEST | T_WORK_SHEET | TABLE |
17 | 1878 | 17803 | ACTIVE | 112761 | TM | INFORES_TEST | T_WORK_SHEET | TABLE |
12 | 2428 | 48472 | ACTIVE | 112761 | TX | INFORES_TEST | T_WORK_SHEET | TABLE |
11 | 2068 | 13259 | ACTIVE | 112461 | TM | INFORES_TEST | T_WORK_SHEET | TABLE |
10 | 2068 | 13259 | ACTIVE | 112461 | TX | INFORES_TEST | T_WORK_SHEET | TABLE |
8 | 2445 | 8181 | ACTIVE | 110657 | TX | INFORES_TEST | T_WORK_SHEET | TABLE |
9 | 2445 | 8181 | ACTIVE | 110657 | TM | INFORES_TEST | T_WORK_SHEET | TABLE |
5 | 2832 | 30092 | ACTIVE | 79577 | TM | INFORES_TEST | T_WORK_SHEET | TABLE |
4 | 2832 | 30092 | ACTIVE | 79577 | TX | INFORES_TEST | T_WORK_SHEET | TABLE |
7 | 2315 | 64594 | ACTIVE | 67456 | TM | INFORES_TEST | T_WORK_SHEET | TABLE |
6 | 2315 | 64594 | ACTIVE | 67456 | TX | INFORES_TEST | T_WORK_SHEET | TABLE |
25 | 2661 | 29720 | INACTIVE | 45 | TX | METADATA | CMS_FRONTIER5 | TABLE |
24 | 2661 | 29720 | INACTIVE | 45 | TM | METADATA | CMS_FRONTIER5 | TABLE |
23 | 2661 | 29720 | INACTIVE | 45 | TO | METADATA | CMS_FRONTIER5 | TABLE |
28 | 2284 | 39937 | ACTIVE | 38 | TX | RMGZ_KF | INTF_GG_SYNCLOG | TABLE |
27 | 2284 | 39937 | ACTIVE | 38 | TM | RMGZ_KF | INTF_GG_SYNCLOG | TABLE |
26 | 2284 | 39937 | ACTIVE | 38 | JQ | RMGZ_KF | INTF_GG_SYNCLOG | TABLE |