v$session中command字段的含义解析是怎样的

本篇文章给大家分享的是有关v$session中command字段的含义解析是怎样的，小编觉得挺实用的，因此分享给大家学习，希望大家阅读完这篇文章后可以有所收获，话不多说，跟着小编一起来看看吧。

以下函数解析视图v$session中command字段的含义

create or replace function lln_session_cmd_info(p_cmd in number default 0)

    return varchar2 is

    v_retinfo varchar2(64);

begin

    select case p_cmd

when 0 then

                0

               when 1 then

                CREATE TABLE

               when 2 then

                INSERT

               when 3 then

                SELECT

               when 4 then

                CREATE CLUSTER

when 5 then

                ALTER CLUSTER

               when 6 then

                UPDATE

               when 7 then

                DELETE

               when 8 then

                DROP CLUSTER

               when 9 then

                CREATE INDEX

when 10 then

                DROP INDEX

               when 11 then

                ALTER INDEX

               when 12 then

                DROP TABLE

               when 13 then

                CREATE SEQUENCE

when 14 then

                ALTER SEQUENCE

               when 15 then

                ALTER TABLE

               when 16 then

                DROP SEQUENCE

               when 17 then

                GRANT OBJECT

when 18 then

                REVOKE OBJECT

               when 19 then

                CREATE SYNONYM

               when 20 then

                DROP SYNONYM

               when 21 then

                CREATE VIEW

               when 22 then

DROP VIEW

               when 23 then

                VALIDATE INDEX

               when 24 then

                CREATE PROCEDURE

               when 25 then

                ALTER PROCEDURE

when 26 then

                LOCK

               when 27 then

                NO-OP

               when 28 then

                RENAME

               when 29 then

                COMMENT

               when 30 then

                AUDIT OBJECT

               when 31 then

NOAUDIT OBJECT

               when 32 then

                CREATE DATABASE LINK

               when 33 then

                DROP DATABASE LINK

               when 34 then

                CREATE DATABASE

when 35 then

                ALTER DATABASE

               when 36 then

                CREATE ROLLBACK SEG

               when 37 then

                ALTER ROLLBACK SEG

               when 38 then

DROP ROLLBACK SEG

               when 39 then

                CREATE TABLESPACE

               when 40 then

                ALTER TABLESPACE

               when 41 then

                DROP TABLESPACE

when 42 then

                ALTER SESSION

               when 43 then

                ALTER USER

               when 44 then

                COMMIT

               when 45 then

                ROLLBACK

               when 46 then

SAVEPOINT

               when 47 then

                PL/SQL EXECUTE

               when 48 then

                SET TRANSACTION

               when 49 then

                ALTER SYSTEM

               when 50 then

EXPLAIN

               when 51 then

                CREATE USER

               when 52 then

                CREATE ROLE

               when 53 then

                DROP USER

               when 54 then

                DROP ROLE

when 55 then

                SET ROLE

               when 56 then

                CREATE SCHEMA

               when 57 then

                CREATE CONTROL FILE

               when 59 then

                CREATE TRIGGER

when 60 then

                ALTER TRIGGER

               when 61 then

                DROP TRIGGER

               when 62 then

                ANALYZE TABLE

               when 63 then

                ANALYZE INDEX

when 64 then

                ANALYZE CLUSTER

               when 65 then

                CREATE PROFILE

               when 66 then

                DROP PROFILE

               when 67 then

                ALTER PROFILE

when 68 then

                DROP PROCEDURE

               when 70 then

                ALTER RESOURCE COST

               when 71 then

                CREATE SNAPSHOT LOG

               when 72 then

ALTER SNAPSHOT LOG

               when 73 then

                DROP SNAPSHOT LOG

               when 74 then

                CREATE SNAPSHOT

               when 75 then

                ALTER SNAPSHOT

when 76 then

                DROP SNAPSHOT

               when 77 then

                CREATE TYPE

               when 78 then

                DROP TYPE

               when 79 then

                ALTER ROLE

               when 80 then

ALTER TYPE

               when 81 then

                CREATE TYPE BODY

               when 82 then

                ALTER TYPE BODY

               when 83 then

                DROP TYPE BODY

               when 84 then

DROP LIBRARY

               when 85 then

                TRUNCATE TABLE

               when 86 then

                TRUNCATE CLUSTER

               when 91 then

                CREATE FUNCTION

when 92 then

                ALTER FUNCTION

               when 93 then

                DROP FUNCTION

               when 94 then

                CREATE PACKAGE

               when 95 then

                ALTER PACKAGE

when 96 then

                DROP PACKAGE

               when 97 then

                CREATE PACKAGE BODY

               when 98 then

                ALTER PACKAGE BODY

               when 99 then

DROP PACKAGE BODY

               when 100 then

                LOGON

               when 101 then

                LOGOFF

               when 102 then

                LOGOFF BY CLEANUP

               when 103 then

                SESSION REC

when 104 then

                SYSTEM AUDIT

               when 105 then

                SYSTEM NOAUDIT

               when 106 then

                AUDIT DEFAULT

               when 107 then

NOAUDIT DEFAULT

               when 108 then

                SYSTEM GRANT

               when 109 then

                SYSTEM REVOKE

               when 110 then

                CREATE PUBLIC SYNONYM

when 111 then

                DROP PUBLIC SYNONYM

               when 112 then

                CREATE PUBLIC DATABASE LINK

               when 113 then

                DROP PUBLIC DATABASE LINK

when 114 then

                GRANT ROLE

               when 115 then

                REVOKE ROLE

               when 116 then

                EXECUTE PROCEDURE

               when 117 then

USER COMMENT

               when 118 then

                ENABLE TRIGGER

               when 119 then

                DISABLE TRIGGER

               when 120 then

                ENABLE ALL TRIGGERS

when 121 then

                DISABLE ALL TRIGGERS

               when 122 then

                NETWORK ERROR

               when 123 then

                EXECUTE TYPE

               when 157 then

CREATE DIRECTORY

               when 158 then

                DROP DIRECTORY

               when 159 then

                CREATE LIBRARY

               when 160 then

                CREATE JAVA

               when 161 then

ALTER JAVA

               when 162 then

                DROP JAVA

               when 163 then

                CREATE OPERATOR

               when 164 then

                CREATE INDEXTYPE

               when 165 then

DROP INDEXTYPE

               when 167 then

                DROP OPERATOR

               when 168 then

                ASSOCIATE STATISTICS

               when 169 then

DISASSOCIATE STATISTICS

               when 170 then

                CALL METHOD

               when 171 then

                CREATE SUMMARY

               when 172 then

                ALTER SUMMARY

               when 173 then

DROP SUMMARY

               when 174 then

                CREATE DIMENSION

               when 175 then

                ALTER DIMENSION

               when 176 then

                DROP DIMENSION

when 177 then

                CREATE CONTEXT

               when 178 then

                DROP CONTEXT

               when 179 then

                ALTER OUTLINE

               when 180 then

                CREATE OUTLINE

when 181 then

                DROP OUTLINE

               when 182 then

                UPDATE INDEXES

               when 183 then

                ALTER OPERATOR

               else

This function Not Supported

           end

      into v_retinfo

      from dual;

    return v_retinfo;

end;

以上就是v$session中command字段的含义解析是怎样的，小编相信有部分知识点可能是我们日常工作会见到或用到的。希望你能通过这篇文章学到更多知识。更多详情敬请关注行业资讯频道。