v$sql.command_type and v$session.command

AUDIT_ACTIONS describes audit trail action type codes. This table can be used to map action type numbers to action type names.

details list at v$session.

List of command_type in v$sql values with meaning:

Insert 2
Select 3
Update 6
Delete 7
Lock Table 26
Alter Database 35
Alter Session 42
Commit 44
Rollback 45
Savepoint 46
Begin/Declare 47

come from :http://yumianfeilong.com/html/2008/01/15/316.html

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/90618/viewspace-672684/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/90618/viewspace-672684/