V$SESSION COMMAND

V$SESSION中的COMMAND的含義

create table seccmdtype (
type number,
DESCRIPTION varchar2(40))
/

create index idx_pk_seccmdtype on seccmdtype(type);
ALTER TABLE seccmdtype add constraint pk_seccmdtype primary key (type) using index idx_pk_seccmdtype;

insert into seccmdtype values (1,'CREATE TABLE');
insert into seccmdtype values (2, 'INSERT');
insert into seccmdtype values (3, 'SELECT');
insert into seccmdtype values (4, 'CREATE CLUSTER');
insert into seccmdtype values (5, 'ALTER CLUSTER');
insert into seccmdtype values (6, 'UPDATE');
insert into seccmdtype values (7, 'DELETE');
insert into seccmdtype values (8, 'DROPCLUSTER');
insert into seccmdtype values (9, 'CREATE INDEX');
insert into seccmdtype values (10, 'DROP INDEX');
insert into seccmdtype values (11, 'ALTER INDEX');
insert into seccmdtype values (12, 'DROP TABLE');
insert into seccmdtype values (13, 'CREATE SEQUENCE');
insert into seccmdtype values (14, 'ALTER SEQUENCE');
insert into seccmdtype values (15, 'ALTER TABLE');
insert into seccmdtype values (16, 'DROP SEQUENCE');
insert into seccmdtype values (17, 'GRANT OBJECT');
insert into seccmdtype values (18, 'REVOKE OBJECT');
insert into seccmdtype values (19, 'CREATE SYNONYM');
insert into seccmdtype values (20, 'DROP SYNONYM');
insert into seccmdtype values (21, 'CREATE VIEW');
insert into seccmdtype values (22, 'DROP VIEW');
insert into seccmdtype values (23, 'VALIDATE INDEX');
insert into seccmdtype values (24, 'CREATE PROCEDURE');
insert into seccmdtype values (25, 'ALTER PROCEDURE');
insert into seccmdtype values (26, 'LOCK');
insert into seccmdtype values (27, 'NO-OP');
insert into seccmdtype values (28, 'RENAME');
insert into seccmdtype values (29, 'COMMENT');
insert into seccmdtype values (30, 'AUDIT OBJECT');
insert into seccmdtype values (31, 'NOAUDIT OBJECT');
insert into seccmdtype values (32, 'CREATE DATABASE LINK');
insert into seccmdtype values (33, 'DROP DATABASE LINK');
insert into seccmdtype values (34, 'CREATE DATABASE');
insert into seccmdtype values (35, 'ALTER DATABASE');
insert into seccmdtype values (36, 'CREATE ROLLBACK SEG');
insert into seccmdtype values (37, 'ALTER ROLLBACK SEG');
insert into seccmdtype values (38, 'DROP ROLLBACK SEG');
insert into seccmdtype values (39, 'CREATE TABLESPACE');
insert into seccmdtype values (40, 'ALTER TABLESPACE');
insert into seccmdtype values (41, 'DROP TABLESPACE');
insert into seccmdtype values (42, 'ALTER SESSION');
insert into seccmdtype values (43, 'ALTER USER');
insert into seccmdtype values (44, 'COMMIT');
insert into seccmdtype values (45, 'ROLLBACK');
insert into seccmdtype values (46, 'SAVEPOINT');
insert into seccmdtype values (47, 'PL/SQL EXECUTE');
insert into seccmdtype values (48, 'SET TRANSACTION');
insert into seccmdtype values (49, 'ALTER SYSTEM');
insert into seccmdtype values (50, 'EXPLAIN');
insert into seccmdtype values (51, 'CREATE USER');
insert into seccmdtype values (52, 'CREATE ROLE');
insert into seccmdtype values (53, 'DROP USER');
insert into seccmdtype values (54, 'DROP ROLE');
insert into seccmdtype values (55, 'SET ROLE');
insert into seccmdtype values (56, 'CREATE SCHEMA');
insert into seccmdtype values (57, 'CREATE CONTROL FILE');
insert into seccmdtype values (59, 'CREATE TRIGGER');
insert into seccmdtype values (60, 'ALTER TRIGGER');
insert into seccmdtype values (61, 'DROP TRIGGER');
insert into seccmdtype values (62, 'ANALYZE TABLE');
insert into seccmdtype values (63, 'ANALYZE INDEX');
insert into seccmdtype values (64, 'ANALYZE CLUSTER');
insert into seccmdtype values (65, 'CREATE PROFILE');
insert into seccmdtype values (66, 'DROP PROFILE');
insert into seccmdtype values (67, 'ALTER PROFILE');
insert into seccmdtype values (68, 'DROP PROCEDURE');
insert into seccmdtype values (70, 'ALTER RESOURCE COST');
insert into seccmdtype values (71, 'CREATE SNAPSHOT LOG');
insert into seccmdtype values (72, 'ALTER SNAPSHOT LOG');
insert into seccmdtype values (73, 'DROP SNAPSHOT LOG');
insert into seccmdtype values (74, 'CREATE SNAPSHOT');
insert into seccmdtype values (75, 'ALTER SNAPSHOT');
insert into seccmdtype values (76, 'DROP SNAPSHOT');
insert into seccmdtype values (77, 'CREATE TYPE');
insert into seccmdtype values (78, 'DROP TYPE');
insert into seccmdtype values (79, 'ALTER ROLE');
insert into seccmdtype values (80, 'ALTER TYPE');
insert into seccmdtype values (81, 'CREATE TYPE BODY');
insert into seccmdtype values (82, ' ALTER TYPE BODY');
insert into seccmdtype values (83, 'DROP TYPE BODY');
insert into seccmdtype values (84, 'DROP LIBRARY');
insert into seccmdtype values (85, 'TRUNCATE TABLE');
insert into seccmdtype values (86, 'TRUNCATE CLUSTER');
insert into seccmdtype values (91, 'CREATE FUNCTION');
insert into seccmdtype values (92, 'ALTER FUNCTION');
insert into seccmdtype values (93, 'DROP FUNCTION');
insert into seccmdtype values (94, 'CREATE PACKAGE');
insert into seccmdtype values (95, 'ALTER PACKAGE');
insert into seccmdtype values (96, 'DROP PACKAGE');
insert into seccmdtype values (97, 'CREATE PACKAGE BODY');
insert into seccmdtype values (98, 'ALTER PACKAGE BODY');
insert into seccmdtype values (99, 'DROP PACKAGE BODY');
insert into seccmdtype values (100, 'LOGON');
insert into seccmdtype values (101, 'LOGOFF');
insert into seccmdtype values (102, 'LOGOFF BY CLEANUP');
insert into seccmdtype values (103, 'SESSION REC');
insert into seccmdtype values (104, 'SYSTEM AUDIT');
insert into seccmdtype values (105, 'SYSTEM NOAUDIT');
insert into seccmdtype values (106, 'AUDIT DEFAULT');
insert into seccmdtype values (107, 'NOAUDIT DEFAULT');
insert into seccmdtype values (108, 'SYSTEM GRANT');
insert into seccmdtype values (109, 'SYSTEM REVOKE');
insert into seccmdtype values (110, 'CREATE PUBLIC SYNONYM');
insert into seccmdtype values (111, 'DROP PUBLIC SYNONYM');
insert into seccmdtype values (112, 'CREATE PUBLIC DATABASE LINK');
insert into seccmdtype values (113, 'DROP PUBLIC DATABASE LINK');
insert into seccmdtype values (114, 'GRANT ROLE');
insert into seccmdtype values (115, 'REVOKE ROLE');
insert into seccmdtype values (116, 'EXECUTE PROCEDURE');
insert into seccmdtype values (117, 'USER COMMENT');
insert into seccmdtype values (118, 'ENABLE TRIGGER');
insert into seccmdtype values (119, 'DISABLE TRIGGER');
insert into seccmdtype values ( 120, 'ENABLE ALL TRIGGERS');
insert into seccmdtype values (121, 'DISABLE ALL TRIGGERS');
insert into seccmdtype values (122, 'NETWORK ERROR');
insert into seccmdtype values (123, 'EXECUTE TYPE');
insert into seccmdtype values (157, 'CREATE DIRECTORY');
insert into seccmdtype values (158, 'DROP DIRECTORY');
insert into seccmdtype values (159, 'CREATE LIBRARY');
insert into seccmdtype values (160, 'CREATE JAVA');
insert into seccmdtype values (161, 'ALTER JAVA');
insert into seccmdtype values (162, 'DROP JAVA');
insert into seccmdtype values (163, 'CREATE OPERATOR');
insert into seccmdtype values (164, 'CREATE INDEXTYPE');
insert into seccmdtype values (165, 'DROP INDEXTYPE');
insert into seccmdtype values (167, 'DROP OPERATOR');
insert into seccmdtype values (168, 'ASSOCIATE STATISTICS');
insert into seccmdtype values (169, 'DISASSOCIATE STATISTICS');
insert into seccmdtype values (170, 'CALL METHOD');
insert into seccmdtype values (171, 'CREATE SUMMARY');
insert into seccmdtype values (172, 'ALTER SUMMARY');
insert into seccmdtype values (173, 'DROP SUMMARY');
insert into seccmdtype values (174, 'CREATE DIMENSION');
insert into seccmdtype values (175, 'ALTER DIMENSION');
insert into seccmdtype values (176, 'DROP DIMENSION');
insert into seccmdtype values (177, 'CREATE CONTEXT');
insert into seccmdtype values (178, 'DROP CONTEXT');
insert into seccmdtype values (179, 'ALTER OUTLINE');
insert into seccmdtype values (180, 'CREATE OUTLINE');
insert into seccmdtype values (181, 'DROP OUTLINE');
insert into seccmdtype values (182, 'UPDATE INDEXES');
insert into seccmdtype values (183, 'ALTER OPERATOR');

