神通数据库OSRDB_20220422162214巡检报告

巡检人:小麦苗 QQ:646634621 微信公众号: DB宝提供OCP、OCM、高可用( rac+dg) 、PostgreSQL和MySQL培训 BLOG地址: https://www.dbaup.com 若需要脚本可私聊我

神通数据库OSRDB巡检报告

巡检人: 小麦苗([QQ: 646634621] [微信公众号: DB宝] [提供OCP、OCM、高可用、MySQL和PostgreSQL最实用的培训])
版本号: v7.0.0
修改日期: 2022-4-22
巡检日期: 2022-04-22 16:22:14

[转到页底]

总体概况	神通版本信息	神通数据库信息	神通实例信息	表空间情况
总体概况	数据文件情况	日志组情况	配置参数	所有用户
对象统计	神通表大小top10	神通索引大小top10
会话情况	数据库阻塞信息
归档信息
其它	DBA_DB_LINKS
高可用

总体概况

● 神通版本信息
VERSION

神通数据库7.0.8.191204 for Linux(x86 64bit) (200 connections) (license invalid after 89 days)

VERSION
神通数据库7.0.8.191204 for Linux(x86 64bit) (200 connections) (license invalid after 89 days)

● 神通数据库信息( V_SYS_DATABASE_INFO)
DBNAME CREATIONTIME RESTARTLSN ARCHIVEMODE ARCHIVEPATH ARCHIVELSN LOGTOTALSIZE LOGUSAGERATIO LOGAUTOSHRINK 字符集

OSRDB 2022-04-21 16:27:48 98994688 ARCHIVELOG /opt/ShenTong/arch/OSRDB 99040256 209715200 0 on UTF8

DBNAME	CREATIONTIME	RESTARTLSN	ARCHIVEMODE	ARCHIVEPATH	ARCHIVELSN	LOGTOTALSIZE	LOGUSAGERATIO	LOGAUTOSHRINK	字符集
OSRDB	2022-04-21 16:27:48	98994688	ARCHIVELOG	/opt/ShenTong/arch/OSRDB	99040256	209715200	0	on	UTF8

● V$DATABASE

● 实例信息
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS PARALLEL LOGINS SHUTDOWN_PENDING DATABASE_STATUS STARTUP_MODE ARCHIVE DATABASE_STATUS_PREV

1 OSRDB lhrshentongdb 神通数据库7.0.8.191204 for Linux(x86 64bit) 2022-04-21 OPENED NO ALLOWED READ WRITE SERVICE YES READ WRITE

INSTANCE_NUMBER	INSTANCE_NAME	HOST_NAME	VERSION	STARTUP_TIME	STATUS	PARALLEL	LOGINS	SHUTDOWN_PENDING	DATABASE_STATUS	STARTUP_MODE	ARCHIVE	DATABASE_STATUS_PREV
1	OSRDB	lhrshentongdb	神通数据库7.0.8.191204 for Linux(x86 64bit)	2022-04-21	OPENED	NO	ALLOWED		READ WRITE	SERVICE	YES	READ WRITE

[回到目录]

表空间情况

● 表空间情况
TSNAME PATH File Count Size(MB) Free Size(MB) Used Size(MB)

UNDOTS01 /opt/ShenTong/odbs/OSRDB/undots01.dbf 1 128 49.4375 78.5625

TEMP /opt/ShenTong/odbs/OSRDB/OSRDBtmp01.dbf 1 100 99.9375 0.0625

AUDIT /opt/ShenTong/odbs/OSRDB/OSRDBaux01.dbf 1 100 88.0625 11.9375

SYSTEM /opt/ShenTong/odbs/OSRDB/OSRDB01.dbf 1 450 8.5625 441.4375

TSNAME	PATH	File Count	Size(MB)	Free Size(MB)	Used Size(MB)
UNDOTS01	/opt/ShenTong/odbs/OSRDB/undots01.dbf	1	128	49.4375	78.5625
TEMP	/opt/ShenTong/odbs/OSRDB/OSRDBtmp01.dbf	1	100	99.9375	0.0625
AUDIT	/opt/ShenTong/odbs/OSRDB/OSRDBaux01.dbf	1	100	88.0625	11.9375
SYSTEM	/opt/ShenTong/odbs/OSRDB/OSRDB01.dbf	1	450	8.5625	441.4375

● 数据库占用的有效空间
all_size_MB

453MB

all_size_MB
453MB

● 各个模式占用的有效空间
USENAME TOTAL_SPACE

LHR 309.8125M

SYSAUDIT 10.75M

SYSDBA 132.4375M

USENAME	TOTAL_SPACE
LHR	309.8125M
SYSAUDIT	10.75M
SYSDBA	132.4375M

[回到目录]

● 数据文件情况
FILEID TSNAME PATH CURRENT_SIZE_MB FREESIZE_MB USEDSIZE_MB PCT_USED(%) MAX_SIZE NEXTSIZE_MB CREATIONTIME

0 SYSTEM /opt/ShenTong/odbs/OSRDB/OSRDB01.dbf 450 8 441 98.09 0 10 2022-04-21 16:27:52

1 UNDOTS01 /opt/ShenTong/odbs/OSRDB/undots01.dbf 128 49 78 61.37 0 8 2022-04-21 16:27:53

2 TEMP /opt/ShenTong/odbs/OSRDB/OSRDBtmp01.dbf 100 99 0 0.06 0 10 2022-04-21 16:27:56

3 AUDIT /opt/ShenTong/odbs/OSRDB/OSRDBaux01.dbf 100 88 11 11.93 0 10 2022-04-21 16:27:57

FILEID	TSNAME	PATH	CURRENT_SIZE_MB	FREESIZE_MB	USEDSIZE_MB	PCT_USED(%)	NEXTSIZE_MB	CREATIONTIME
0	SYSTEM	/opt/ShenTong/odbs/OSRDB/OSRDB01.dbf	450	8	441	98.09	10	2022-04-21 16:27:52
1	UNDOTS01	/opt/ShenTong/odbs/OSRDB/undots01.dbf	128	49	78	61.37	8	2022-04-21 16:27:53
2	TEMP	/opt/ShenTong/odbs/OSRDB/OSRDBtmp01.dbf	100	99	0	0.06	10	2022-04-21 16:27:56
3	AUDIT	/opt/ShenTong/odbs/OSRDB/OSRDBaux01.dbf	100	88	11	11.93	10	2022-04-21 16:27:57

● 日志组情况
GROUPID CREATIONTIME SIZE_MB ISACTIVE STARTLSN PATH ISARCHIVED

0 2022-04-21 16:27:49 200 ON LINE 0 /opt/ShenTong/odbs/OSRDB/REDO.log NO

GROUPID	CREATIONTIME	SIZE_MB	ISACTIVE	STARTLSN	PATH	ISARCHIVED
0	2022-04-21 16:27:49	200	ON LINE	0	/opt/ShenTong/odbs/OSRDB/REDO.log	NO

● 日志情况
FILEID PATH CREATIONTIME SCALEEXTEND Init Size(MB) Real Size(MB) Next Size(MB) Max Size(MB) ISACTIVE Free Size(MB) Used Size(MB) USAGERATIO

0 /opt/ShenTong/odbs/OSRDB/REDO.log 2022-04-21 16:27:49 t 200 200 0 2097151 ON LINE 180.54 19.46 9.73

