共计 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 行业资讯频道。