Monday, January 26, 2015

Users executing which type of command

SELECT
 sid,serial#,osuser,machine,module,action, 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
order by command

No comments:

Post a Comment