FILEID	PATH	CREATIONTIME	SCALEEXTEND	Init Size(MB)	Real Size(MB)	Next Size(MB)	Max Size(MB)	ISACTIVE	Free Size(MB)	Used Size(MB)	USAGERATIO
0	/opt/ShenTong/odbs/OSRDB/REDO.log	2022-04-21 16:27:49	t	200	200	0	2097151	ON LINE	180.54	19.46	9.73

[回到目录]

配置参数

NUM	NAME	TYPE	VALUE	DISPLAY_VALUE	ISDEFAULT	ISSES_MODIFIABLE	ISSYS_MODIFIABLE	ISDEPRECATED	ISBASIC
0	_ENABLE_RANDOM_REWRITE_TEST_LIMITATION	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
1	_INSERT_SELECT_LIMIT	3	0	0	TRUE	TRUE	TRUE	FALSE	TRUE
2	ADD_MISSING_FROM	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
3	ADD_WHITESPACE_TO_INDEXNAME	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
4	AIO_READ_THREAD_COUNT	3	4	4	TRUE	FALSE	FALSE	FALSE	TRUE
5	AIO_WRITE_THREAD_COUNT	3	4	4	TRUE	FALSE	FALSE	FALSE	TRUE
6	ALLOW_UPDATE_UNDER_RUC	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
7	APPLY_DO_TABLE	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
8	APPLY_DO_USER	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
9	APPLY_IGNORE_TABLE	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
10	APPLY_IGNORE_USER	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
11	AUD_DB_STATUS	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
12	AUD_DUMP_FREE_SIZE	3	128	128	TRUE	FALSE	TRUE	FALSE	TRUE
13	AUD_DUMP_FREE_TIMEINTERVAL	3	300	300	TRUE	FALSE	FALSE	FALSE	TRUE
14	AUD_IS_ON	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
15	AUD_TRL_WRT_ERR	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
16	AUTHENTICATION_TIMEOUT	3	60	60	TRUE	FALSE	FALSE	FALSE	TRUE
17	AUTOCOMMIT	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
18	BINLOG_CACHE_MAX_SIZE	4	4.29497e+09	4.29497e+09	TRUE	FALSE	FALSE	FALSE	TRUE
19	BINLOG_CACHE_SIZE	4	32768	32768	TRUE	FALSE	FALSE	FALSE	TRUE
20	BINLOG_DO_USER	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
21	BINLOG_FLUSH_INTERVAL	3	3000	3000	TRUE	FALSE	FALSE	FALSE	TRUE
22	BINLOG_IGNORE_USER	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
23	BINLOG_INDEX_FILENAME	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
24	BINLOG_LOG_FILENAME	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
25	BT_PREFETCH_PAGE	3	64	64	TRUE	FALSE	TRUE	FALSE	TRUE
26	BT_SWITCHES_BEFORE_PREFETCH	3	2	2	TRUE	FALSE	TRUE	FALSE	TRUE
27	BUF_DATA_BUFFER_PAGES	3	8192	8192	TRUE	FALSE	FALSE	FALSE	TRUE
28	BUF_DIRTY_PAGE_COUNT_UPPERBOUND	3	200000	200000	TRUE	FALSE	FALSE	FALSE	TRUE
29	BUF_DP_BUFFER_PAGES	3	256	256	TRUE	FALSE	TRUE	FALSE	TRUE
30	BUF_FLUSH_GIVE_PRECEDENCE_MAX_SECONDS	3	5	5	TRUE	FALSE	TRUE	FALSE	TRUE
31	BUF_GROUP_WRITE_SIZE	3	128	128	TRUE	FALSE	FALSE	FALSE	TRUE
32	BUF_LSN_SPAN_UPPERBOUND	4	1e+09	1e+09	TRUE	FALSE	FALSE	FALSE	TRUE
33	BUF_SCAN_THRESHOLD	3	1024	1024	TRUE	FALSE	FALSE	FALSE	TRUE
34	CA_CERTIFICATE_FILE	2	ca.crt	ca.crt	TRUE	FALSE	FALSE	FALSE	TRUE
35	CA_CRL_FILE	2	ca.crl	ca.crl	TRUE	FALSE	FALSE	FALSE	TRUE
36	CHECK_LOGIN_COUNT	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
37	CHECK_PWD_HISTORY	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
38	CIPHER_LIST	2	ALL:!aNULL:!eNULL:!DH:@STRENGTH	ALL:!aNULL:!eNULL:!DH:@STRENGTH	TRUE	FALSE	FALSE	FALSE	TRUE
39	CLIENT_ENCODING	2	SQL_ASCII	SQL_ASCII	TRUE	TRUE	TRUE	FALSE	TRUE
40	CLIENT_MIN_MESSAGES	2	notice	notice	TRUE	TRUE	TRUE	FALSE	TRUE
41	COMPATABLE_DBMS	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
42	COMPATABLE_UNSECURE_OSCAR_CLIENT	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
43	CORRE_JOINSELEC	4	0.5	0.5	TRUE	FALSE	TRUE	FALSE	TRUE
44	CORRE_RELSELEC	4	1	1	TRUE	FALSE	TRUE	FALSE	TRUE
45	CPU_AFFINITY_MODE	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
46	CPU_INDEX_TUPLE_COST	4	0.001	0.001	TRUE	FALSE	TRUE	FALSE	TRUE
47	CPU_LIMIT_NUM	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
48	CPU_OPERATOR_COST	4	0.0025	0.0025	TRUE	FALSE	TRUE	FALSE	TRUE
49	CPU_TUPLE_COST	4	0.01	0.01	TRUE	FALSE	TRUE	FALSE	TRUE
50	DATEFORMAT	2	unset	unset	TRUE	TRUE	TRUE	FALSE	TRUE
51	DATEORDER	2	YMD	YMD	TRUE	TRUE	TRUE	FALSE	TRUE
52	DATESTYLE	2	YMD	YMD	TRUE	TRUE	TRUE	FALSE	TRUE
53	DB_MAX_INSERT_VALUES_NUM	3	500000	500000	TRUE	FALSE	TRUE	FALSE	TRUE
54	DBLINK_CHAR_SIZE	3	3	3	TRUE	TRUE	TRUE	FALSE	TRUE
55	DBLINK_FETCH_SIZE	3	512	512	TRUE	FALSE	TRUE	FALSE	TRUE
56	DDLCOMMITBEHAVIOR	3	0	0	TRUE	TRUE	TRUE	FALSE	TRUE
57	DEBUG_PRINT_SQL	3	0	0	TRUE	FALSE	TRUE	FALSE	TRUE
58	DEBUG_PRINT_SQL_PARAM	3	0	0	TRUE	FALSE	TRUE	FALSE	TRUE
59	DEFAULT_TABLE_TYPE	2	kstore	kstore	TRUE	FALSE	FALSE	FALSE	TRUE
60	DEFAULT_TRANSACTION_ISOLATION	2	read committed	read committed	TRUE	TRUE	TRUE	FALSE	TRUE
61	DEFAULT_VARCHAR_LEN	3	1	1	TRUE	FALSE	FALSE	FALSE	TRUE
62	DISABLE_COST	4	1e+08	1e+08	TRUE	FALSE	TRUE	FALSE	TRUE
63	DISABLE_DMM	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
65	DOUBLE_WRITE_FILE_PATH	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
66	DUMP_MEM_CHECK_INTERVAL	3	60	60	TRUE	FALSE	FALSE	FALSE	TRUE
67	DUMP_MEM_SPEEDUP_THRESHOLD	3	10	10	TRUE	FALSE	FALSE	FALSE	TRUE
68	DUMP_MEM_THRESHOLD	3	100	100	TRUE	FALSE	FALSE	FALSE	TRUE
69	EAGER_RELEASE_ROWLOCKS	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
70	EFFECTIVE_CACHE_SIZE	4	1000	1000	TRUE	FALSE	TRUE	FALSE	TRUE
71	ELOG_FILE_NUM	3	10	10	TRUE	FALSE	TRUE	FALSE	TRUE
72	ELOG_FILE_SIZE	3	512	512	TRUE	FALSE	TRUE	FALSE	TRUE
73	ENABLE_ADDAGGTOSUBLINK	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
74	ENABLE_ADJUST_BEST_INNERJOIN	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
75	ENABLE_ADJUST_HUGEHJ	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
76	ENABLE_ADJUSTIDXPRI	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
77	ENABLE_ADVANCED_SCHEDULER	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
78	ENABLE_ALERT_SERVER	1	TRUE	TRUE	TRUE	FALSE	TRUE	FALSE	TRUE
80	ENABLE_APPLY_WRITE_BINLOG	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
81	ENABLE_AUD_DUMP_FREE	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
82	ENABLE_AUTH_FINGERPRINT	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
83	ENABLE_AUTH_RADIUS	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
84	ENABLE_AUTO_MODIFY_FTS_PWD	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
85	ENABLE_AUTO_STAT	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
86	ENABLE_AUTO_STAT_PAGELEVEL_SAMPLE	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
87	ENABLE_AUTO_VALUE_ON_ZERO	1	TRUE	TRUE	TRUE	FALSE	TRUE	FALSE	TRUE
88	ENABLE_BINLOG	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
89	ENABLE_BITMAPINDEXSCAN	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
90	ENABLE_BROKENJOIN	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
91	ENABLE_BTYPE_EXPLICIT	1	TRUE	TRUE	TRUE	FALSE	TRUE	FALSE	TRUE
92	ENABLE_BULKNESTLOOP	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
93	ENABLE_CHARACTER_LENGTH	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
94	ENABLE_CHECK_COL_PRIVILEGE	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
95	ENABLE_CHECK_SUM	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
96	ENABLE_COLLECTION_PRIORITY	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
97	ENABLE_CORRE_JOINSELEC	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
98	ENABLE_CORRE_RELSELEC	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
99	ENABLE_COUNT_INDEX_SCAN	1	TRUE	TRUE	TRUE	FALSE	TRUE	FALSE	TRUE
100	ENABLE_DDL_SERIALIZE	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
101	ENABLE_DEDCONST	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
102	ENABLE_DELETESCANTARGET	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
103	ENABLE_DELETESUBQUERYTARGET	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
104	ENABLE_DISTINCTSORT	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
105	ENABLE_DOUBLE_WRITE	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
106	ENABLE_DYNAMIC_SEQ_START_ATTR	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
107	ENABLE_ELIMINATE_JOIN	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
108	ENABLE_ELIMINATE_SEMI	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
109	ENABLE_EMPTY_STRING_AS_ZERO	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
110	ENABLE_EPC	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
111	ENABLE_EXPAND_AEXPR_IN	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
112	ENABLE_EXPANDOR	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
113	ENABLE_EXPRESSION_INDEX	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
114	ENABLE_EXPRESSION_STAT	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
115	ENABLE_FAST_RESULTCACHE	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
116	ENABLE_FASTINDEXSCAN	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
117	ENABLE_FILE_INOTIFY	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
118	ENABLE_FLASHBACK_QUERY_LOB_AS_NULL	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
119	ENABLE_FLASHBACK_QUERY_USE_ARCHIVELOG	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
120	ENABLE_FLUSHLOG_AT_COMMIT	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
121	ENABLE_FULLTEXT	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
122	ENABLE_FUNCHASH	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
123	ENABLE_FUNCMERGE	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
124	ENABLE_GEQO	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
125	ENABLE_GUID_GROUP	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
126	ENABLE_HA_RAFT_DETAIL_LOG	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
127	ENABLE_HA_SINGLE_ALIVE	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
128	ENABLE_HA_SLAVE_REDO_PIPELINE	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
129	ENABLE_HA_SLAVE_SHOW_MSG	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
130	ENABLE_HA_SLAVE_SYNC_REDO	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
131	ENABLE_HA_WRITE_WAIT	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
132	ENABLE_HASH_MEM	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
133	ENABLE_HASHAGG	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
134	ENABLE_HASHEDSUBPLAN	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
135	ENABLE_HASHJOIN	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
136	ENABLE_HASHUNION	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
137	ENABLE_HASHUNIQUE	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
138	ENABLE_HIERAR_USE_MINMEM	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
139	ENABLE_INDEXSCAN	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
140	ENABLE_IPV6	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
141	ENABLE_KEYWORD_IDENTIFY	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
142	ENABLE_LIMITNSORT	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
143	ENABLE_LOG_SQL	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
144	ENABLE_MAC_CONTROL	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
145	ENABLE_MANUAL_UNDO	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
146	ENABLE_MATERIAL	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
147	ENABLE_MBSTR_ENCODING_VERIFY	1	TRUE	TRUE	TRUE	FALSE	TRUE	FALSE	TRUE
148	ENABLE_MERGEAPPEND	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
149	ENABLE_MERGEJOIN	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
150	ENABLE_MULTI_FORCE_PARALLEL	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
151	ENABLE_MULTIDIMENSION_STAT	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
152	ENABLE_MUST_INDEXSCAN	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
153	ENABLE_MUTIHASH	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
154	ENABLE_MVIEW	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
155	ENABLE_MVIEW_REWRITE	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
156	ENABLE_MVIEW_SEMANTIC_REWRITE	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
157	ENABLE_NATIVE_AIO	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
158	ENABLE_NESTLOOP	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
159	ENABLE_NOPUSHDOWNSUB	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
160	ENABLE_NORMAL_NOLOGGING	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
161	ENABLE_OFFLINEOPT	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
162	ENABLE_OFFLINEOPT_INIT	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
163	ENABLE_OFFLINEOPT_MATERIAL_JOIN	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
164	ENABLE_OFFLINEOPT_READ	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
165	ENABLE_OFFLINEOPT_WRITE	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
166	ENABLE_OP_CPUTIME_STAT	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
167	ENABLE_OPERATING_SYSTEM_AUTHENT	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
168	ENABLE_ORACLE_OPER	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
169	ENABLE_OZSORT	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
170	ENABLE_PAGEMODE	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
171	ENABLE_PARALLEL	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
172	ENABLE_PARALLEL_DELETE	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
173	ENABLE_PARALLEL_DML	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
174	ENABLE_PARALLEL_INX	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
175	ENABLE_PARALLEL_MERGEAPPEND	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
176	ENABLE_PARALLEL_WAIT	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
177	ENABLE_PARTEXCLUDE	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
178	ENABLE_PARTITIONINDEX	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
179	ENABLE_PATHDEBUG	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
180	ENABLE_PL_PLANCACHE	1	TRUE	TRUE	TRUE	FALSE	TRUE	FALSE	TRUE
181	ENABLE_PPC	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
182	ENABLE_PRINT_TIME	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
183	ENABLE_PTEXCLUDE_DETAIL	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
184	ENABLE_PULLUP_SUBPLANS	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
185	ENABLE_PULLUPGROUP	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
186	ENABLE_PULLUPSUB_WITHAGG	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
187	ENABLE_PULLUPSUB_WITHGROUP	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
188	ENABLE_PUSHDOWNGROUP	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
189	ENABLE_PUTDOWN_SUBQUERY_QUAL	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
190	ENABLE_QSORT_MERGE	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
191	ENABLE_QSORT_TRIM	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
192	ENABLE_READ_ON_DP_INSERT	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
193	ENABLE_RECYCLEBIN	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
194	ENABLE_REDUCEDUPORS	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
195	ENABLE_REDUCEOUTJOIN	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
196	ENABLE_RESET_LOGFILE	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
197	ENABLE_RESULT_CACHE	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
198	ENABLE_RESULT_CACHE_PREFETCH	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
199	ENABLE_REUSE	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
200	ENABLE_REWRITE_ALL_IGNORE_NULL	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
201	ENABLE_RIGHT_SEMI	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
202	ENABLE_ROWCOUNTMATERIAL	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
203	ENABLE_RULETRANS	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
204	ENABLE_RUNTIME_DIAG	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
205	ENABLE_SCAN_LOCK_NO_WAIT	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
206	ENABLE_SELECT_TIME_CHECK	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
207	ENABLE_SELF_ADAPTION_RSC	1	TRUE	TRUE	TRUE	FALSE	TRUE	FALSE	TRUE
208	ENABLE_SEQSCAN	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
209	ENABLE_SHREDDER	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
210	ENABLE_SINGLE_PARSER	1	TRUE	TRUE	TRUE	FALSE	TRUE	FALSE	TRUE
211	ENABLE_SLAVE_QUERY_SYNC	1	TRUE	TRUE	TRUE	FALSE	TRUE	FALSE	TRUE
212	ENABLE_SORT	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
213	ENABLE_SORT_PRINT	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
214	ENABLE_SORTAGG	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
215	ENABLE_SPC	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
216	ENABLE_SPC_COMPATIBLE	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
217	ENABLE_SPC_CONST_TRANS	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
218	ENABLE_SPLITOR	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
219	ENABLE_SQL_STAT	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
220	ENABLE_SQL_TRACE	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
221	ENABLE_SQL_TRACE_WAIT	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
222	ENABLE_SQL_TRANS	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
223	ENABLE_STAT_PROFILE	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
224	ENABLE_SUBPLAN_RESULT_HASH	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
225	ENABLE_TABLE_LOCK	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
226	ENABLE_THREADPOOL	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
227	ENABLE_TIDSCAN	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
228	ENABLE_TIME_STAT	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
229	ENABLE_TREEDUMP_KEY	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
230	ENABLE_UNBLOCK_INX_SCAN	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
231	ENABLE_UNBLOCK_SCAN	1	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE
232	ENABLE_USER_ACCESS_COUNT	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
233	ENABLE_USETABLELOCK	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
234	ENABLE_WHITELIST	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
235	ENABLE_WISEJOIN	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
236	ENABLE_XQUERY	3	1	1	TRUE	TRUE	TRUE	FALSE	TRUE
237	EPC_REG_COUNT	3	32767	32767	TRUE	TRUE	TRUE	FALSE	TRUE
238	ERROR_STACK_DUMP_PATH	2	/opt/ShenTong/dump	/opt/ShenTong/dump	TRUE	FALSE	TRUE	FALSE	TRUE
239	EVENT	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
240	EXIT_ON_SESSION_TIMEOUT	1	TRUE	TRUE	TRUE	FALSE	TRUE	FALSE	TRUE
241	EXPIRE_BINLOG_DAYS	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
242	EXTERNAL_ENGINE_PATH	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
243	EXTRA_FLOAT_DIGITS	3	0	0	TRUE	TRUE	TRUE	FALSE	TRUE
244	EXTRA_REAL_DIGITS	3	2	2	TRUE	TRUE	TRUE	FALSE	TRUE
245	FILE_IO_OPTION	2	DIRECT	DIRECT	TRUE	FALSE	FALSE	FALSE	TRUE
246	FILT_AND_REPLACE_MODE	3	0	0	TRUE	TRUE	TRUE	FALSE	TRUE
247	FLASHBACK_MEM	3	1048576	1048576	TRUE	FALSE	TRUE	FALSE	TRUE
248	FORCE_ORDER_BY_ROWNUM	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
249	FROM_COLLAPSE_LIMIT	3	8	8	TRUE	TRUE	TRUE	FALSE	TRUE
250	FTS_DEBUG	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
251	FTS_FETCHSIZE	3	1024	1024	TRUE	FALSE	FALSE	FALSE	TRUE
252	FTS_JVM_PATH	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
253	FULL_WIDTH_CHAR_COMPATIBLE	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
254	GROUP_COUNT_ADJUST	4	1.3	1.3	TRUE	FALSE	TRUE	FALSE	TRUE
255	HA_AGENT_PORT	3	4449	4449	TRUE	FALSE	FALSE	FALSE	TRUE
256	HA_ELECTION_TIMEOUT_MS	3	10000	10000	TRUE	FALSE	FALSE	FALSE	TRUE
257	HA_GATEWAY	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
258	HA_HEARTBEAT_PERIOD_MS	3	1000	1000	TRUE	FALSE	FALSE	FALSE	TRUE
259	HA_LOCAL_NET_DEV_NAME	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
260	HA_LOG_COMPRESS_MIN_BLOCK_NUM	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
261	HA_LOG_MASTER_SEND_BUF_BLOCK_NUM	3	8192	8192	TRUE	FALSE	FALSE	FALSE	TRUE
262	HA_LOG_SEND_BLOCK_NUM	3	256	256	TRUE	FALSE	FALSE	FALSE	TRUE
263	HA_MONITOR_SERVER_IP_MS	3	20000	20000	TRUE	FALSE	FALSE	FALSE	TRUE
264	HA_SERVER_IP_ADDRESS	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
265	HA_SINGLE_ALIVE_KEEP_ELECTION_MS	3	180000	180000	TRUE	FALSE	FALSE	FALSE	TRUE
266	HA_SLAVE_FALL_BEHIND_LOG_SIZE	3	1024	1024	TRUE	FALSE	FALSE	FALSE	TRUE
267	HA_SLAVE_QUERY_WAIT_TIMEOUT	3	0	0	TRUE	FALSE	TRUE	FALSE	TRUE
268	HA_SLAVE_WRITE_BUFFER_BLOCK_NUM	3	131072	131072	TRUE	FALSE	FALSE	FALSE	TRUE
269	HA_SUB_MASK	2	255.255.255.0	255.255.255.0	TRUE	FALSE	FALSE	FALSE	TRUE
270	HA_SUB_PREFIX_LENGTH	3	64	64	TRUE	FALSE	FALSE	FALSE	TRUE
271	HA_SYNC_PORT	3	52099	52099	TRUE	FALSE	FALSE	FALSE	TRUE
272	HASH_MEM	3	4096	4096	TRUE	FALSE	TRUE	FALSE	TRUE
273	HASHAGG_USE_SPECIFIC_HASHFN	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
274	HAVING_AGG_SELEC	4	0.5	0.5	TRUE	FALSE	TRUE	FALSE	TRUE
275	HEAP_MAX_SIZE	3	256	256	TRUE	FALSE	FALSE	FALSE	TRUE
276	HEAP_MIN_SIZE	3	32	32	TRUE	FALSE	FALSE	FALSE	TRUE
277	HIERAR_QUERY_MAXLEVEL	3	1024	1024	TRUE	FALSE	TRUE	FALSE	TRUE
278	HIERAR_QUERY_MEM	3	1024000	1024000	TRUE	FALSE	TRUE	FALSE	TRUE
279	HIERAR_QUERY_PATH_MAXLEN	3	4096	4096	TRUE	FALSE	TRUE	FALSE	TRUE
280	HIERAR_RELEASE_MEMSIZE_ONCE	3	65536	65536	TRUE	FALSE	TRUE	FALSE	TRUE
281	HOTSTANDBY_DATABASE_TYPE	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
282	INDEX_DEF_LEVEL	3	0	0	TRUE	TRUE	TRUE	FALSE	TRUE
283	INDEX_PAGE_ADJUST	4	1	1	TRUE	FALSE	TRUE	FALSE	TRUE
284	INDEX_WRITER_THREAD_NUM	3	1	1	TRUE	TRUE	TRUE	FALSE	TRUE
285	JDBC_VERIFY_CERT_FILE	2	jdbc.crt	jdbc.crt	TRUE	FALSE	FALSE	FALSE	TRUE
286	JDBC_VERITY_STYLE	3	1	1	TRUE	FALSE	FALSE	FALSE	TRUE
287	JOB_PORT	3	4446	4446	TRUE	FALSE	FALSE	FALSE	TRUE
288	JOIN_COLLAPSE_LIMIT	3	8	8	TRUE	TRUE	TRUE	FALSE	TRUE
289	KS_CACHE_TUPLE_COUNT	3	10000	10000	TRUE	TRUE	TRUE	FALSE	TRUE
290	LC_TIME	2	C	C	TRUE	TRUE	TRUE	FALSE	TRUE
291	LOADBUFFERLEVEL	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
292	LOB_DISPLAY_MAX_SIZE	3	100000	100000	TRUE	FALSE	FALSE	FALSE	TRUE
293	LOB_TRANSFER_SIZE	3	600000	600000	TRUE	TRUE	TRUE	FALSE	TRUE
294	LOCAL_TRUST	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
295	LOCK_ROW_MAX_TUPLES	4	1024	1024	TRUE	FALSE	FALSE	FALSE	TRUE
296	LOCK_TABLE_MIN_TUPLES	4	4096	4096	TRUE	FALSE	FALSE	FALSE	TRUE
297	LOG_ARCH_GIVE_PRECEDENCE_MAX_SECONDS	3	5	5	TRUE	FALSE	TRUE	FALSE	TRUE
298	LOG_ARCHIVE_FORMAT	2	log%s_%v.arc	log%s_%v.arc	TRUE	FALSE	FALSE	FALSE	TRUE
299	LOG_ARCHIVE_INTERVAL	3	60000	60000	TRUE	FALSE	FALSE	FALSE	TRUE
300	LOG_COMPRESS_ENABLED	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
301	LOG_COPY_LOCK_NUM	3	32	32	TRUE	FALSE	FALSE	FALSE	TRUE
302	LOG_FIND_SEGMENT_ON_CUR_FILE	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
303	LOG_FLUSH_DELAY	3	0	0	TRUE	FALSE	TRUE	FALSE	TRUE
304	LOG_FLUSH_INTERVAL	3	3000	3000	TRUE	FALSE	FALSE	FALSE	TRUE
305	LOG_FLUSH_SIBLINGS	3	10	10	TRUE	FALSE	TRUE	FALSE	TRUE
306	LOG_GROUP_FLUSH_WAIT_PAGE_NUM	3	64	64	TRUE	FALSE	TRUE	FALSE	TRUE
307	LOG_IO_PAGE_NUM	3	1024	1024	TRUE	FALSE	FALSE	FALSE	TRUE
308	LOG_OVER_STOCK_PAGE_NUM	3	64	64	TRUE	FALSE	TRUE	FALSE	TRUE
309	LOG_PARALLEL_READ_TREAD_NUMBER	3	4	4	TRUE	FALSE	FALSE	FALSE	TRUE
310	LOG_READ_BUFFER_PAGES	3	65536	65536	TRUE	FALSE	FALSE	FALSE	TRUE
311	LOG_SINGLE_READ_BLOCKS	3	20480	20480	TRUE	FALSE	FALSE	FALSE	TRUE
312	LOG_WRITE_BUFFER_PAGES	3	131072	131072	TRUE	FALSE	FALSE	FALSE	TRUE
313	MASTER_POLLING_INTERVAL	3	100	100	TRUE	FALSE	FALSE	FALSE	TRUE
314	MAX_BINLOG_FILESIZE	3	1073741824	1073741824	TRUE	FALSE	FALSE	FALSE	TRUE
315	MAX_BINLOG_FILESNUM	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
316	MAX_BUFFERED_DOCS	3	100	100	TRUE	TRUE	TRUE	FALSE	TRUE
317	MAX_CAT_CACHE_TUPLES	3	50000	50000	TRUE	FALSE	FALSE	FALSE	TRUE
318	MAX_CONNECTIONS	3	200	200	TRUE	FALSE	FALSE	FALSE	TRUE
319	MAX_CONNECTIONS_PER_USER	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
320	MAX_CURSORS_PER_SESSION	3	8192	8192	TRUE	FALSE	FALSE	FALSE	TRUE
321	MAX_CURSORS_TOTAL	3	65536	65536	TRUE	FALSE	FALSE	FALSE	TRUE
322	MAX_FIELD_LENGTH	3	0	0	TRUE	TRUE	TRUE	FALSE	TRUE
323	MAX_HJ_INNERS	3	1000000	1000000	TRUE	FALSE	TRUE	FALSE	TRUE
324	MAX_LOGIN_COUNT	3	3	3	TRUE	FALSE	FALSE	FALSE	TRUE
325	MAX_MLOG_SIZE	3	10	10	TRUE	TRUE	TRUE	FALSE	TRUE
326	MAX_NET_DATA_LEN	3	104857600	104857600	TRUE	FALSE	FALSE	FALSE	TRUE
327	MAX_REL_CACHE_RELATIONS	3	5000	5000	TRUE	FALSE	FALSE	FALSE	TRUE
328	MAX_STACK_DEPTH	3	819200	819200	TRUE	FALSE	TRUE	FALSE	TRUE
329	MAX_STATPROFILE_HASHNUM	3	1000	1000	TRUE	FALSE	FALSE	FALSE	TRUE
330	MEMQUOTA_TIMEOUT	3	5	5	TRUE	FALSE	FALSE	FALSE	TRUE
331	MERGE_FACTOR	3	10	10	TRUE	TRUE	TRUE	FALSE	TRUE
332	MIN_IN_ELEMENT	3	100	100	TRUE	TRUE	TRUE	FALSE	TRUE
333	MIN_PARALLEL_DEGREE	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
334	MIN_PASSWORD_LEN	3	0	0	TRUE	FALSE	TRUE	FALSE	TRUE
335	MIN_SQL_TRACE_TIME	3	0	0	TRUE	FALSE	TRUE	FALSE	TRUE
336	MUST_INDEXSCAN_SELEC	4	0	0	TRUE	FALSE	TRUE	FALSE	TRUE
337	MUST_NO_INDEXSCAN_SELEC	4	1	1	TRUE	FALSE	TRUE	FALSE	TRUE
338	MUTEX_EXCLUSIVE_HIGH_SPINCNT	3	200	200	TRUE	FALSE	TRUE	FALSE	TRUE
339	MUTEX_EXCLUSIVE_SPINCNT	3	100	100	TRUE	FALSE	TRUE	FALSE	TRUE
340	MUTEX_SHARED_SPINCNT	3	50	50	TRUE	FALSE	TRUE	FALSE	TRUE
341	MUTEX_SLEEP_TIMEOUT	3	10	10	TRUE	FALSE	TRUE	FALSE	TRUE
342	MVCC_RECHECK_TIMES	3	10	10	TRUE	FALSE	TRUE	FALSE	TRUE
343	MVCC_RETRY_TIMES	3	1	1	TRUE	FALSE	TRUE	FALSE	TRUE
344	MVCC_RETRY_TIMES_FOR_MARK	3	1000	1000	TRUE	FALSE	TRUE	FALSE	TRUE
345	NAME_CASE_SENSITIVE	1	TRUE	TRUE	TRUE	FALSE	TRUE	FALSE	TRUE
346	NESTLOOP_MEM	3	4096	4096	TRUE	FALSE	TRUE	FALSE	TRUE
347	NET_COMPRESS_SIZE	3	0	0	TRUE	TRUE	TRUE	FALSE	TRUE
348	NET_DATA_BY_STR	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
349	NLS_SORT	2	BINARY	BINARY	TRUE	TRUE	TRUE	FALSE	TRUE
350	OFFLINEOPT_SAMPLE_PERCENT	3	0	0	TRUE	FALSE	TRUE	FALSE	TRUE
351	OFFLINEOPT_SEARCH_MODE	3	1	1	TRUE	TRUE	TRUE	FALSE	TRUE
352	ONLY_FULL_GROUP_BY	1	TRUE	TRUE	TRUE	FALSE	TRUE	FALSE	TRUE
353	OS_AUTHENT_PREFIX	2	ops$	ops$	TRUE	FALSE	FALSE	FALSE	TRUE
354	OZSORT_MANYKEYN	3	5	5	TRUE	TRUE	TRUE	FALSE	TRUE
355	PARALLEL_CORE	3	1	1	TRUE	FALSE	FALSE	FALSE	TRUE
356	PARALLEL_DEGREE	3	1	1	TRUE	FALSE	FALSE	FALSE	TRUE
357	PARALLEL_THREAD_MAX_PERCENT	4	1	1	TRUE	FALSE	FALSE	FALSE	TRUE
358	PART_TABLESPACE_COUNT	3	256	256	TRUE	TRUE	TRUE	FALSE	TRUE
359	PART_TBLOPEN_MAX	3	8192	8192	TRUE	FALSE	FALSE	FALSE	TRUE
360	PASSWD_VALID_DAYS	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
361	PORT	3	2003	2003	TRUE	FALSE	FALSE	FALSE	TRUE
362	PRE_LISTEN_SCRIPT	2	prelisten.sql	prelisten.sql	TRUE	FALSE	FALSE	FALSE	TRUE
363	PREPARE_CUSTOM_COUNT	3	5	5	TRUE	FALSE	FALSE	FALSE	TRUE
364	PREPARED_CACHE_SIZE	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
365	PRINT_TIME_INTERVAL	3	60	60	TRUE	FALSE	TRUE	FALSE	TRUE
366	PTINDEXSCAN_COST_ADJUST	4	1	1	TRUE	FALSE	TRUE	FALSE	TRUE
367	PURGE_MLOG_INTERVAL	3	600	600	TRUE	FALSE	FALSE	FALSE	TRUE
368	QUERY_REWRITE_MVIEW_INTEGRITY	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
369	QUERY_TUNING_COST	4	1	1	TRUE	FALSE	TRUE	FALSE	TRUE
370	RADIUS_SECRET	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
371	RADIUS_SERVER_ADDRESS	2	127.0.0.1	127.0.0.1	TRUE	FALSE	FALSE	FALSE	TRUE
372	RADIUS_SERVER_PORT	3	1812	1812	TRUE	FALSE	FALSE	FALSE	TRUE
373	RANDOM_PAGE_COST	4	1	1	TRUE	FALSE	TRUE	FALSE	TRUE
374	RATIO_LOGSIZE_CONSTRAINT	4	0.9	0.9	TRUE	FALSE	TRUE	FALSE	TRUE
375	READ_WRITE_MODE	2	READ WRITE	READ WRITE	TRUE	FALSE	TRUE	FALSE	TRUE
376	REMOTE_OS_AUTHENT	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
377	RESOURCE_SPINCNT	3	4000	4000	TRUE	FALSE	TRUE	FALSE	TRUE
378	RESULT_CACHE_LEVEL	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
379	RESULT_CACHE_MAX_RESULT	3	50	50	TRUE	FALSE	TRUE	FALSE	TRUE
380	RESULT_CACHE_MAX_SIZE	3	32	32	TRUE	FALSE	TRUE	FALSE	TRUE
381	RESULT_CACHE_ROWS_LIMIT	3	10000	10000	TRUE	TRUE	TRUE	FALSE	TRUE
382	REUSE_BUF_SIZE	3	1024000	1024000	TRUE	TRUE	TRUE	FALSE	TRUE
383	RIGHT_JOIN_THRESHOLD	3	5	5	TRUE	TRUE	TRUE	FALSE	TRUE
384	ROWSEVENT_MAX_DATASIZE	4	8192	8192	TRUE	FALSE	FALSE	FALSE	TRUE
385	SAVE_CPU_INTERVAL	3	0	0	TRUE	TRUE	TRUE	FALSE	TRUE
386	SC_HASHTABLE_ELEMENT_COUNT	3	48	48	TRUE	FALSE	FALSE	FALSE	TRUE
387	SEARCH_PATH	2	$USER,PUBLIC	$USER,PUBLIC	TRUE	FALSE	TRUE	FALSE	TRUE
388	SECURE_COMMUNICATION_HDENCRYPT	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
389	SECURE_COMMUNICATION_LEVEL	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
390	SECURITY_STANDARD	3	0	0	TRUE	FALSE	TRUE	FALSE	TRUE
392	SEG_STAT_SAMPLES	3	256	256	TRUE	FALSE	TRUE	FALSE	TRUE
393	SEND_FLOATINGNUMBER_KEEP_PRECISION	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
394	SEQUENCE_DEF_LEVEL	3	0	0	TRUE	TRUE	TRUE	FALSE	TRUE
395	SERIAL_CACHE_SIZE	3	0	0	TRUE	FALSE	TRUE	FALSE	TRUE
396	SERVER_CERTIFICATE_FILE	2	server.crt	server.crt	TRUE	FALSE	FALSE	FALSE	TRUE
397	SERVER_ID	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
398	SERVER_KEY_FILE	2	server.key	server.key	TRUE	FALSE	FALSE	FALSE	TRUE
399	SERVER_KEY_FILE_PASSWORD	2	password	password	TRUE	FALSE	FALSE	FALSE	TRUE
400	SERVER_MIN_MESSAGES	2	notice	notice	TRUE	TRUE	TRUE	FALSE	TRUE
402	SESSION_READONLY	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
403	SESSION_TIMELIMIT	3	0	0	TRUE	FALSE	TRUE	FALSE	TRUE
404	SESSION_TIMEOUT	3	0	0	TRUE	FALSE	TRUE	FALSE	TRUE
405	SLAVE_MAX_EVENT_SIZE	4	1.07374e+09	1.07374e+09	TRUE	FALSE	FALSE	FALSE	TRUE
406	SORT_MEM	3	4096	4096	TRUE	FALSE	TRUE	FALSE	TRUE
407	SORT_MERGE_FANIN	3	15	15	TRUE	TRUE	TRUE	FALSE	TRUE
408	SORT_OZSORT_KEY_MAXLEN	3	36	36	TRUE	TRUE	TRUE	FALSE	TRUE
409	SPC_HASHTABLE_SIZE	3	512	512	TRUE	FALSE	FALSE	FALSE	TRUE
410	SPC_MAX_SQL_LENGTH	3	1024	1024	TRUE	TRUE	TRUE	FALSE	TRUE
411	SPC_MEMCONTEXT_COUNT	3	16	16	TRUE	FALSE	FALSE	FALSE	TRUE
412	SPI_MAX_NESTLEVEL	3	20	20	TRUE	TRUE	TRUE	FALSE	TRUE
413	SQL_TRACE_MAX_MEM	3	100	100	TRUE	FALSE	FALSE	FALSE	TRUE
414	STACK_MIN_ERRLEVEL	2	panic	panic	TRUE	TRUE	TRUE	FALSE	TRUE
415	STAT_MAX_BUCKET	3	100	100	TRUE	FALSE	FALSE	FALSE	TRUE
416	STAT_PROFILE_BIAS_RATE	4	0.3	0.3	TRUE	FALSE	TRUE	FALSE	TRUE
417	STAT_PROFILE_ROWS	3	1000	1000	TRUE	TRUE	TRUE	FALSE	TRUE
418	STMT_ROLLBACK	3	0	0	TRUE	TRUE	TRUE	FALSE	TRUE
419	SUPERUSER_RESERVED_CONNECTIONS	3	2	2	TRUE	FALSE	FALSE	FALSE	TRUE
420	SYNC_BINLOG_PERIOD	3	1	1	TRUE	FALSE	FALSE	FALSE	TRUE
421	SYSTEM_USER_LOCK_TERM	3	5	5	TRUE	FALSE	FALSE	FALSE	TRUE
422	SYSUSER_ONLY_LOCAL_LOGIN	1	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE
423	TABLE_DEF_LEVEL	3	0	0	TRUE	TRUE	TRUE	FALSE	TRUE
424	TCP_KEEPALIVE_COUNT	3	8	8	TRUE	FALSE	FALSE	FALSE	TRUE
425	TCP_KEEPALIVE_IDLE	3	7200	7200	TRUE	FALSE	FALSE	FALSE	TRUE
426	TCP_KEEPALIVE_INTERVAL	3	75	75	TRUE	FALSE	FALSE	FALSE	TRUE
427	TEMPFILE_PATH	2	__default_tempdir_mark__	__default_tempdir_mark__	TRUE	FALSE	FALSE	FALSE	TRUE
428	TEMPFILE_RECREATE_OPTION	3	2	2	TRUE	FALSE	FALSE	FALSE	TRUE
429	TEMPFILE_SIZE	3	100	100	TRUE	FALSE	FALSE	FALSE	TRUE
430	TEXT_POSITION_KMP	1	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
431	THREAD_STACK_SIZE	3	1	1	TRUE	FALSE	FALSE	FALSE	TRUE
432	THREADPOOL_HIGH_PRIO_MODE	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
433	THREADPOOL_HIGH_PRIO_TICKETS	3	2147483647	2147483647	TRUE	FALSE	FALSE	FALSE	TRUE
434	THREADPOOL_IDLE_TIMEOUT	3	60	60	TRUE	FALSE	FALSE	FALSE	TRUE
435	THREADPOOL_MAX_THREADS	3	100000	100000	TRUE	FALSE	TRUE	FALSE	TRUE
436	THREADPOOL_MIN_THREADS	3	1	1	TRUE	FALSE	TRUE	FALSE	TRUE
437	THREADPOOL_OVERSUBSCRIBE	3	3	3	TRUE	FALSE	FALSE	FALSE	TRUE
438	THREADPOOL_SIZE	3	0	0	TRUE	FALSE	FALSE	FALSE	TRUE
439	THREADPOOL_STALL_LIMIT	3	500	500	TRUE	FALSE	TRUE	FALSE	TRUE
440	TIMESTAMPFORMAT	2	unset	unset	TRUE	TRUE	TRUE	FALSE	TRUE
441	TIMESTAMPTZFORMAT	2	unset	unset	TRUE	TRUE	TRUE	FALSE	TRUE
442	TIMEZONE	2	UNKNOWN	UNKNOWN	TRUE	TRUE	TRUE	FALSE	TRUE
443	TIMEZONE_ABBREVIATIONS	2	normal	normal	TRUE	TRUE	TRUE	FALSE	TRUE
444	TM_CHECKPOINT_INTERVAL	3	1000000	1000000	TRUE	FALSE	FALSE	FALSE	TRUE
445	TM_MAX_SAVEPOINTS	3	1000	1000	TRUE	FALSE	FALSE	FALSE	TRUE
446	TM_PARA_REDO_TASKQUEUE_LEN	3	2097152	2097152	TRUE	FALSE	FALSE	FALSE	TRUE
447	TM_PARA_REDO_TASKQUEUE_NUM	3	4	4	TRUE	FALSE	FALSE	FALSE	TRUE
448	TM_PARA_REDO_WORKER_NUM	3	4	4	TRUE	FALSE	FALSE	FALSE	TRUE
449	TM_REDO_MODE	3	2	2	TRUE	FALSE	FALSE	FALSE	TRUE
450	TM_TIMEPOINT_INTERVAL	3	1000	1000	TRUE	FALSE	FALSE	FALSE	TRUE
451	TOP_COST_SQL_LIST_LEN	3	0	0	TRUE	FALSE	TRUE	FALSE	TRUE
452	TRACE_FILE_MAX_SIZE	3	100	100	TRUE	FALSE	TRUE	FALSE	TRUE
453	TRACE_ROWVERSION	1	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
454	TRACEFILE_DEST_PATH	2	/opt/ShenTong/trace	/opt/ShenTong/trace	TRUE	FALSE	FALSE	FALSE	TRUE
455	TRANSACTION ISOLATION LEVEL	2	READ COMMITTED	READ COMMITTED	FALSE	FALSE	TRUE	FALSE	TRUE
456	TRANSFORM_NULL_EQUALS	1	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE
457	UNDO_RETENTION	3	100	100	TRUE	FALSE	TRUE	FALSE	TRUE
458	UNIX_SOCKET_PATH	2	/tmp	/tmp	TRUE	FALSE	FALSE	FALSE	TRUE
459	USEG_ACTIVE_TXN_COUNT_THRESHOLD	3	1	1	TRUE	FALSE	FALSE	FALSE	TRUE
460	VIRTUAL_HOST	2	unset	unset	TRUE	FALSE	FALSE	FALSE	TRUE
461	XMLBINARY	3	1	1	TRUE	TRUE	TRUE	FALSE	TRUE
462	XMLOPTION	3	1	1	TRUE	TRUE	TRUE	FALSE	TRUE

