SELECT SID,SERIAL#,v.schemaname,
DECODE(COMMAND,0,'None',2,'Insert',3,'Select',6,'Update',7,'Delete',8,'Drop',26,'Lock Table'
,44,'Commit',45,'Rollback',47,'PL/SQL Execute','Other') command FROM V$SESSION v
SID SERIAL# SCHEMANAME COMMAND
---------- ---------- ------------------------------ --------------
1 1 SYS None
2 1 SYS None
3 1 SYS None
4 1 SYS None
5 7 SYS None
8 1 SYS None
9 10 SYS None
63 5 SYS None
64 1 SYS None
65 1 SYS None
66 1 SYS None
69 52 SYS None
70 3 SYS None
72 485 SYS None
125 1 SYS None
126 1 SYS None
127 1 SYS None
128 1 SYS None
129 3 SYS None
131 631 DRSTR Select
132 448 SYSTEM Select
187 1 SYS None
188 1 SYS None
189 1 SYS None
190 1 SYS None
192 4 SYS None
194 1 SYS None
195 1 SYS None
199 27 SYS None
29 rows selected
DECODE(COMMAND,0,'None',2,'Insert',3,'Select',6,'Update',7,'Delete',8,'Drop',26,'Lock Table'
,44,'Commit',45,'Rollback',47,'PL/SQL Execute','Other') command FROM V$SESSION v
SID SERIAL# SCHEMANAME COMMAND
---------- ---------- ------------------------------ --------------
1 1 SYS None
2 1 SYS None
3 1 SYS None
4 1 SYS None
5 7 SYS None
8 1 SYS None
9 10 SYS None
63 5 SYS None
64 1 SYS None
65 1 SYS None
66 1 SYS None
69 52 SYS None
70 3 SYS None
72 485 SYS None
125 1 SYS None
126 1 SYS None
127 1 SYS None
128 1 SYS None
129 3 SYS None
131 631 DRSTR Select
132 448 SYSTEM Select
187 1 SYS None
188 1 SYS None
189 1 SYS None
190 1 SYS None
192 4 SYS None
194 1 SYS None
195 1 SYS None
199 27 SYS None
29 rows selected
No comments:
Post a Comment