Wednesday, January 21, 2015

Which user executing what type of command in oracle

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

No comments:

Post a Comment