[回到目录]

● 所有用户
USERNAME USER_ID ACCOUNT_STATUS DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED EDITIONS_ENABLED AUTHENTICATION_TYPE

SYSDBA 1 OPEN SYSTEM TEMP 2022-04-21 N PASSWORD

SYSFTSDBA 33001 OPEN SYSTEM TEMP 2022-04-21 N PASSWORD

SYSAUDIT 4 OPEN AUDIT TEMP 2022-04-21 N PASSWORD

SYSSECURE 2 OPEN SYSTEM TEMP 2022-04-21 N PASSWORD

LHR 33985 OPEN SYSTEM TEMP 2022-04-21 N PASSWORD

USERNAME	USER_ID	ACCOUNT_STATUS	DEFAULT_TABLESPACE	TEMPORARY_TABLESPACE	CREATED	EDITIONS_ENABLED	AUTHENTICATION_TYPE
SYSDBA	1	OPEN	SYSTEM	TEMP	2022-04-21	N	PASSWORD
SYSFTSDBA	33001	OPEN	SYSTEM	TEMP	2022-04-21	N	PASSWORD
SYSAUDIT	4	OPEN	AUDIT	TEMP	2022-04-21	N	PASSWORD
SYSSECURE	2	OPEN	SYSTEM	TEMP	2022-04-21	N	PASSWORD
LHR	33985	OPEN	SYSTEM	TEMP	2022-04-21	N	PASSWORD

