Re: command_type field in v$sql

"Frédéric Ruffet" <fruffet_at_kaptech.com> a écrit dans le message news: 9n4uqe$1oqs$1_at_news4.isdnet.net...
> Hi,
>
> Could anyone tell me where I could find the signification of the values of
> the command_type field in the v$sql dynamic table ?
>
> Frédéric Ruffet - fruffet_at_kaptech.com
>
>
>

in the audit_actions view:

v815> select distinct s.command_type, a.name   2 from audit_actions a, v$sql s where a.action=s.command_type;

COMMAND_TYPE NAME

------------ ---------------------------
           2 INSERT
           3 SELECT
           6 UPDATE
           7 DELETE
          15 ALTER TABLE
          42 ALTER SESSION
          44 COMMIT
          47 PL/SQL EXECUTE

8 rows selected.

--
Hope this helps
Michel