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博客

v$sql.command_type and v$session.command

最新文章