[回到目录]

数据库对象统计

● 数据库对象信息
OBJECTTYPE RELKIND CNT

序列 S 2

视图 v 2

普通表 r 8

索引 i 7

存储过程 p 2

OBJECTTYPE	RELKIND	CNT
序列	S	2
视图	v	2
普通表	r	8
索引	i	7
存储过程	p	2

[回到目录]

● 神通表大小top10
OID RELNAME SIZE_MB

34053 dbaup 149 MB

34064 T3 49 MB

34062 T1 33 MB

34063 T2 33 MB

OID	RELNAME	SIZE_MB
34053	dbaup	149 MB
34064	T3	49 MB
34062	T1	33 MB
34063	T2	33 MB

● 神通索引大小top10
OID RELNAME SIZE_MB

34067 IDX_TEST 44 MB

OID	RELNAME	SIZE_MB
34067	IDX_TEST	44 MB

[回到目录]

会话情况

● 数据库会话
SESSION ID LOGON USERFROM CURRENT USER LOGONTIME USER_IP USER_PORT DBNAME APPNAME SQL COUNT TOTAL PORTAL X COMMIT X ROLLBACK TOTAL BYTES SEND TOTAL BYTES RECV TOTAL PACKET SEND TOTAL LOCK CURRENT LOCK CURRENT PHY LOCK TOTAL PACKET RECV TOTAL MEMORYCONTEXT TOTAL CHUNKSIZE ELOGHEAP SIZE PRIVATEHEAP SIZE TOTAL MVCC RETRY

