了解oracle内部数字的含义总是让人渴望!查了半天command_type的各个含义,没查到,不过却看到了这个!
select inst_id,
kglnaown,
kglnaobj,
kglnadlk,
decode(kglhdnsp,
0,'CURSOR',
1,'TABLE/PROCEDURE',
2,'BODY',
3,'TRIGGER',
4,'INDEX',
5,'CLUSTER',
6,'OBJECT',
13,'JAVA SOURCE',
14,'JAVA RESOURCE',
15,'REPLICATED TABLE OBJECT',
16,'REPLICATION INTERNAL PACKAGE',
17,'CONTEXT POLICY',
18,'PUB_SUB',
19,'SUMMARY',
20,'DIMENSION',
21,'APP CONTEXT',
22,'STORED OUTLINE',
23,'RULESET',
24,'RSRC PLAN',
25,'RSRC CONSUMER GROUP',
26,'PENDING RSRC PLAN',
27, 'PENDING RSRC CONSUMER GROUP',
28,'SUBSCRIPTION',
29,'LOCATION',
30,'REMOTE OBJECT',
31,'SNAPSHOT METADATA',
32,'JAVA SHARED DATA',
33,'SECURITY PROFILE',
'INVALID NAMESPACE'),
decode(bitand(kglobflg, 3),
0,'NOT LOADED',
2,'NON-EXISTENT',
3,'INVALID STATUS',
decode(kglobtyp,
0,'CURSOR',
1,'INDEX',
2,'TABLE',
3,'CLUSTER',
4,'VIEW',
5,'SYNONYM',
6,'SEQUENCE',
7,'PROCEDURE',
8,'FUNCTION',
9,'PACKAGE',
10,'NON-EXISTENT',
11, 'PACKAGE BODY',
12,'TRIGGER',
13,'TYPE',
14,'TYPEBODY',
15,'OBJECT',
16,'USER',
17,'DBLINK',
18,'PIPE',
19,'TABLE PARTITION',
20,'INDEX PARTITION',
21,'LOB',
22,'LIBRARY',
23,'DIRECTORY',
24,'QUEUE',
25,'INDEX-ORGANIZED TABLE',
26,'REPLICATION OBJECT GROUP',
27,'REPLICATION PROPAGATOR',
28,'JAVA SOURCE',
29,'JAVA CLASS',
30,'JAVA RESOURCE',
31,'JAVA JAR',
32,'INDEX TYPE',
33,'OPERATOR',
34,'TABLE SUBPARTITION',
35,'INDEX SUBPARTITION',
36,'REPLICATED TABLE OBJECT',
37,'REPLICATION INTERNAL PACKAGE',
38,'CONTEXT POLICY',
39, 'PUB_SUB',
40,'LOB PARTITION',
41,'LOB SUBPARTITION',
42,'SUMMARY',
43,'DIMENSION',
44,'APP CONTEXT',
45,'STORED OUTLINE',
46,'RULESET',
47,'RSRC PLAN',
48,'RSRC CONSUMER GROUP',
49,'PENDING RSRC PLAN',
50,'PENDING RSRC CONSUMER GROUP',
51,'SUBSCRIPTION',
52,'LOCATION',
53,'REMOTE OBJECT',
54,'SNAPSHOT METADATA',
55, 'IFS',
56,'JAVA SHARED DATA',
57,'SECURITY PROFILE',
'INVALID TYPE')),
kglobhs0 + kglobhs1 + kglobhs2 + kglobhs3 + kglobhs4 + kglobhs5 + kglobhs6,
kglhdldc,
kglhdexc,
kglhdlkc,
kglobpc0,
decode(kglhdkmk, 0, 'NO', 'YES'),
kglhdclt
from x$kglob
select inst_id,
kglnaown,
kglnaobj,
kglnadlk,
decode(kglhdnsp,
0,'CURSOR',
1,'TABLE/PROCEDURE',
2,'BODY',
3,'TRIGGER',
4,'INDEX',
5,'CLUSTER',
6,'OBJECT',
13,'JAVA SOURCE',
14,'JAVA RESOURCE',
15,'REPLICATED TABLE OBJECT',
16,'REPLICATION INTERNAL PACKAGE',
17,'CONTEXT POLICY',
18,'PUB_SUB',
19,'SUMMARY',
20,'DIMENSION',
21,'APP CONTEXT',
22,'STORED OUTLINE',
23,'RULESET',
24,'RSRC PLAN',
25,'RSRC CONSUMER GROUP',
26,'PENDING RSRC PLAN',
27, 'PENDING RSRC CONSUMER GROUP',
28,'SUBSCRIPTION',
29,'LOCATION',
30,'REMOTE OBJECT',
31,'SNAPSHOT METADATA',
32,'JAVA SHARED DATA',
33,'SECURITY PROFILE',
'INVALID NAMESPACE'),
decode(bitand(kglobflg, 3),
0,'NOT LOADED',
2,'NON-EXISTENT',
3,'INVALID STATUS',
decode(kglobtyp,
0,'CURSOR',
1,'INDEX',
2,'TABLE',
3,'CLUSTER',
4,'VIEW',
5,'SYNONYM',
6,'SEQUENCE',
7,'PROCEDURE',
8,'FUNCTION',
9,'PACKAGE',
10,'NON-EXISTENT',
11, 'PACKAGE BODY',
12,'TRIGGER',
13,'TYPE',
14,'TYPEBODY',
15,'OBJECT',
16,'USER',
17,'DBLINK',
18,'PIPE',
19,'TABLE PARTITION',
20,'INDEX PARTITION',
21,'LOB',
22,'LIBRARY',
23,'DIRECTORY',
24,'QUEUE',
25,'INDEX-ORGANIZED TABLE',
26,'REPLICATION OBJECT GROUP',
27,'REPLICATION PROPAGATOR',
28,'JAVA SOURCE',
29,'JAVA CLASS',
30,'JAVA RESOURCE',
31,'JAVA JAR',
32,'INDEX TYPE',
33,'OPERATOR',
34,'TABLE SUBPARTITION',
35,'INDEX SUBPARTITION',
36,'REPLICATED TABLE OBJECT',
37,'REPLICATION INTERNAL PACKAGE',
38,'CONTEXT POLICY',
39, 'PUB_SUB',
40,'LOB PARTITION',
41,'LOB SUBPARTITION',
42,'SUMMARY',
43,'DIMENSION',
44,'APP CONTEXT',
45,'STORED OUTLINE',
46,'RULESET',
47,'RSRC PLAN',
48,'RSRC CONSUMER GROUP',
49,'PENDING RSRC PLAN',
50,'PENDING RSRC CONSUMER GROUP',
51,'SUBSCRIPTION',
52,'LOCATION',
53,'REMOTE OBJECT',
54,'SNAPSHOT METADATA',
55, 'IFS',
56,'JAVA SHARED DATA',
57,'SECURITY PROFILE',
'INVALID TYPE')),
kglobhs0 + kglobhs1 + kglobhs2 + kglobhs3 + kglobhs4 + kglobhs5 + kglobhs6,
kglhdldc,
kglhdexc,
kglhdlkc,
kglobpc0,
decode(kglhdkmk, 0, 'NO', 'YES'),
kglhdclt
from x$kglob
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25702/viewspace-464251/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25702/viewspace-464251/