select
s.sid,
p.spid,
substr(s.program,1,20) program,
decode(s.command,
1,'Create table' , 2,'Insert',
3,'Select' , 6,'Update',
7,'Delete' , 9,'Create index',
10,'Drop index' ,11,'Alter index',
12,'Drop table' ,13,'Create seq',
14,'Alter sequence' ,15,'Alter table',
16,'Drop sequ.' ,17,'Grant',
19,'Create syn.' ,20,'Drop synonym',
21,'Create view' ,22,'Drop view',
23,'Validate index' ,24,'Create procedure',
25,'Alter procedure' ,26,'Lock table',
42,'Alter session' ,44,'Commit',
45,'Rollback' ,46,'Savepoint',
47,'PL/SQL Exec' ,48,'Set Transaction',
60,'Alter trigger' ,62,'Analyse Table',
63,'Analyse index' ,71,'Create Snapshot Log',
72,'Alter Snapshot Log' ,73,'Drop Snapshot Log',
74,'Create Snapshot' ,75,'Alter Snapshot',
76,'drop Snapshot' ,85,'Truncate table',
0,'No command', '? : '||s.command) nocommand
from
v$session s;

1 CREATE TABLE 2 INSERT
3 SELECT 4 CREATE CLUSTER
5 ALTER CLUSTER 6 UPDATE
7 DELETE 8 DROP CLUSTER
9 CREATE INDEX 10 DROP INDEX
11 ALTER INDEX 12 DROP TABLE
13 CREATE SEQUENCE 14 ALTER SEQUENCE
15 ALTER TABLE 16 DROP SEQUENCE
17 GRANT OBJECT 18 REVOKE OBJECT
19 CREATE SYNONYM 20 DROP SYNONYM
21 CREATE VIEW 22 DROP VIEW
23 VALIDATE INDEX 24 CREATE PROCEDURE
25 ALTER PROCEDURE 26 LOCK
27 NO-OP 28 RENAME
29 COMMENT 30 AUDIT OBJECT
31 NOAUDIT OBJECT 32 CREATE DATABASE LINK
33 DROP DATABASE LINK 34 CREATE DATABASE
35 ALTER DATABASE 36 CREATE ROLLBACK SEG
37 ALTER ROLLBACK SEG 38 DROP ROLLBACK SEG
39 CREATE TABLESPACE 40 ALTER TABLESPACE
41 DROP TABLESPACE 42 ALTER SESSION
43 ALTER USER 44 COMMIT
45 ROLLBACK 46 SAVEPOINT
47 PL/SQL EXECUTE 48 SET TRANSACTION
49 ALTER SYSTEM 50 EXPLAIN
51 CREATE USER 52 CREATE ROLE
53 DROP USER 54 DROP ROLE
55 SET ROLE 56 CREATE SCHEMA
57 CREATE CONTROL FILE 59 CREATE TRIGGER
60 ALTER TRIGGER 61 DROP TRIGGER
62 ANALYZE TABLE 63 ANALYZE INDEX
64 ANALYZE CLUSTER 65 CREATE PROFILE
66 DROP PROFILE 67 ALTER PROFILE
68 DROP PROCEDURE 70 ALTER RESOURCE COST
71 CREATE SNAPSHOT LOG 72 ALTER SNAPSHOT LOG
73 DROP SNAPSHOT LOG 74 CREATE SNAPSHOT
75 ALTER SNAPSHOT 76 DROP SNAPSHOT
77 CREATE TYPE 78 DROP TYPE
79 ALTER ROLE 80 ALTER TYPE
81 CREATE TYPE BODY 82 ALTER TYPE BODY
83 DROP TYPE BODY 84 DROP LIBRARY
85 TRUNCATE TABLE 86 TRUNCATE CLUSTER
91 CREATE FUNCTION 92 ALTER FUNCTION
93 DROP FUNCTION 94 CREATE PACKAGE
95 ALTER PACKAGE 96 DROP PACKAGE
97 CREATE PACKAGE BODY 98 ALTER PACKAGE BODY
99 DROP PACKAGE BODY 100 LOGON
101 LOGOFF 102 LOGOFF BY CLEANUP
103 SESSION REC 104 SYSTEM AUDIT
105 SYSTEM NOAUDIT 106 AUDIT DEFAULT
107 NOAUDIT DEFAULT 108 SYSTEM GRANT
109 SYSTEM REVOKE 110 CREATE PUBLIC SYNONYM
111 DROP PUBLIC SYNONYM 112 CREATE PUBLIC DATABASE LINK
113 DROP PUBLIC DB LINK 114 GRANT ROLE
115 REVOKE ROLE 116 EXECUTE PROCEDURE
117 USER COMMENT 118 ENABLE TRIGGER
119 DISABLE TRIGGER 120 ENABLE ALL TRIGGERS
121 DISABLE ALL TRIGGERS 122 NETWORK ERROR
123 EXECUTE TYPE 157 CREATE DIRECTORY
158 DROP DIRECTORY 159 CREATE LIBRARY
160 CREATE JAVA 161 ALTER JAVA
162 DROP JAVA 163 CREATE OPERATOR
164 CREATE INDEXTYPE 165 DROP INDEXTYPE
167 DROP OPERATOR 168 ASSOCIATE STATISTICS
169 DISASSOCIATE STATISTICS 170 CALL METHOD
171 CREATE SUMMARY 172 ALTER SUMMARY
173 DROP SUMMARY 174 CREATE DIMENSION
175 ALTER DIMENSION 176 DROP DIMENSION
177 CREATE CONTEXT 178 DROP CONTEXT
179 ALTER OUTLINE 180 CREATE OUTLINE
181 DROP OUTLINE 182 UPDATE INDEXES
183 ALTER OPERATOR

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/756652/viewspace-242513/，如需轉載，請註明出處，否則將追究法律責任。