0 SYSDBA SYSDBA 2022-04-22 09:39:13 192.168.66.64 6072 OSRDB Analyze Query SQL 33 0 34 1 2665 4674 38 0 0 0 35 0 0 0 0 0

1 SYSDBA SYSDBA 2022-04-22 09:39:17 192.168.66.64 6077 OSRDB Analyze Query SQL 58 0 57 3 129686 16492 77 0 0 0 60 0 0 0 0 0

2 SYSDBA SYSDBA 2022-04-22 09:40:01 192.168.66.64 6117 OSRDB Analyze Query SQL 309 0 282 29 634898 42396 398 0 0 0 311 0 0 0 0 0

3 SYSDBA SYSDBA 2022-04-22 10:33:53 192.168.66.64 9667 OSRDB Analyze Query SQL 63 3 49 16 151385 47207 86 0 0 0 75 0 0 0 0 0

4 SYSDBA SYSDBA 2022-04-22 10:35:28 192.168.66.64 9755 OSRDB Analyze Query SQL 79 0 69 12 14956 10519 95 0 0 0 81 0 0 0 0 0

5 SYSDBA SYSDBA 2022-04-22 11:13:44 192.168.66.64 12146 OSRDB isql.exe 34 0 28 6 41878 15062 41 0 0 0 34 0 0 0 0 0

