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

65次阅读
没有评论

共计 3959 个字符,预计需要花费 10 分钟才能阅读完成。

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

以下函数解析视图 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 字段的含义解析是怎样的,丸趣 TV 小编相信有部分知识点可能是我们日常工作会见到或用到的。希望你能通过这篇文章学到更多知识。更多详情敬请关注丸趣 TV 行业资讯频道。

正文完
 
丸趣
版权声明:本站原创文章,由 丸趣 2023-07-18发表,共计3959字。
转载说明:除特殊说明外本站除技术相关以外文章皆由网络搜集发布,转载请注明出处。
评论(没有评论)