6 SYSDBA SYSDBA 2022-04-22 12:54:10 192.168.66.64 18190 OSRDB Analyze Query SQL 18 0 19 1 1189 4299 23 0 0 0 20 0 0 0 0 0

7 SYSDBA SYSDBA 2022-04-22 14:58:57 192.168.66.64 25250 OSRDB DBStudio 3.8.5 - Main 53 0 47 1 10588 9372 51 0 0 0 48 0 0 0 0 0

8 SYSDBA SYSDBA 2022-04-22 14:59:21 192.168.66.64 25269 OSRDB DBStudio 3.8.5 - SQL编辑器 < 脚本.sql > 15 2 14 3 17771 8991 23 0 0 0 18 0 0 0 0 0

9 SYSDBA SYSDBA 2022-04-22 16:22:14 192.168.66.64 29982 OSRDB isql.exe 69 0 67 1 97952 28706 76 0 0 9999999 75 0 0 0 0 0

● 数据库会话诊断信息
SESSION_ID EVENT_NAME SESSION ID APPNAME LOGONTIME TOTAL PORTAL SQL COUNT

0 NetWait 0 Analyze Query SQL 2022-04-22 09:39:13 0 33

1 NetWait 1 Analyze Query SQL 2022-04-22 09:39:17 0 58

2 NetWait 2 Analyze Query SQL 2022-04-22 09:40:01 0 309

3 NetWait 3 Analyze Query SQL 2022-04-22 10:33:53 3 63

4 NetWait 4 Analyze Query SQL 2022-04-22 10:35:28 0 79

5 NetWait 5 isql.exe 2022-04-22 11:13:44 0 34

6 NetWait 6 Analyze Query SQL 2022-04-22 12:54:10 0 18

7 NetWait 7 DBStudio 3.8.5 - Main 2022-04-22 14:58:57 0 53

8 NetWait 8 DBStudio 3.8.5 - SQL编辑器 < 脚本.sql > 2022-04-22 14:59:21 2 15

9 NetWait 9 isql.exe 2022-04-22 16:22:14 0 72

SESSION_ID	EVENT_NAME	SESSION ID	APPNAME	LOGONTIME	TOTAL PORTAL	SQL COUNT
0	NetWait	0	Analyze Query SQL	2022-04-22 09:39:13	0	33
1	NetWait	1	Analyze Query SQL	2022-04-22 09:39:17	0	58
2	NetWait	2	Analyze Query SQL	2022-04-22 09:40:01	0	309
3	NetWait	3	Analyze Query SQL	2022-04-22 10:33:53	3	63
4	NetWait	4	Analyze Query SQL	2022-04-22 10:35:28	0	79
5	NetWait	5	isql.exe	2022-04-22 11:13:44	0	34
6	NetWait	6	Analyze Query SQL	2022-04-22 12:54:10	0	18
7	NetWait	7	DBStudio 3.8.5 - Main	2022-04-22 14:58:57	0	53
8	NetWait	8	DBStudio 3.8.5 - SQL编辑器 < 脚本.sql >	2022-04-22 14:59:21	2	15
9	NetWait	9	isql.exe	2022-04-22 16:22:14	0	72

● 数据库阻塞信息
PREV_SQL KILL_SESSION PID BLOCKER_PID

[回到目录]

● 归档信息
DBNAME ARCHIVEMODE ARCHIVEPATH

OSRDB ARCHIVELOG /opt/ShenTong/arch/OSRDB

DBNAME	ARCHIVEMODE	ARCHIVEPATH
OSRDB	ARCHIVELOG	/opt/ShenTong/arch/OSRDB

[回到目录]

其它信息

● dblink
OWNER DB_LINK USERNAME HOST CREATED

[回到目录]