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

[转到页底]

● 达梦版本信息

BANNER
DM Database Server 64 V8
DB Version: 0x7000b

● 达梦授权信息

LIC_VERSION	SERIES_NO	SERVER_SERIES	服务器发布类型	SERVER_VER	过期时间	用户名称	AUTHORIZED_USER_NUMBER	CONCURRENCY_USER_NUMBER	MAX_CPU_NUM	NOACTIVE_DEADLINE	HARDWARE_ID	CHECK_CODE	产品类型	PROJECT_NAME	CPU_TYPE	OS_TYPE	MAX_CORE_NUM	HARDWARE_TYPE	CLUSTER_TYPE	DATE_GEN	SERVER_SERIES_NAME	TABLE_RECORD_NUMBER_LIMIT	TOTAL_SPACE_LIMIT
3.00	dm66n367	D	试用版	X.X.x.x	2021-11-06	DEVELOP USER	1						DM8		Others	Others			1111	1900-01-01

● 其他信息

数据库选项	数据库相关参数值
实例名称	DMSERVER
现在时间	2021-10-15 16:28:14
数据库版本	DM Database Server x64 V8
数据库版本2	1-1-144-20.11.06-129436-ENT Pack1
过期时间	2021-11-06
字符集	UTF-8
页大小	16
簇大小	16
大小写敏感	0
数据库模式	NORMAL
唯一魔数	1358572416
LSN	4743797
数据库闪回	是
归档模式	Y

● 数据库服务器信息

CPU个数	物理内存(G)	空闲物理内存(G)	虚拟内存（G）	空闲虚拟内存空间（G）	总磁盘空间（G）	空闲磁盘空间（G）	驱动器名称	驱动器总空间大小（G）	驱动器剩余空间大小（G）	每分钟平均负载	每5分钟平均负载	每15分钟平均负载	用户CPU使用率	系统CPU使用率	CPU空闲率	发送的总字节数	接收的总字节数	当前每秒发送字节数	当前每秒接收字节数	当前每秒发送数据包数	当前每秒接收数据包数
8	44	1	10	10	3392	743	NULL			0.02	0.03	0.05	0.54	0.64	98.77	26075679	339949472	52	50	0	0

● 数据库基本信息

数据库名称	创建时间	归档模式	LAST_CKPT_TIME	状态	ROLE$	MAX_SIZE	TOTAL_SIZE	DSC_NODES	OPEN_COUNT	STARTUP_COUNT	LAST_STARTUP_TIME
PROD	2021-09-08 03:51:53	Y	2021-10-15 16:24:19	打开	0	0	228608	1	6	7	2021-10-15 10:24:17

● 数据库实例信息

NAME	INSTANCE_NAME	INSTANCE_NUMBER	HOST_NAME	SVR_VERSION	DB_VERSION	START_TIME	STATUS$	MODE$	OGUID	DSC_SEQNO	DSC_ROLE
DMSERVER	DMSERVER	1	75d915054e63	DM Database Server x64 V8	DB Version: 0x7000b	2021-10-15 10:24:17	OPEN	NORMAL	0	0	NULL

表空间情况

● 表空间情况

TS#	TS_Name	CONTENTS	ts_size_M	Free_Size_M	Used_Size_M	Used_per	MAX_Size_G	USED_per_MAX	BLOCK_SIZE	LOGGING	ts_df_count
0	SYSTEM	PERMANENT	44	35	9	21.413	32768	0	2816		1
4	MAIN	PERMANENT	2176	2068	108	4.965	65536	0	139264		2
5	SYSAUX	PERMANENT	1326	37	1289	97.238	10	12.592	84864		1
3	TEMP	TEMPORARY	26	26	0	0.541	32768	0	1664		1
1	ROLL	UNDO	128	110	18	14.246	32768	0	8192		1
	ALL TS:		3700	2275	1425	38.519	163850

● HMAIN表空间情况

ID	NAME	PATHNAME	DIR_NUM	COPY_NUM	SIZE_MODE
128	HMAIN	/dm8/data/PROD/HMAIN	1
129	HTS_NAME	/dm8/data/PROD/HTSSPACE	1

● 数据文件情况

TABLESPACE_NAME	CONTENTS	ts_size_m	FILE_NAME	file_size_m	file_max_size_G	AUTOEXTENSIBLE	INCREMENT_m	autoextend_ratio	CREATION_TIME	INCREMENT_BY_block	BYTES	blocks	MAXBYTES	MAXBLOCKS	USER_BYTES	USER_BLOCKS
SYSTEM	PERMANENT	44	/dm8/data/PROD/SYSTEM.DBF	44	32768	YES	0	0	2021-09-08 03:51:53	0	46137344	2816	35184371040256	33554431	36257792	2213
SYSAUX	PERMANENT	1326	/dm8/data/PROD/SYSAWR.DBF	1326	10	YES	0	12.95	2021-10-11 09:27:06	0	1390411776	84864	10737418240	10240	38404096	2344
MAIN	PERMANENT	2176	/dm8/data/PROD/MAIN01.DBF	2048	32768	YES	0	0.01	2021-10-12 10:07:06	0	2147483648	131072	35184371040256	33554431	2116796416	129199
MAIN	PERMANENT	2176	/dm8/data/PROD/MAIN.DBF	128	32768	YES	0	0	2021-09-08 03:51:53	0	134217728	8192	35184371040256	33554431	51625984	3151
TEMP	TEMPORARY	26	/dm8/data/PROD/TEMP.DBF	26	32768	YES	0	0	2021-10-15 10:24:17	0	27262976	1664	35184371040256	33554431	27115520	1655
ROLL	UNDO	128	/dm8/data/PROD/ROLL.DBF	128	32768	YES	0	0	2021-09-08 03:51:53	0	134217728	8192	35184371040256	33554431	115097600	7025

● 所有用户

USERNAME	USER_ID	PASSWORD	ACCOUNT_STATUS	LOCK_DATE	EXPIRY_DATE	DEFAULT_TABLESPACE	TEMPORARY_TABLESPACE	CREATED	PROFILE	INITIAL_RSRC_CONSUMER_GROUP	EXTERNAL_NAME	PASSWORD_VERSIONS	EDITIONS_ENABLED	AUTHENTICATION_TYPE	NOWDATE	user_size_m
SYSDBA	50331649		OPEN			MAIN	TEMP	2021-09-08 11:53:05.07799	/dm8/data/PROD/MAIN.DBF			0	Y	NDCT_DB_AUTHENT	2021-10-15 16:28:16	122
SYS	50331648		OPEN			SYSTEM	TEMP	2021-09-08 11:53:05.07799	/dm8/data/PROD/SYSTEM.DBF			0	Y	NDCT_DB_AUTHENT	2021-10-15 16:28:16	1321
SYSREP	50331753		OPEN			MAIN	TEMP	2021-10-15 12:30:55.576529	/dm8/data/PROD/MAIN.DBF			2	Y	NDCT_DB_AUTHENT	2021-10-15 16:28:16	3
LHR1	50331752		OPEN			MAIN	TEMP	2021-10-11 16:06:44.3529	/dm8/data/PROD/MAIN.DBF			2	Y	NDCT_DB_AUTHENT	2021-10-15 16:28:16	0
LHR	50331751		OPEN			MAIN	TEMP	2021-10-11 16:06:33.448016	/dm8/data/PROD/MAIN.DBF			2	Y	NDCT_DB_AUTHENT	2021-10-15 16:28:16	0
SYSSSO	50331651		OPEN			SYSTEM	TEMP	2021-09-08 11:53:05.07799	/dm8/data/PROD/SYSTEM.DBF			0	Y	NDCT_DB_AUTHENT	2021-10-15 16:28:16	0
SYSAUDITOR	50331650		OPEN			SYSTEM	TEMP	2021-09-08 11:53:05.07799	/dm8/data/PROD/SYSTEM.DBF			0	Y	NDCT_DB_AUTHENT	2021-10-15 16:28:16	0

● 所有用户角色

GRANTEE	PRIVILEGE	PRIVILEGE_TYPE	ADMIN_OPTION
LHR	DBA	ROLE_PRIVS	NO
LHR	PUBLIC	ROLE_PRIVS	NO
LHR	SOI	ROLE_PRIVS	NO
LHR1	PUBLIC	ROLE_PRIVS	NO
LHR1	SOI	ROLE_PRIVS	NO
SYSREP	PUBLIC	ROLE_PRIVS	NO
SYSREP	RESOURCE	ROLE_PRIVS	NO
SYSREP	SOI	ROLE_PRIVS	NO

● 所有参数[下一项]

PARA_NAME	PARA_VALUE	MIN_VALUE	MAX_VALUE	MPP_CHK	SESS_VALUE	FILE_VALUE	DESCRIPTION	PARA_TYPE
CTL_PATH	/dm8/data/PROD/dm.ctl			N	/dm8/data/PROD/dm.ctl	/dm8/data/PROD/dm.ctl	path of dm.ctl	READ ONLY
CTL_BAK_PATH	/dm8/data/PROD/ctl_bak			N	/dm8/data/PROD/ctl_bak	/dm8/data/PROD/ctl_bak	backup path of dm.ctl	READ ONLY
CTL_BAK_NUM	10	1	100	N	10	10	backup num of dm.ctl	SYS
SYSTEM_PATH	/dm8/data/PROD			N	/dm8/data/PROD	/dm8/data/PROD	system path	READ ONLY
CONFIG_PATH	/dm8/data/PROD			N	/dm8/data/PROD	/dm8/data/PROD	config path	READ ONLY
TEMP_PATH	/dm8/data/PROD			N	/dm8/data/PROD	/dm8/data/PROD	temporary database file path	READ ONLY
BAK_PATH	/dm8/data/PROD/bak			N	/dm8/data/PROD/bak	/dm8/data/PROD/bak	backup file path	READ ONLY
AUD_PATH				N			audit log path	READ ONLY
DFS_PATH	$/PROD			N	$/PROD	$/PROD	path of db_file in dfs	READ ONLY
INSTANCE_NAME	DMSERVER			N	DMSERVER	DMSERVER	Instance name	READ ONLY
INSTANCE_ADDR				N			Instance address	READ ONLY
MAX_OS_MEMORY	100	40	100	N	100	100	Maximum Percent of OS Memory Can Be Used	IN FILE
MEMORY_POOL	200	64	67108864	N	200	200	Memory Pool Size In Megabyte	IN FILE
MEMORY_N_POOLS	1	0	2048	N	1	1	Number of Memory Share Pool	IN FILE
MEMORY_TARGET	0	0	67108864	N	0	0	Memory Share Pool Target Size In Megabyte	SYS
MEMORY_EXTENT_SIZE	1	1	10240	N	1	1	Memory Pool Extent Size In Megabyte	IN FILE
MEMORY_LEAK_CHECK	0	0	1	N	0	0	Memory Leak Checking Flag	SYS
MEMORY_MAGIC_CHECK	1	0	3	N	1	1	Memory Magic Checking Flag	IN FILE
MEMORY_BAK_POOL	4	2	2048	N	4	4	Memory Backup Pool Size In Megabyte	IN FILE
HUGE_MEMORY_PERCENTAGE	50	0	100	N	50	50	Maximum percent of HUGE buffer that can be allocated to work as common memory pool	IN FILE
HUGE_BUFFER	80	8	1048576	N	80	80	Initial Huge Buffer Size In Megabytes	IN FILE
HUGE_BUFFER_POOLS	4	1	512	N	4	4	Huge Buffer Pools	IN FILE
BUFFER	100	8	1048576	N	100	100	Initial System Buffer Size In Megabytes	IN FILE
BUFFER_POOLS	1	1	512	N	1	19	Buffer Pools	IN FILE
BUFFER_MODE	0	0	1	N	0	0	Buffer pool elimination mode, 0 = LRU, 1 = clock	IN FILE
FAST_POOL_PAGES	3000	0	99999	N	3000	3000	Fast Pool Pages	IN FILE
FAST_ROLL_PAGES	1000	0	99999	N	1000	1000	Fast Roll Pages	IN FILE
KEEP	8	8	1048576	N	8	8	Initial System KEEP Buffer Size In Megabytes	IN FILE
RECYCLE	64	8	1048576	N	64	64	Initial System KEEP Buffer Size In Megabytes	IN FILE
RECYCLE_POOLS	1	1	512	N	1	19	Number of recycle buffer pools	IN FILE
ROLLSEG	1	1	1048576	N	1	1	Initial System ROLLSEG Buffer Size In Megabytes	IN FILE
ROLLSEG_POOLS	1	1	512	N	1	19	Number of rollseg buffer pools	IN FILE
BUFFER_FAST_RELEASE	1	0	1	N	1	1	Whether discard freed page in recycle pool	SYS
MULTI_PAGE_GET_NUM	1	1	64	N	1	1	Maximum number of pages for each read of buffer	SYS
PRELOAD_SCAN_NUM	0	0	64	N	0	0	The number of pages scanned continuously to start preload task	SYS
PRELOAD_EXTENT_NUM	0	0	64	N	0	0	The number of clusters preloaded for the first time	SYS
MAX_BUFFER	100	8	1048576	N	100	100	maximum system buffer size in Megabytes	IN FILE
SORT_BUF_SIZE	2	1	2048	N	2	2	maximum sort buffer size in Megabytes	SESSION
SORT_BLK_SIZE	1	1	50	N	1	1	maximum sort blk size in Megabytes	SESSION
SORT_BUF_GLOBAL_SIZE	1000	10	4294967294	N	1000	1000	maximum global sort buffer size in Megabytes	SYS
SORT_FLAG	0	0	1	N	0	0	choose method of sort	SESSION
HAGR_HASH_SIZE	100000	10000	100000000	N	100000	100000	hash table size for hagr	SESSION
MAIL_BUF_SIZE	100	0	500000	N	100	100	mail buf size	SYS
MAIL_VPOOL_SIZE	128	1	500000	N	128	128	mail vpool size	SYS
MAL_LEAK_CHECK	0	0	1	N	0	0	mal leak check flag	SYS
HJ_BUF_GLOBAL_SIZE	500	10	500000	N	500	500	hash buf global size for hash join in megabytes	SYS
HJ_BUF_SIZE	50	2	100000	N	50	50	hash buf size for hash join in megabytes	SESSION
HJ_BLK_SIZE	1	1	50	N	1	1	hash blk size for hash join in megabytes	SESSION
HAGR_BUF_GLOBAL_SIZE	500	10	1000000	N	500	500	global buf size for hagr in megabytes	SYS
HAGR_BUF_SIZE	50	2	500000	N	50	50	buf size for hagr in megabytes	SESSION
HAGR_BLK_SIZE	1	1	50	N	1	1	blk size for hagr in megabytes	SESSION
MTAB_MEM_SIZE	8	1	1048576	N	8	8	mtab memory size in KB	IN FILE
FTAB_MEM_SIZE	0	0	65536	N	0	0	ftab memory size in KB	IN FILE
MMT_GLOBAL_SIZE	4000	10	1000000	N	4000	4000	memory map table global size in MB	SYS
MMT_SIZE	0	0	64	N	0	0	memory map table size in MB	SESSION
MMT_FLAG	1	1	2	N	1	1	ways of storing bdta data in memory map table	SESSION
DICT_BUF_SIZE	5	1	2048	N	5	5	dict buffer size	IN FILE
HFS_CACHE_SIZE	160	160	2000	N	160	160	hfs cache size	SYS
VM_STACK_SIZE	256	64	262144	N	256	256	vm stack size	IN FILE
VM_POOL_SIZE	64	32	1048576	N	64	64	vm pool size	IN FILE
VM_POOL_TARGET	32768	0	10485760	N	32768	32768	vm pool target size	IN FILE
SESS_POOL_SIZE	64	16	1048576	N	64	64	sess pool size	SYS
SESS_POOL_TARGET	32768	0	10485760	N	32768	32768	sess pool target size	SYS
RT_HEAP_TARGET	8192	8192	10485760	N	8192	8192	runtime heap target size	SYS
VM_MEM_HEAP	0	0	1	N	0	0	Whether to allocate memory to VM from HEAP	IN FILE
RFIL_RECV_BUF_SIZE	16	16	4000	N	16	16	redo file recover buffer size in Megabytes	IN FILE
N_MEM_POOLS	1	1	128	N	1	1	number of memory pools	IN FILE
COLDATA_POOL_SIZE	0	0	0	N	0	0	coldata pool size for each worker group in Megabytes	IN FILE
HAGR_DISTINCT_HASH_TABLE_SIZE	10000	10000	100000000	N	10000	10000	Size of hagr distinct hash table	SESSION
CNNTB_HASH_TABLE_SIZE	100	100	100000000	N	100	100	The size of hash table in connect-by operation	SESSION
GLOBAL_RTREE_BUF_SIZE	100	0	100000	N	100	100	The total size of buffer for rtree	SYS
SINGLE_RTREE_BUF_SIZE	10	0	1000	N	10	10	The size of buffer for single rtree	SESSION
SORT_OPT_SIZE	0	0	1024	N	0	0	once max memory size of radix sort assist count array	IN FILE
DFS_BUF_FLUSH_OPT	0	0	1	N	0	0	Whether to flush buffer page in opt mode for DFS storage	IN FILE
WORKER_THREADS	16	1	64	N	16	16	Number Of Worker Threads	IN FILE
TASK_THREADS	16	1	1000	N	16	16	Number Of Task Threads	IN FILE
UTHR_FLAG	0	0	1	N	0	0	User Thread Flag	READ ONLY
MAL_UTHR_FLAG	1	0	1	N	1	1	Mal User Thread Flag	READ ONLY
FAST_RW_LOCK	1	0	2	N	1	1	Fast Read Write Lock	READ ONLY
SPIN_TIME	4000	0	4000	N	4000	4000	Spin Time For Threads In Microseconds	IN FILE
WORK_THRD_STACK_SIZE	8192	1024	32768	N	8192	8192	Work Thread Stack Size In Kilobytes	IN FILE
WORK_THRD_RESERVE_SIZE	100	50	1024	N	100	100	Work Thread Reserve Stack Size In Kilobytes	IN FILE
WORKER_CPU_PERCENT	0	0	100	N	0	0	Percent of CPU number special for worker thread	READ ONLY
NESTED_C_STYLE_COMMENT	0	0	1	N	0	0	Flag for C style nested comment	SYS
USE_PLN_POOL	1	0	3	N	1	1	Query Plan Reuse Mode, 0: Forbidden; 1:strictly reuse, 2:parsing reuse, 3:mixed parsing reuse	IN FILE
DYN_SQL_CAN_CACHE	1	0	1	N	1	1	Dynamic SQL cache mode. 0: Forbidden; 1: Allowed if the USE_PLN_POOL is non-zero	SYS
VPD_CAN_CACHE	0	0	1	N	0	0	VPD SQL cache mode. 0: Forbidden; 1: Allowed if the USE_PLN_POOL is non-zero	IN FILE
RS_CAN_CACHE	0	0	2	N	0	0	Resultset cache mode. 0: Forbidden; 1: Allowed only if the USE_PLN_POOL is non-zero; 2: Allowed only be set	IN FILE
RS_CACHE_TABLES				N			Tables allowed to enable result set cache	READ ONLY
RS_CACHE_MIN_TIME	0	0	4294967294	N	0	0	Least time for resultset to be cached	SYS
RS_BDTA_FLAG	0	0	2	N	0	0	Resultset mode. 0: row; 2: bdta;	IN FILE
RS_BDTA_BUF_SIZE	32	8	32768	N	32	32	Maximum size of message in Kilobytes for BDTA cursor, it's valid only if RS_BDTA_FLAG is set to 2	IN FILE
RESULT_SET_LIMIT	10000	100	65000	N	10000	10000	Maximum Number Of Resultsets	SESSION
RESULT_SET_FOR_QUERY	0	0	1	N	0	0	Whether to generate result set for non-query statement	SESSION
SESSION_RESULT_SET_LIMIT	10000	100	65000	N	10000	10000	Maximum number of cached result sets for each session, 0 means unlimited	SYS
BUILD_FORWARD_RS	0	0	1	N	0	0	Whether to generate result set for forward only cursor	IN FILE
MAX_OPT_N_TABLES	6	3	8	N	6	6	Maximum Number Of Tables For Query Optimization	SESSION
MAX_N_GRP_PUSH_DOWN	5	1	1024	N	5	5	Maximum Number Of RELs For GRP push down Optimization	SESSION
CNNTB_MAX_LEVEL	20000	1	100000	N	20000	20000	Maximum Level Of Hierarchical Query	SESSION
CTE_MAXRECURSION	100	1	4294967294	N	100	100	Maximum recursive Level Of Common Expression Table	SESSION
CTE_OPT_FLAG	1	0	1	N	1	1	Optimize recursive with, 0: false, 1: convert refed subquery to invocation	SESSION
BATCH_PARAM_OPT	0	0	2	N	0	0	Enable optimize for batch param binded DML	IN FILE
CLT_CONST_TO_PARAM	0	0	1	N	0	0	Whether to convert constant to parameter	IN FILE
BUILD_HASH_BASE_COST	0	0	10000	N	0	0	build hash base cost using hash join	SESSION
CPU_COST_FACTOR	9500	1	10000000	N	9500	9500	the factor of calculating cpu cost	SESSION
LIKE_OPT_FLAG	31	0	31	N	31	31	optimized flag of LIKE expression	SESSION
FILTER_PUSH_DOWN	0	0	15	N	0	0	whether push down filter to base table	SESSION
USE_MCLCT	2	0	2	N	2	2	mclct use flag for replace mgat	SESSION
MPP_OP_JUMP	1	0	1	N	1	1	mpp operator jump for mal letter flag	SESSION
PHF_NTTS_OPT	1	0	1	N	1	1	phf ntts opt flag	SESSION
MPP_MOTION_SYNC	200	0	100000	N	200	200	mpp motion sync check number	SESSION
USE_FTTS	0	0	1	N	0	0	use ftts replace ntts flag	SESSION
INV_DETERMINISTIC_FLAG	0	0	1	N	0	0	consider all user defined function deterministic	SESSION
MULTI_HASH_DIS_OPT	1	0	1	N	1	1	phd multi hash join distributed opt flag	SESSION
MPP_UPD_DEL_OPT	2	0	2	N	2	2	update&delete opt flag, 0: false, 1: opt, 2: opt & ntts opt	SESSION
UPD_DEL_OPT	2	0	2	N	2	2	update&delete opt flag, 0: false, 1: opt, 2: opt & ntts opt	SESSION
MPP_DML_FORCE_OPT	0	0	1	N	0	0	dml force opt flag in mpp	SESSION
ENABLE_INVISIBLE_COL	1	0	1	N	1	1	enable invisible col	SESSION
ENABLE_INJECT_HINT	0	0	1	N	0	0	enable inject hint	SESSION
FETCH_PACKAGE_SIZE	512	32	65536	N	512	512	command fetch package size	SYS
UPD_QRY_LOCK_MODE	0	0	1	N	0	0	lock mode of FOR UPDATE query	SYS
ENABLE_DIST_IN_SUBQUERY_OPT	0	0	7	N	0	0	Whether to enable in-subquery optimization	SESSION
MAX_OPT_N_OR_BEXPS	7	7	64	N	7	7	maximum number of OR bool expressions for query optimization	SESSION
USE_HAGR_FLAG	0	0	1	N	0	0	Whether to use HAGR operator when can't use SAGR operator	SESSION
DTABLE_PULLUP_FLAG	1	0	1	N	1	1	the flag of pulling up derived table	SESSION
VIEW_PULLUP_FLAG	0	0	31	N	0	0	the flag of pulling up view	SESSION
VIEW_PULLUP_MAX_TAB	7	1	16	N	7	7	Maximum number of tables that can be handled when pulling up view	SESSION
STR_NULL_OPS_COMPATIBLE	0	0	1	N	0	0	Whether to set the result as null when one of the two additive strings is null	SESSION
GROUP_OPT_FLAG	4	0	7	N	4	4	the flag of opt group	SESSION
FROM_OPT_FLAG	0	0	1	N	0	0	the flag of opt from	SESSION
HAGR_PARALLEL_OPT_FLAG	0	0	1023	N	0	0	the flag of opt hagr in mpp or parallel	SESSION
HAGR_DISTINCT_OPT_FLAG	2	0	3	N	2	2	the flag of opt hagr distinct in mpp	SESSION
REFED_EXISTS_OPT_FLAG	1	0	3	N	1	1	Whether to optimize correlated exists-subquery into non-correlated in-subquery	SESSION
REFED_OPS_SUBQUERY_OPT_FLAG	0	0	7	N	0	0	Whether to optimize correlated op all/some/all-subquery into exists-subquery	SESSION
HASH_PLL_OPT_FLAG	0	0	15	N	0	0	the flag of cutting partitioned table when used hash join	SESSION
PARTIAL_JOIN_EVALUATION_FLAG	1	0	1	N	1	1	Whether to convert join type when upper operator is DISTINCT	SESSION
MOTION_OPT_FLAG	0	0	511	N	0	0	optimizer ways under new motion	SESSION
USE_FK_REMOVE_TABLES_FLAG	1	0	1	N	1	1	Whether to remove redundant join by taking advantage of foreign key constraint	SESSION
USE_FJ_REMOVE_TABLE_FLAG	0	0	2	N	0	0	Whether to remove redundant join by taking advantage of filter joining	SESSION
OUTER_JOIN_INDEX_OPT_FLAG	0	0	1	N	0	0	Whether to optimize outer join into index join when possible	SESSION
SLCT_OPT_FLAG	0	0	15	N	0	0	the flag of opt select to blkup, slct and scan	SESSION
SLCT_ERR_PROCESS_FLAG	0	0	1	N	0	0	How to handle error when processing single row	SESSION
MPP_HASH_LR_RATE	10	1	4294967294	N	10	10	The ratio of left child's cost to right child's cost of hash join in MPP environment that can influence the execution plan	SESSION
LPQ_HASH_LR_RATE	30	1	4294967294	N	30	30	The ratio of left child's cost to right child's cost of hash join in LPQ environment that can influence the execution plan	SESSION
USE_HTAB	1	0	1	N	1	1	Whether to use HTAB operator for the whole plan	SESSION
SEL_ITEM_HTAB_FLAG	0	0	15	N	0	0	Whether to use HTAB operator for correlated subquery in select items	SESSION
OR_CVT_HTAB_FLAG	1	0	2	N	1	1	Whether to use HTAB operator to optimizer or-expression	SESSION
OP_SUBQ_CVT_IN_FLAG	1	0	1	N	1	1	Whether to convert equal-subquery to in-subquery	SESSION
ENHANCED_SUBQ_MERGING	0	0	1	N	0	0	Whether to use merging subquery opt	SESSION
CASE_WHEN_CVT_IFUN	9	0	15	N	9	9	Flag of converting subquery in case-when expression to IF operator	SESSION
OR_NBEXP_CVT_CASE_WHEN_FLAG	0	0	1	N	0	0	Whether to convert or-expression to case-when expression	SESSION
NONCONST_OR_CVT_IN_LST_FLAG	0	0	1	N	0	0	Whether to convert nonconst or-expression to in-lst expression	SESSION
OUTER_CVT_INNER_PULL_UP_COND_FLAG	1	0	1	N	1	1	Whether to pull up join condition when outer join converts to inner join	SESSION
AUTOTRACE_LEVEL	0	0	2	N	0	0	trace level, 0:exec; 1: plan index ; 2: plan nl	SESSION
OPT_OR_FOR_HUGE_TABLE_FLAG	0	0	1	N	0	0	Whether to use HFSEK to optimize or-expression for HUGE table	SESSION
ORDER_BY_NULLS_FLAG	0	0	1	N	0	0	Whether to place NULL values to the end of the result set when in ascending order	SESSION
SUBQ_CVT_SPL_FLAG	1	0	31	N	1	1	Flag of indicating how to convert correlated subquery	SESSION
ENABLE_RQ_TO_SPL	1	0	1	N	1	1	Whether to convert correlated subquery to SPOOL	SESSION
MULTI_IN_CVT_EXISTS	0	0	1	N	0	0	Whether to convert multi-column-in subquery to exists subquery	SESSION
PRJT_REPLACE_NPAR	1	0	1	N	1	1	Whether to replace NPAR tree in NSEL after projection	SESSION
ENABLE_RQ_TO_INV	0	0	2	N	0	0	Whether to convert correlated subquery to temporary function	SESSION
SUBQ_EXP_CVT_FLAG	0	0	63	N	0	0	whether convert refered subquery exp to non-refered subquery exp	SESSION
USE_REFER_TAB_ONLY	0	0	1	N	0	0	Whether to pull down correlated table only when dealing with correlated subquery	SESSION
MAX_PHC_BE_NUM	512	512	20480000	N	512	512	space of bool expressions in phc optimization	SESSION
MAX_TABLES_IN_SELECT	100	100	150	N	100	100	maximum tables in select	SESSION
REFED_SUBQ_CROSS_FLAG	1	0	1	N	1	1	Whether to replace hash join with cross join for correlated subquery	SESSION
IN_LIST_AS_JOIN_KEY	0	0	1	N	0	0	Whether to use in-list expression as join key	SESSION
OUTER_JOIN_FLATING_FLAG	0	0	1	N	0	0	Flag of indicating whether outer join will be flattened	SESSION
TOP_ORDER_OPT_FLAG	0	0	1	N	0	0	The flag of optimizing the query with the top cluase and the order by clause	SESSION
PLACE_GROUP_BY_FLAG	0	0	2	N	0	0	The flag of optimizing the query with group_by and sfun by clause	SESSION
SINGLE_HTAB_REMOVE_FLAG	1	0	1	N	1	1	htab which used only once will remove	SESSION
TOP_DIS_HASH_FLAG	1	0	2	N	1	1	Flag of disable hash join in TOP-N query	SESSION
ENABLE_RQ_TO_NONREF_SPL	0	0	3	N	0	0	Whether to convert correlated query to non-correlated query	SESSION
OPTIMIZER_MODE	1	0	1	N	1	1	Optimizer mode	SESSION
NEW_MOTION	0	0	1	N	0	0	New Motion	SESSION
LDIS_NEW_FOLD_FUN	0	0	1	N	0	0	ldis use different fold fun with mdis	SESSION
DYNAMIC_CALC_NODES	0	0	1	N	0	0	different nodes of npln use different nubmer of calc sizes/threads	SESSION
OPTIMIZER_MAX_PERM	7200	1	4294967294	N	7200	7200	Optimizer max permutations	SESSION
ENABLE_INDEX_FILTER	0	0	2	N	0	0	enable index filter	SESSION
OPTIMIZER_DYNAMIC_SAMPLING	0	0	12	N	0	0	Dynamic sampling level	SESSION
TABLE_STAT_FLAG	0	0	1	N	0	0	How to use stat of table	SESSION
AUTO_STAT_OBJ	0	0	2	N	0	0	Flag of automatically collecting statistics and recording DML changing rows	SYS
NONREFED_SUBQUERY_AS_CONST	0	0	1	N	0	0	Whether to convert non-correlated subquery to const	SESSION
HASH_CMP_OPT_FLAG	0	0	15	N	0	0	Flag of operators that enable optimization with static hash table	SESSION
OUTER_OPT_NLO_FLAG	0	0	7	N	0	0	Flag of enable index join for those whose right child is not base table	SESSION
DISTINCT_USE_INDEX_SKIP	2	0	2	N	2	2	Whether to distinct_use_index_skip	SESSION
USE_INDEX_SKIP_SCAN	0	0	2	N	0	0	Whether to use index skip scan	SESSION
INDEX_SKIP_SCAN_RATE	0.003000	0	1	N	0.003000	0.003000	Rate in index skip scan	SESSION
SPEED_SEMI_JOIN_PLAN	1	0	7	N	1	1	Flag of speeding up the generating process of semi join plan	SESSION
COMPLEX_VIEW_MERGING	0	0	2	N	0	0	Flag of merging complex view into query without complex view	SESSION
HLSM_FLAG	1	1	3	N	1	1	Choose one method to realize hlsm operator	SESSION
DEL_HP_OPT_FLAG	0	0	31	N	0	0	Optimize delete for horization partition table	SESSION
OPTIMIZER_OR_NBEXP	0	0	31	N	0	0	Flag of or-expression optimization method	SESSION
OPTIMIZER_IN_NBEXP	0	0	2	N	0	0	Flag of in-expression optimization	SESSION
CNNTB_OPT_FLAG	0	0	31	N	0	0	Optimize hierarchical query	SESSION
ADAPTIVE_NPLN_FLAG	3	0	3	N	3	3	adaptive npln	SESSION
MULTI_UPD_OPT_FLAG	0	0	1	N	0	0	Optimize multi column update	SESSION
MULTI_UPD_MAX_COL_NUM	128	2	10000	N	128	128	Max value of column counts when optimize multi column update	SESSION
ENHANCE_BIND_PEEKING	0	0	1	N	0	0	Enhanced bind peeking	IN FILE
PHC_BE_ARR_NUM	0	0	5000	N	0	0	Number of phc be arr	IN FILE
GSA_NUM	10	0	2000	N	10	10	Number of global sort area	IN FILE
NBEXP_OPT_FLAG	3	0	3	N	3	3	Whether to enable optimization for bool expressions	SESSION
HAGR_HASH_ALGORITHM_FLAG	0	0	1	N	0	0	HAGR hash algorithm	SESSION
DIST_HASH_ALGORITHM_FLAG	0	0	1	N	0	0	Distinct hash algorithm	SESSION
UNPIVOT_ORDER_FLAG	0	0	1	N	0	0	Whether to sort the result of UNPIVOT operator by columns that don't appear in the UNPIVOT sub-sentence	SESSION
INVOCATION_OPT_FLAG	7	0	7	N	7	7	type of invocation opt flag	SESSION
VIEW_FILTER_MERGING	10	0	15	N	10	10	Flag of merging view filter	SESSION
ENABLE_PARTITION_WISE_OPT	0	0	1	N	0	0	whether enable partition-wise optimization	SESSION
OPT_MEM_CHECK	0	0	1	N	0	0	reduce search space when out of memory	SESSION
ENABLE_JOIN_FACTORIZATION	0	0	1	N	0	0	Whether to enable join factorization	SESSION
QUERY_INFO_BITS	0	0	2147483647	N	0	0	hidden query related parameters	SESSION
EXPLAIN_SHOW_FACTOR	1	1	100	N	1	1	factor of explain	SESSION
ERROR_COMPATIBLE_FLAG	0	0	1	N	0	0	enable/disable specified errors to be compatible with previous version	SESSION
HI_RIGHT_ORDER_FLAG	0	0	2	N	0	0	hi_right_order_flag	SESSION
HASH_JOIN_LOOP_TIMES	10	1	10	N	10	10	loop times of hash join right child	SESSION
ENABLE_NEST_LOOP_JOIN_CACHE	0	0	1	N	0	0	whether enable cache temporary result of nest loop join child	SESSION
ENABLE_TABLE_EXP_REF_FLAG	0	0	1	N	0	0	Whether allow table expression to reference brothers	SESSION
OPT_CVT_VAR_COST_FACTOR	1	0	4294967294	N	1	1	decrease cost of join convert var	SESSION
OPT_MAX_ADAPTIVE_EXEC_TIMES	1000	1	4294967294	N	1000	1000	valve of switch adaptive plan	SESSION
OPERATION_NEW_MOTION	0	0	15	N	0	0	child of inter can dis	SESSION
USE_MD_STAT	0	0	1	N	0	0	use md stat	SESSION
BEXP_CALC_ST_FLAG	0	0	15	N	0	1000	value of expression calculating selectivity	SESSION
AND_CVT_OR_BEXP_MAX_NUM	1024	2	100000	N	1024	1024	max number of and-expression convert to or-expression	SESSION
BIND_PARAM_OPT_FLAG	0	0	1	N	0	0	flag of optimizer bind parameter	IN FILE
EXP_BALANCE_FLAG	0	0	1	N	0	0	whether balance calculation expression	SYS
SEL_RATE_EQU	0.025000	0	1	N	0.025000	0.000000	Equal rate in selection	SESSION
SEL_RATE_SINGLE	0.050000	0	1	N	0.050000	0.000000	Single rate in selection	SESSION
HAVING_RATE_FACTOR	1	1	1000000	N	1	1	Single rate factor for having	SESSION
INTER_RATE_FACTOR	1	1	1000000	N	1	1	Single rate factor for inter	SESSION
RET_NULL_RATE_FACTOR	100	1	1000000	N	100	100	Single rate factor for ret_null	SESSION
NLIJ_AMPLIFY_FACTOR	4	1	10	N	4	4	nlij amplify factor	SESSION
CPU_SPEED	3145728	1	4294967294	N	3145728	3145728	Clock cycle of cpu in 1 ms	SESSION
N_RUNS	1	1	256	N	1	1	the number of parallel	SESSION
MEM_BANDWIDTH	3145728	1048576	1073741824	N	3145728	3145728	the bandwidth of memory	SESSION
LPQ_MOTION_FACTOR	58.000000	1	1073741824	N	58.000000	58.000000	lpq_motion_factor	SESSION
MPP_MOTION_FACTOR	100.000000	1	1073741824	N	100.000000	100.000000	mpp_motion_factor	SESSION
COST_RANK_FACTOR	1000.000000	1	1073741824	N	1000.000000	1000.000000	cost_rank_factor	SESSION
BASE_SCAN_CPU	140000	1	4294967294	N	140000	140000	the base number of CPU Clock cycle when scan	SESSION
BASE_SEEK_CPU	140000	1	4294967294	N	140000	140000	the base number of CPU Clock cycle when seek	SESSION
BASE_LKUP_CPU	62000	1	4294967294	N	62000	62000	the base number of CPU Clock cycle when lkup	SESSION
BASE_NLIJ_CPU	16000	1	4294967294	N	16000	16000	the base number of CPU Clock cycle when nlij	SESSION
BASE_HI_CPU	2683000	1	4294967294	N	2683000	2683000	the base number of CPU Clock cycle when hi	SESSION
BASE_MI_CPU	1000000	1	4294967294	N	1000000	1000000	the base number of CPU Clock cycle when mi	SESSION
BASE_NL_CPU	1000000	1	4294967294	N	1000000	1000000	the base number of CPU Clock cycle when nl	SESSION
BASE_FLT_CPU	140000	1	4294967294	N	140000	140000	the base number of CPU Clock cycle with filter calculating	SESSION
BASE_SORT_CPU	36000	1	4294967294	N	36000	36000	the base number of CPU Clock cycle with sort	SESSION
SCAN_CPU	330	1	4294967294	N	330	330	the number of CPU Clock cycle when scan dealing 1K data	SESSION
SEEK_CPU	400	1	4294967294	N	400	400	the number of CPU Clock cycle when seek dealing 1K data	SESSION
LKUP_CPU	2500	1	4294967294	N	2500	50000	the number of CPU Clock cycle when lkup dealing 1K data	SESSION
NLIJ_CPU	200	1	4294967294	N	200	200	the number of CPU Clock cycle when nlij dealing 1K data	SESSION
HI_CPU	400	1	4294967294	N	400	400	the number of CPU Clock cycle when hi dealing 1K data	SESSION
HI_SEARCH_CPU	200	1	4294967294	N	200	200	the number of CPU Clock cycle to search when hi dealing 1K data	SESSION
MI_CPU	300	1	2147483647	N	300	300	the number of CPU Clock cycle when mi dealing 1K data	SESSION
NL_CPU	200	1	4294967294	N	200	200	the number of CPU Clock cycle when nl dealing 1K data	SESSION
FLT_CPU	30	1	4294967294	N	30	30	the number of CPU Clock cycle when dealing 1K data with filter	SESSION
LARGE_SORT_CPU	40000	1	4294967294	N	40000	40000	the number of CPU Clock cycle when sorting dealing 1K data	SESSION
SMALL_SORT_CPU	200	1	4294967294	N	200	200	the number of CPU Clock cycle when sorting dealing 1K data	SESSION
MEM_INTENSE_DEGREE	0	0	100	N	0	0	the tensity of memory	SESSION
JOIN_ST_OPT_FLAG	0	0	2	N	0	0	Whether optimize join selectivity by using statistic info or not	SESSION
CKPT_RLOG_SIZE	100	0	4294967294	N	100	100	Checkpoint Rlog Size, 0: Ingore; else: Generate With Redo Log Size	SYS
CKPT_DIRTY_PAGES	10000	0	4294967294	N	10000	10000	Checkpoint Dirty Pages, 0: Ingore; else: Generate With Dirty Pages	SYS
CKPT_INTERVAL	300	0	2147483647	N	300	300	Checkpoint Interval In Seconds	SYS
CKPT_FLUSH_RATE	5.000000	0	100	N	5.000000	5.000000	Checkpoint Flush Rate(0.0-100.0)	SYS
CKPT_FLUSH_PAGES	1000	1000	100000	N	1000	1000	Minimum number of flushed pages for checkpoints	SYS
CKPT_WAIT_PAGES	128	1	1024	N	128	128	Maximum number of pages flushed for checkpoints	SYS
FORCE_FLUSH_PAGES	8	0	1000	N	8	8	Schedule Thread Force Flush Pages	SYS
DIRECT_IO	0	0	2	N	0	0	Flag For Io Mode(Non-Windows Only), 0: Using File System Cache; 1: Without Using File System Cache	IN FILE
IO_THR_GROUPS	2	1	512	N	2	2	The Number Of Io Thread Groups(Non-Windows Only)	IN FILE
HIO_THR_GROUPS	2	1	512	N	2	2	The Number Of Huge Io Thread Groups(Non-Windows Only)	IN FILE
FIL_CHECK_INTERVAL	0	0	4294967294	N	0	0	Check file interval in Second,0 means no_check(Non-Windows Only)	SYS
FAST_EXTEND_WITH_DS	1	0	1	N	1	1	How To Extend File's Size (Non-Windows Only), 0: Extend File With Hole; 1: Extend File With Disk Space	SYS
MAX_SESSIONS	100	1	65000	N	100	100	Maximum number of concurrent sessions	IN FILE
MAX_CONCURRENT_TRX	0	0	1500	N	0	0	Maximum number of concurrent transactions	IN FILE
CONCURRENT_TRX_MODE	0	0	1	N	0	0	Concurrent transactions mode	IN FILE
TRX_VIEW_SIZE	100	16	65000	N	100	512	The buffer size of local active transaction ids in TRX_VIEW	IN FILE
MAX_SESSION_STATEMENT	100	64	20480	N	100	100	Maximum number of statement handles for each session	SYS
MAX_SESSION_MEMORY	0	0	262144	N	0	0	Maximum memory(In Megabytes) a single session can use	SYS
MAX_CONCURRENT_OLAP_QUERY	0	0	100	N	0	0	Maximum number of concurrent OLAP queries	IN FILE
BIG_TABLE_THRESHHOLD	1000	0	4294967294	N	1000	1000	Threshhold value of a big table in 10k	SESSION
MAX_EP_SITES	64	2	1024	N	64	64	Maximum number of EP sites for MPP	READ ONLY
PORT_NUM	5236	1024	65534	N	5236	5236	Port number on which the database server will listen	IN FILE
LISTEN_IP				N			IP address on which the database server will listen	IN FILE
FAST_LOGIN	0	0	1	N	0	0	Whether to log information without login	IN FILE
DDL_AUTO_COMMIT	1	0	1	N	1	1	ddl auto commit mode, 0: not auto commit; 1: auto commit	READ ONLY
DDL_TV_TRIGGER	0	0	1	N	0	0	Whether support ddl for table trigger	IN FILE
COMPRESS_MODE	0	0	1	Y	0	0	Default Compress Mode For Tables That Users Created, 0: Not Compress; 1: Compress	SESSION
PK_WITH_CLUSTER	1	0	1	N	1	1	Default Flag For Primary Key With Cluster, 0: Non-Cluster; 1: Cluster	SESSION
EXPR_N_LEVEL	200	30	1000	N	200	200	Maximum nesting levels for expression	SESSION
N_PARSE_LEVEL	100	30	1000	N	100	100	Maximum nesting levels for parsing object	SESSION
MAX_SQL_LEVEL	500	100	1000	N	500	500	Maximum nesting levels of VM stack frame for sql	SYS
BDTA_SIZE	1000	1	10000	N	1000	1000	SIZE OF BDTA(1-10000)	IN FILE
OLAP_FLAG	2	0	2	N	2	2	OLAP FLAG, 1 means enable olap	SESSION
JOIN_HASH_SIZE	500000	1	250000000	N	500000	500000	the hash table size for hash join	SESSION
USE_DHASH_FLAG	0	0	2	N	0	0	use dhash flag: 0 means use static hash; 1 means use dynamic hash; 2 means use dynamic hash2	SESSION
ONE_GROUP_SIZE	0	0	250000000	N	0	0	hash flag one of cells: 0 not use flag; other one_group_size	SESSION
HFILES_OPENED	256	60	10000	N	256	256	max file number can open at one time for huge table	IN FILE
FAST_COMMIT	0	0	100	N	0	0	0 or 1 means normal commit; other may speed up commit, but may not assure ACID	SYS
ISO_IGNORE	0	0	1	N	0	0	ignore set iso level	SESSION
TEMP_SIZE	10	10	1048576	N	10	10	temp file size	IN FILE
TEMP_SPACE_LIMIT	0	0	4294967294	N	0	0	temp space limit in megabytes	SYS
FILE_TRACE	0	0	1	N	0	0	Whether to log operations of database files	IN FILE
COMM_TRACE	1	0	1	N	1	1	Whether to log warning information of communication	SYS
ERROR_TRACE	0	0	1	N	0	0	Whether to log error information, 1: NPAR ERROR	SYS
CACHE_POOL_SIZE	20	1	67108864	N	20	20	SQL buffer size in megabytes	IN FILE
PLN_DICT_HASH_THRESHOLD	20	1	67108864	N	20	20	Threshold in megabytes for plan dictionary hash table creating	IN FILE
STAT_COLLECT_SIZE	10000	0	10000000	N	10000	10000	min collect size for stat	SESSION
STAT_ALL	0	0	3	N	0	0	if collect all the sub-tables of a partition table	SESSION
PHC_MODE_ENFORCE	0	0	15	N	0	0	enforce the join mode	SESSION
ENABLE_HASH_JOIN	1	0	1	N	1	1	enable hash join	SESSION
ENABLE_INDEX_JOIN	1	0	1	N	1	1	enable index join	SESSION
ENABLE_MERGE_JOIN	1	0	1	N	1	1	enable merge join	SESSION
MPP_INDEX_JOIN_OPT_FLAG	0	0	1	N	0	0	enhance index inner join in MPP	SESSION
MPP_NLI_OPT_FLAG	0	0	3	N	0	0	enhance nest loop inner join in MPP	SESSION
MAX_PARALLEL_DEGREE	1	1	128	N	1	1	Maximum degree of parallel query	SESSION
PARALLEL_POLICY	0	0	2	Y	0	0	Parallel policy	IN FILE
PARALLEL_THRD_NUM	10	1	1024	N	10	10	Thread number for parallel task	IN FILE
PARALLEL_MODE_COMMON_DEGREE	1	1	1024	N	1	1	the common degree of parallel query for parallel-mode	SESSION
PUSH_SUBQ	0	0	7	N	0	0	Whether to push down semi join for correlated subquery	SESSION
OPTIMIZER_AGGR_GROUPBY_ELIM	1	0	1	N	1	1	Whether to attemp to eliminate group-by aggregations	SESSION
UPD_TAB_INFO	0	0	1	N	0	0	Whether to update table info when startup	IN FILE
ENABLE_IN_VALUE_LIST_OPT	6	0	31	N	6	6	Flag of optimization methods for in-list expression	SESSION
ENHANCED_BEXP_TRANS_GEN	3	0	3	N	3	3	Whether to enable enhanced transitive closure of boolean expressions	SESSION
ENABLE_DIST_VIEW_UPDATE	0	0	1	N	0	0	whether view with distinct can be updated	SYS
STAR_TRANSFORMATION_ENABLED	0	0	1	N	0	0	Whether to enable star transformation for star join queries	SESSION
OPTIMIZER_VERSION	70097	70000	70097	N	70097	70097	optimizer version	SESSION
MONITOR_INDEX_FLAG	0	0	2	N	0	0	monitor index flag	SESSION
AUTO_COMPILE_FLAG	1	0	1	N	1	1	Whether to compile the invalid objects when loading	SYS
RAISE_CASE_NOT_FOUND	0	0	1	N	0	0	Whether raise CASE_NOT_FOUND exception for no case item matched	SYS
PESUDO_TRXID_NAME	TRXID			N	TRXID	TRXID	pesudo column name for TRXID	IN FILE
PESUDO_PHYROWID_NAME	PHYROWID			N	PHYROWID	PHYROWID	pesudo column name for PHYROWID	IN FILE
FIRST_ROWS	100	1	1000	N	100	100	maximum number of rows when first returned to clients	SYS
LIST_TABLE	0	0	1	Y	0	0	Whether to convert tables to LIST tables when created	SESSION
ENABLE_PAGE_CHECK	0	0	2	N	0	0	flag for the page check, 0: disable 1: enable	READ ONLY
ENABLE_SPACELIMIT_CHECK	1	0	1	N	1	1	flag for the space limit check, 0: disable 1: enable	IN FILE
BUILD_VERTICAL_PK_BTREE	0	0	1	N	0	0	Whether to build physical B-tree for primary key on huge tables	READ ONLY
BDTA_PACKAGE_COMPRESS	0	0	1	N	0	0	Whether to compress BDTA packages	SESSION
HFINS_PARALLEL_FLAG	0	0	2	N	0	0	Flag of parallel policy for inserting on huge table	SYS
HFINS_MAX_THRD_NUM	100	4	200	N	100	100	Maximum number of parallel threads that responsible for inserting on huge table	SYS
LINK_CONN_KEEP_TIME	15	0	2147483647	N	15	15	Max idle time in minute for DBLINK before being closed	IN FILE
DETERMIN_CACHE_SIZE	5	1	1000	N	5	5	Deterministic function results cache size(M)	SYS
FAST_RELEASE_LOB_PAGE	0	0	1	N	0	0	Whether release lob page quickly by async	SYS
NTYPE_MAX_OBJ_NUM	1000000	2000	100000000	N	1000000	1000000	Maximum number of objects and strings in composite data type	SYS
CTAB_SEL_WITH_CONS	0	0	1	N	0	0	Whether to build constraints when creating table by query	SYS
HUGE_WITH_DELTA	1	0	1	N	1	1	Whether support with delta huge table only, 0: NO 1: YES	READ ONLY
HLDR_BUF_SIZE	8	4	1024	N	8	8	HUGE table fast loader buffer size in Megabytes	SYS
HLDR_BUF_TOTAL_SIZE	4294967294	100	4294967294	N	4294967294	4294967294	HUGE table fast loader buffer total size in Megabytes	SYS
HLDR_REPAIR_FLAG	0	0	1	N	0	0	Flag of repairing huge table after exception, 0: NO 1: YES	SYS
HLDR_FORCE_COLUMN_STORAGE	1	0	1	N	1	1	Whether force column storage for last section data, 0: NO 1: YES	SYS
HLDR_FORCE_COLUMN_STORAGE_PERCENT	80	50	100	N	80	80	Minumun percent of unfully section data for huge force column storage	SYS
HLDR_HOLD_RATE	1.500000	1	65535	N	1.500000	1.500000	THE minimum rate to hold hldr of column number(1-65535)	SYS
HLDR_MAX_RATE	2	2	65535	N	2	2	THE minimum rate to create hldr of column number(2-65535)	SYS
HUGE_ACID	0	0	2	N	0	0	Flag of concurrent mechanism for HUGE tables	SYS
HUGE_STAT_MODE	2	0	2	N	2	2	Flag of default stat mode when create huge table, 0:NONE 1:NORMAL 2:ASYNCHRONOUS	SESSION
HFS_CHECK_SUM	1	0	1	N	1	1	Whether to check sum val for hfs data	IN FILE
HBUF_DATA_MODE	0	0	1	N	0	0	Whether to uncompress and decrypt data before read into HUGE buffer	IN FILE
HUGE_TABLE_SWITCH	0	0	3	N	0	0	Huge table switch for DDL CREATE. 0:with raux, 3:without raux	SYS
DBLINK_OPT_VIEW	1	0	1	N	1	1	dblink query optimize for local view	SYS
DBLINK_OPT_FLAG	509	0	1023	N	509	509	optimize dblink query flag	SESSION
ELOG_REPORT_LINK_SQL	0	0	1	N	0	0	Whether to write the SQLs that sent to remote database by DBLINKs into error log file	SESSION
DBLINK_COL_EXTEND	1	1	10	N	1	1	Magnification of dblink's varchar buffer length	SYS
FILL_COL_DESC_FLAG	0	0	1	N	0	0	Whether to return columns description while database returns results	SYS
BTR_SPLIT_MODE	0	0	1	N	0	0	Split mode for BTREE leaf, 0: split half and half, 1: split at insert point	SYS
BLOB_OUTROW_REC_STOR	5	0	10	N	5	5	Flag for blob outrow record storage	SYS
TS_RESERVED_EXTENTS	64	2	1024	N	64	64	Number of reserved extents for each tablespace when startup	IN FILE
TS_SAFE_FREE_EXTENTS	512	128	65534	N	512	512	Number of free extents which considered as safe value for each tablespace	IN FILE
TS_MAX_ID	8192	512	65517	N	8192	8192	Maximum ID value for tablespaces in database	IN FILE
TS_FIL_MAX_ID	255	64	8191	N	255	255	Maximum ID value for files in tablespace	IN FILE
DECIMAL_FIX_STORAGE	0	0	1	N	0	0	Whether convert decimal data to fixed length storage	SESSION
FORCE_RECLAIM	0	0	1	N	0	0	Whether reclaim class instances in force mode	SYS
SQL_SAFE_UPDATE_ROWS	0	0	2147483647	N	0	0	Maximum rows can be effected in an update&delete statement	SYS
ENABLE_HUGE_SECIND	1	0	1	N	1	1	Whether support huge second index, 0: disable, 1: enable	SYS
TRXID_UNCOVERED	0	0	1	N	0	0	Whether disable scanning 2nd index only when pseudo column trxid used, 0: disable, 1: enable	SESSION
LOB_MAX_INROW_LEN	900	900	8000	N	900	900	Max lob data inrow len	SYS
RS_PRE_FETCH	0	0	1	N	0	0	Whether enable result pre-fetch	SYS
DFS_PAGE_FLUSH_VALIDATE	1	0	1	N	1	1	Whether enable validate page when flush in DDFS	SYS
GEN_SQL_MEM_RECLAIM	1	0	1	N	1	1	Whether reclaim memory space after generating each SQL's plan	SYS
TIMER_TRIG_CHECK_INTERVAL	60	1	60	N	60	60	Server check timer trigger interval	SYS
DFS_HUGE_SUPPORT	1	0	1	N	1	1	Whether support huge table operation in DDFS	IN FILE
INNER_INDEX_DDL_SHOW	1	0	1	N	1	1	Whether to show inner index ddl.	SESSION
LOAD_TABLE				N			need to pre-load table	READ ONLY
LOAD_HTABLE				N			need to pre-load htable	READ ONLY
CLT_CACHE_TABLES				N			Tables that can be cached in client	READ ONLY
RLOG_BUF_SIZE	1024	1	32768	N	1024	1024	The Number Of Log Pages In One Log Buffer	IN FILE
RLOG_POOL_SIZE	256	1	4096	N	256	256	Redo Log Pool Size In Megabyte	IN FILE
RLOG_PARALLEL_ENABLE	0	0	1	N	0	0	Whether to enable database to write redo logs in parallel mode	IN FILE
RLOG_GEN_FOR_HUGE	0	0	1	N	0	0	Whether to generate rlog for huge table, 0: disable, 1: enable	READ ONLY
RLOG_IGNORE_TABLE_SET	1	0	1	N	1	1	Whether ignore table set	SYS
RLOG_APPEND_LOGIC	0	0	3	N	0	0	Type of logic records in redo logs	SYS
RLOG_APPEND_SYSTAB_LOGIC	0	0	1	N	0	0	Whether to write logic records of system tables in redo logs when RLOG_APPEND_LOGIC is set as 1	SYS
RLOG_CHECK_SPACE	0	0	1	N	0	0	Whether to check that the available space in redo logs is enough	SYS
RLOG_SAFE_SPACE	128	0	1024	N	128	128	Free redo log size in megabytes that can be considered as a save value	IN FILE
RLOG_SEND_APPLY_MON	64	1	1024	N	64	64	Monitor recently send or apply rlog_buf info	IN FILE
LOG_STABLE	1	0	1	N	1	1	whether flush log	IN FILE
LOG_BUF_SIZE	1024	1	32768	N	1024	1024	The Number Of Log Pages In One Log Buffer	IN FILE
LOG_POOL_SIZE	256	1	4096	N	256	256	Redo Log Pool Size In Megabyte	IN FILE
RLOG_COMPRESS_LEVEL	0	0	10	N	0	0	The redo log compress level,value in [0,10],0:do not compressed	IN FILE
RLOG_ENC_CMPR_THREAD	4	1	64	N	4	4	The redo log thread number of encrypt and compress task,value in [1,64],default 4	IN FILE
RLOG_PKG_SEND_ECPR_ONLY	0	0	1	N	0	0	Only send encrypted or compressed data to standby instance without original data	IN FILE
DFS_RLOG_SEND_POLICY	1	0	1	N	1	1	DFS rlog send policy, 0: sync; 1:async	IN FILE
REDO_PWR_OPT	1	0	1	N	1	1	Whether to enable PWR optimization when system restarted after failure	IN FILE
REDO_IGNORE_DB_VERSION	0	0	1	N	0	0	Whether to check database version while database is redoing logs	IN FILE
REDO_BUF_SIZE	64	0	512	N	64	64	The max buffer size of rlog redo In Megabyte	IN FILE
REDOS_BUF_SIZE	1024	0	65536	N	1024	1024	The max buffer size of rlog redo for standby In Megabyte	IN FILE
REDOS_MAX_DELAY	1800	0	7200	N	1800	1800	The permitted max delay for one rlog buf redo on standby In Second	IN FILE
REDOS_BUF_NUM	4096	0	99999	N	4096	4096	The max apply rlog buffer num for standby	IN FILE
REDOS_PRE_LOAD	32	0	10000	N	32	32	Number of pre-load apply rlog buffer for standby	SYS
REDOS_PARALLEL_NUM	1	1	64	N	1	1	The parallel redo thread num	IN FILE
ISOLATION_LEVEL	1	1	3	N	1	1	Default Transaction Isolation Level, 1: Read Commited; 3: Serializable	IN FILE
DDL_WAIT_TIME	10	0	60	N	10	10	Maximum waiting time in seconds for DDLs	SESSION
BLDR_WAIT_TIME	10	0	604800	N	10	10	Maximum waiting time in seconds for BLDR	SYS
MPP_WAIT_TIME	10	0	600	N	10	10	Maximum waiting time in seconds for locks on MPP	SYS
FAST_RELEASE_SLOCK	1	0	1	N	1	1	Whether to release share lock as soon as possible	SYS
SESS_CHECK_INTERVAL	3	1	60	N	3	3	Interval time in seconds for checking status of sessions	SESSION
LOCK_TID_MODE	1	0	1	N	1	1	Lock mode for select-for-update operation	SYS
LOCK_TID_UPGRADE	0	0	1	N	0	0	Upgrade tid lock to X mode, 0:no, 1:yes	SYS
NOWAIT_WHEN_UNIQUE_CONFLICT	0	0	1	N	0	0	Whether to return immediately when unique constraint violation conflict happens	IN FILE
UNDO_EXTENT_NUM	4	1	256	N	4	4	Number of initial undo extents for each worker thread	IN FILE
MAX_DE_TIMEOUT	10	1	3600	N	10	10	maximum external function waiting time in seconds	SESSION
TRX_MODE	0	0	1	N	0	0	Trx mode	READ ONLY
TRX_RLOG_WAIT_MODE	0	0	1	N	0	0	Trx rlog wait mode	READ ONLY
TRANSACTIONS	75	1	1000	N	75	75	Maximum number of concurrent transactions	IN FILE
MVCC_RETRY_TIMES	5	0	4294967294	N	5	5	Maximum retry times while MVCC conflicts happen	IN FILE
MVCC_PAGE_OPT	1	0	1	N	1	1	Page visible optimize for MVCC	SYS
ENABLE_FLASHBACK	1	0	1	N	1	1	Whether to enable flashback function	SYS
UNDO_RETENTION	90.000000	0	86400	N	90.000000	90.000000	Maximum retention time in seconds for undo pages since relative transaction is committed	SYS
PARALLEL_PURGE_FLAG	0	0	1	N	0	0	flag for parallel purge	IN FILE
PSEG_MGR_FLAG	0	0	1	N	0	0	Only use manager segment to record trx info, 0: no, 1: yes	READ ONLY
PURGE_WAIT_TIME	500	0	60000	N	500	500	Maximum wait time in microseconds for purging undo pages	SYS
PURGE_DEL_OPT	0	0	2	N	0	0	flag for purge delete optimize	SYS
PSEG_PAGE_OPT	1	0	1	N	1	1	The flag for pages in purge segment optimized	SYS
FAST_RELEASE_LOB_SLOCK	0	0	1	N	0	0	Whether release lob lock after opertion on lob via msg, 0: keep 1: release	SESSION
HASH_ACTIVE_TRX_VIEW	0	0	1024	N	0	0	When value > 10, hash table will be used for active trx view if there was more trxes than configured	IN FILE
PSEG_RECV	3	0	3	N	3	3	Whether to rollback active transactions and purge committed transactions when system restarts after failure	SYS
ENABLE_IGNORE_PURGE_REC	0	0	1	N	0	0	Whether to ignore purged records when returning -7120	SESSION
ENABLE_TMP_TAB_ROLLBACK	1	0	1	N	1	1	enable temp table rollback	SYS
ROLL_ON_ERR	0	0	1	N	0	0	Rollback mode on Error, 0: rollback current statement 1: rollback whole transaction	SYS
XA_TRX_IDLE_TIME	60	30	36000	N	60	60	Xa transaction idle time	SYS
LOB_MVCC	1	0	1	N	1	1	Whether LOB access in MVCC mode	SYS
LOCK_DICT_OPT	2	0	2	N	2	2	lock dict optimize	READ ONLY
TRX_DICT_LOCK_NUM	64	0	1024	N	64	64	Maximum ignorable dict lock number	SYS
PWD_POLICY	2	0	31	N	2	2	Flag of password policy	READ ONLY
PWD_MIN_LEN	9	9	48	N	9	9	Password min length in byte, it's valid only if PWD_POLICY&2 not equal to 0	READ ONLY
ENABLE_ENCRYPT	0	0	2	N	0	0	Encrypt Mode For Communication, 0: Without Encryption; 1: SSL Encryption; 2: SSL Authentication	IN FILE
CLIENT_UKEY	0	0	1	N	0	0	Client ukey, 0: all, active by Client; 1: Force client ukey Authentication	IN FILE
MIN_SSL_VERSION	771	0	4294967294	N	771	771	SSL minimum version For Communication, For example, 0: all, 0x0301: TLSv1, 0x0302: TLSv1.1, 0x0303: TLSv1.2, 0x0304: TLSv1.3	IN FILE
ENABLE_UDP	0	0	2	N	0	0	Enable udp For Communication, 0: disable; 1: single; 2: multi	IN FILE
UDP_TRACE_MODE	0	0	1	N	0	0	Whether open udp trace log, 0: disable; 1: enable	IN FILE
UDP_MAX_IDLE	15	5	60	N	15	15	Udp max waiting time in second	IN FILE
UDP_BTU_COUNT	8	4	32	N	8	8	Count of udp batch transfer units	IN FILE
ENABLE_IPC	0	0	1	N	0	0	Enable ipc for communication, 0: disable; 1: enable	IN FILE
ENABLE_AUDIT	0	0	2	N	0	0	Flag For Allowing Audit, 0: no audit 1: normal audit 2:normal audit and realtime audit	READ ONLY
AUDIT_FILE_FULL_MODE	1	1	2	N	1	1	operation mode when audit file is full, 1: delete old file; 2: no longer to write audit records	IN FILE
AUDIT_MAX_FILE_SIZE	100	1	4096	N	100	100	maximum audit file size in Megabytes	SYS
AUDIT_IP_STYLE	0	0	1	N	0	0	IP style in audit record, 0: IP, 1: IP(hostname), default 0	SYS
ENABLE_OBJ_REUSE	0	0	1	N	0	0	Whether to enable objects reuse mechanism	READ ONLY
ENABLE_REMOTE_OSAUTH	0	0	1	N	0	0	Whether to enable remote authorization by operating system users	READ ONLY
ENABLE_LOCAL_OSAUTH	0	0	1	N	0	0	Whether to enable local authorization by operating system users	READ ONLY
MSG_COMPRESS_TYPE	2	0	2	N	2	2	Flag of message compression mode	IN FILE
ENABLE_STRICT_CHECK	0	0	1	N	0	0	Whether to check access rights to objects that exist as part of EXECUTE IMMEDIATE sentences in store procedures or functions	READ ONLY
MAC_LABEL_OPTION	1	0	2	N	1	1	Flag of access rights to SP_MAC_LABEL_FROM_CHAR	READ ONLY
RESTRICT_DBA	0	0	1	N	0	0	Whether restrict dba, 0: Disable; 1: Enable, but only secrurity admin has the privilege	READ ONLY
LDAP_HOST				N			LDAP Server HOST ip or name	READ ONLY
AUTO_ENCRYPT	0	0	1	N	0	0	Whether support inputing key by user for auto encrypt, 0: no; 1: yes	READ ONLY
COMM_ENCRYPT_NAME				N			Communication encrypt name, if it is null then the communication is not encrypted	IN FILE
COMM_VALIDATE	1	0	1	N	1	1	Whether to validate message	SYS
MESSAGE_CHECK	0	0	1	N	0	0	Whether to check message body	SYS
STARTUP_TIMEOUT	5	5	10000	N	5	5	Recieve Timeout for STARTUP command	SYS
ENABLE_EXTERNAL_CALL	0	0	1	N	0	0	Whether permit external call	READ ONLY
EXTERNAL_JFUN_PORT	6363	128	65534	N	6363	6363	DmAgent port for java external fun	SYS
EXTERNAL_AP_PORT	4236	1024	65534	N	4236	4236	AP port for external fun	SYS
ENABLE_PL_SYNONYM	0	0	1	N	0	0	Whether try to resolve PL object name by synonym.	SYS
ENABLE_DDL_ANY_PRIV	0	0	1	N	0	0	Whether enable grant and revoke ddl any privilege.	READ ONLY
FORCE_CERTIFICATE_ENCRYPTION	0	0	1	N	0	0	Whether to encrypt login user name and password use certificate	READ ONLY
SEC_PRIV_MODE	0	0	2	N	0	0	Security privilege management mode, 0: TRADITION, 1: BMJ, 2:EVAL	READ ONLY
REGEXP_MATCH_PATTERN	0	0	1	N	0	0	Regular expression match pattern, 0: support non-greedy match; 1: only support greedy match	SESSION
SHOW_LOGIN_FAIL_TIMES	0	0	1	N	0	0	Internal feature	IN FILE
DATA_VALIDATE	0	0	2	N	0	0	Whether to validate data format	SYS
VM_STACK_VALIDATE	2	0	2	N	2	2	Whether to validate VM value stack	SYS
BACKSLASH_ESCAPE	0	0	1	N	0	0	Escape Mode For Backslash, 0: Not Escape; 1: Escape	SESSION
STR_LIKE_IGNORE_MATCH_END_SPACE	1	0	1	N	1	1	Whether to ignore end space of strings in like clause	SESSION
CLOB_LIKE_MAX_LEN	10240	8	102400	N	10240	10240	Maximum length in kilobytes of CLOB data that can be filtered by like clause	IN FILE
EXCLUDE_DB_NAME				N			THE db names which DM7 server can exclude	IN FILE
MS_PARSE_PERMIT	0	0	2	N	0	0	Whether to support SQLSERVER's parse style	IN FILE
COMPATIBLE_MODE	0	0	6	Y	0	0	Server compatible mode, 0:none, 1:SQL92, 2:Oracle, 3:MS SQL Server, 4:MySQL, 5:DM6, 6:Teradata	IN FILE
DATETIME_FMT_MODE	0	0	1	N	0	0	Date Fmt compatible mode, 0:none, 1:Oracle	SYS
DOUBLE_MODE	0	0	1	N	0	0	Calc double fold mode, 0:8bytes, 1:6bytes	IN FILE
CASE_COMPATIBLE_MODE	1	0	2	N	1	1	Case compatible mode, 0:none, 1:Oracle, 2:Oracle(new rule)	SYS
EXCLUDE_RESERVED_WORDS				N			The reserved words to be excluded	IN FILE
COUNT_64BIT	1	0	1	Y	1	1	Whether to set data type for COUNT as BIGINT	SESSION
EXCLUDE_MS_DBO	0	0	1	N	0	0	Whether exclude MS SQLSERVER's dbo schema	IN FILE
CALC_AS_DECIMAL	0	0	2	N	0	0	Whether integer CALC as decimal, 0: no, 1:only DIV, 2:all only has charactor	IN FILE
DEC_CALC_MODE	0	0	1	N	0	0	Decimal calc compatible mode, 0: default, 1:DM6	IN FILE
CMP_AS_DECIMAL	0	0	2	N	0	0	Whether integer compare as decimal, 0: no, 1:part, 2:all	IN FILE
CAST_VARCHAR_MODE	1	0	1	N	1	1	Whether to convert illegal string to special pseudo value when converting string to integer	SYS
PL_SQLCODE_COMPATIBLE	0	0	1	N	0	0	Whether to set SQLCODE in PL/SQL compatible with ORACLE as far as possible	IN FILE
EXCLUDE_PKG_NAME	0	0	1	N	0	0	Whether ignore pkg prefix, 0: no, 1:yes	SESSION
CHAR_TO_BLOB_DIRECT	0	0	1	N	0	0	Whether CHARACTOR can convert to BLOB directly, 0: no, 1:yes	SYS
BINARY_TO_LOB_FLAG	1	0	1	N	1	1	Flag of the priority level of BINARY converted to BLOB is higher than CLOB, 0:No, 1:Yes	IN FILE
TIMESTAMP_WITH_PREC	0	0	1	N	0	0	Whether TIMESTAMP show precision in some views ,0:No, 1:Yes	SYS
LEGACY_SEQUENCE	0	0	1	N	0	0	Whether sequence in legacy mode, 0: no, 1:yes	SYS
DM6_TODATE_FMT	0	0	1	N	0	0	To Date' HH fmt hour system, 0: 12(defalut) , 1: 24(DM6)	IN FILE
EMPTY_STR_TO_NULL_LOB	1	0	1	N	1	1	Whether convert empty string as NULL BLOB/CLOB	SYS
PK_MAP_TO_DIS	0	0	1	N	0	0	Whether map pk cols to distributed cols automatically	SYS
MERGE_SRC_MULTI_ROWS_IGNORE	0	0	1	N	0	0	Whether ignore src_multi_rows in merge into stmt	SYS
SYS_INDEX_MATCH_IGNORE	0	0	1	N	0	0	Whether ignore sys index match check when creating	SYS
PROXY_PROTOCOL_MODE	0	0	1	N	0	0	PROXY PROTOCOL mode, 0: close; 1: open	SYS
DROP_CASCADE_VIEW	0	0	1	N	0	0	Whether to drop cascade view while dropping table or view	SESSION
FINS_LOCK_MODE	1	0	2	N	1	1	FAST INSERT LOCK TABLE MODE 0: KEEP LOCK; 1: LOCK NOWAIT AND RELEASE LOCK 2: LOCK TIMEOUT AND RELEASE LOCK	IN FILE
DML_TTS_OPT	0	0	1	N	0	0	Whether ENABLE tts optimization for DML, 0:disable 1:enable	SESSION
SVR_LOG_NAME	SLOG_ALL			N	SLOG_ALL	SLOG_ALL	Using which sql log sys in sqllog.ini	SYS
SQL_TRACE_MASK	1			N	1	1	A mask value that indicates what type of SQL requests need to be logged into SQLs record file	SYS
SVR_LOG_FILE_NUM	0	0	1024	N	0	0	number of files for logging sql requests	SYS
SVR_LOG	0	0	3	N	0	0	Whether the Sql Log sys Is open or close. 1:open, 0:close, 2:use switch and detail mode. 3:use not switch and simple mode.	SYS
SVR_LOG_SWITCH_COUNT	100000	1000	10000000	N	100000	100000	maximum number of SQLs logged in a file	SYS
SVR_LOG_ASYNC_FLUSH	0	0	1	N	0	0	Whether to enable asynchronous refresh method when logging SQLs into SQLs record file	SYS
SVR_LOG_MIN_EXEC_TIME	0	0	4294967294	N	0	0	minimum execute time(ms) of SQLs logged	SYS
SVR_LOG_FILE_PATH	../log			N	../log	../log	File Path for SQLs Log	SYS
GDB_THREAD_INFO	0	0	1	N	0	0	Generate gdb thread info while dm_sys_halt. 1: yes; 0: no	IN FILE
TRACE_PATH	/dm8/data/PROD/trace			N	/dm8/data/PROD/trace		System trace path name	READ ONLY
SVR_OUTPUT	0	0	1	N	0	0	Whether print at background	SYS
ENABLE_ECS	0	0	1	N	0	0	Whether to enable elastic calc system	IN FILE
ECS_HB_INTERVAL	60	0	4294967294	N	60	60	HB interval for elastic calc system	IN FILE
EP_GROUP_NAME	DMGROUP			N	DMGROUP	DMGROUP	Server group name as worker	IN FILE
AP_GROUP_NAME	DMGROUP			N	DMGROUP	DMGROUP	Server group name as cooperative worker	IN FILE
DCRS_IP	LOCALHOST			N	LOCALHOST	LOCALHOST	IP on which the dcrs server will listen	IN FILE
DCRS_PORT_NUM	6236	0	65534	N	6236	6236	Port number on which the dcrs server will listen	IN FILE
AP_IP	LOCALHOST			N	LOCALHOST	LOCALHOST	The ap server IP for dcrs	IN FILE
AP_PORT_NUM	0	0	65534	N	0	0	Port number on which the ap server will listen	IN FILE
AP_PARALLEL_DEGREE	10	0	10000	N	10	10	Maximum degree of parallel for ap	IN FILE
ENABLE_ECS_MSG_CHECK	0	0	1	N	0	0	Whether to enable elastic check msg accumulate	IN FILE
ENABLE_MONITOR	1	0	1	N	1	1	Whether to enable monitor	SYS
MONITOR_TIME	1	0	1	N	1	1	Whether to enable monitor timing	SYS
MONITOR_SYNC_EVENT	0	0	1	N	0	0	Whether to enable monitor sync event	SYS
MONITOR_SQL_EXEC	0	0	2	N	0	0	Whether to enable monitor sql execute	SESSION
ENABLE_FREQROOTS	0	0	2	N	0	0	Whether to collect pages that used frequently	IN FILE
MAX_FREQ_ROOTS	200000	0	10000000	N	200000	200000	Maximum number of frequently used pages that will be collected	IN FILE
MIN_FREQ_CNT	100000	1	10000000	N	100000	100000	Minimum access counts of page that will be collected as frequently used pages	IN FILE
LARGE_MEM_THRESHOLD	1000	0	10000000	N	1000	1000	Large mem used threshold by k	SYS
ENABLE_MONITOR_DMSQL	1	0	1	N	1	1	Flag of performance monitoring:sql or method exec time	SESSION
ENABLE_TIMER_TRIG_LOG	0	0	1	N	0	0	Whether to enable timer trigger log	SYS
IO_TIMEOUT	300	0	3600	N	300	300	Maximum time in seconds that read from disk or write to disk	SYS
DW_MAX_SVR_WAIT_TIME	0	0	65534	N	0	0	Maximum time in seconds that server will wait for DMWATCHER to startup	SYS
DW_ERROR_TIME	60	0	1800	N	60	60	Time in seconds that used to determine whether DMWATCHER exist	SYS
DW_INACTIVE_INTERVAL	60	0	1800	N	60	60	Time in seconds that used to determine whether DMWATCHER exist	SYS
DW_PORT	0	1024	65534	N	0	0	Instance tcp port for watch2	READ ONLY
ALTER_MODE_STATUS	1	0	1	N	1	1	Whether to permit database user to alter database mode and status by SQLs, 1: yes, 0: no	SYS
ENABLE_OFFLINE_TS	1	0	2	N	1	1	Whether tablespace can be offline	SYS
SESS_FREE_IN_SUSPEND	60	0	1800	N	60	60	Time in seconds for releasing all sessions in suspend mode after archive failed	SYS
SUSPEND_WORKER_TIMEOUT	600	60	3600	N	600	600	Suspend worker thread timeout in seconds	SYS
SUSPENDING_FORBIDDEN	0	0	1	N	0	0	Suspending worker thread is forbidden	READ ONLY
DW_CONSISTENCY_CHECK	0	0	1	N	0	0	Whether to check consistency for standby database, 1: yes, 0: no	SYS
TABLE_SWITCH	0	0	133	N	0	0	Table switch.0:self, 1: vertical, 2:huge, 3:global tmp, 4:list, 5:using long row	SYS
ADVANCE_LOG_FLAG	0	0	1	N	0	0	Advance Log.0:self, 1: open	SYS
CTI_HASH_SIZE	100000	1000	10000000	N	100000	100000	the hash table size for context index query	SESSION
CTI_HASH_BUF_SIZE	50	1	4000	N	50	50	the hash table cache size in Megabytes for context index query	SESSION
USE_FORALL_ATTR	0	0	1	N	0	0	Whether to use cursor attributes of FORALL statements	SESSION
ALTER_TABLE_OPT	0	0	3	Y	0	0	Whether to optimize ALTER TABLE operation(add, modify or drop column)	SESSION
ENABLE_DCP_MODE	0	0	1	N	0	0	Whether to work as a proxy for database cluster	IN FILE
DCP_PORT_NUM	5237	1024	65534	N	5237	5237	Port number on which DCP will listen	IN FILE
DCP_CONN_POOL_SIZE	1000	1	100000	N	1000	1000	DCP connection pool size	SYS
USE_RDMA	0	0	1	N	0	0	Whether to use rdma	IN FILE
MAIL_INI	0	0	1	N	0	0	dmmal.ini	IN FILE
MAL_INI	0	0	1	N	0	0	dmmal.ini	IN FILE
ARCH_INI	1	0	1	N	1	1	dmarch.ini	SYS
REP_INI	0	0	1	N	0	0	dmrep.ini	IN FILE
LLOG_INI	0	0	1	N	0	0	llog.ini	IN FILE
TIMER_INI	0	0	1	N	0	0	timer.ini	IN FILE
MPP_INI	0	0	1	N	0	0	dmmpp.ini	IN FILE
MPP_FILE_INI	0	0	1	N	0	0	dmmpp.ini	READ ONLY
DFS_INI	0	0	1	N	0	0	dmdfs.ini	IN FILE
GLOBAL_EXTENT_N	256	0	4294967294	N	256	0	global_extent_n	READ ONLY
GLOBAL_PAGE_N	4096	0	4294967294	N	4096	0	tglobal_page_n	READ ONLY
GLOBAL_INODE_N	226	0	4294967294	N	226	0	global_inode_n	READ ONLY
GLOBAL_PAGE_TAIL_POS	16376	0	4294967294	N	16376	0	global_page_tail_pos	READ ONLY
GLOBAL_PAGE_SIZE_MASK	4294950912	0	4294967294	N	4294950912	0	global_page_size_mask	READ ONLY
GLOBAL_STR_CASE_SENSITIVE	0	0	4294967294	N	0	0	global_str_case_sensitive	READ ONLY
GLOBAL_PRIV_FLAG	0	0	1	N	0	0	global_priv_flag	READ ONLY
GLOBAL_PAGE_SIZE	16384	0	4294967294	N	16384	0	global_page_size	READ ONLY
EXTERNAL_CIPHER_ID	0	0	4294967294	N	0	0	external_cipher_id	READ ONLY
EXTERNAL_HASH_ID	0	0	4294967294	N	0	0	external_hash_id	READ ONLY
EXTERNAL_CRYPTO_NAME				N			external_crypto_name	READ ONLY
USBKEY_FLAG	0	0	1	N	0	0	global_usbkey_flag	READ ONLY
PAGE_ENC_SLICE_SIZE	4096	0	4096	N	4096	0	page_enc_slice_size	READ ONLY
DB_BLOCK_ENC_ID	2049	0	4294967294	N	2049	2049	db_block_enc_id	READ ONLY
BLANK_PAD_MODE	1	0	1	Y	1	0	blank_pad_mode	READ ONLY
GLOBAL_CHARSET	1	0	2	N	1	0	global_charset	READ ONLY
GLOBAL_BACKSLASH_ESCAPE	0	0	4294967294	N	0	0	global_backslash_escape	READ ONLY
GLOBAL_LOG_PAGE_SIZE	512	0	4294967294	N	512	0	global_log_page_size	READ ONLY
GLOBAL_SVR_NO_CONSOLE	1	0	4294967294	N	1	0	global_svr_no_console	READ ONLY
GLOBAL_EXTENT_SIZE	16	0	4294967294	N	16	0	global_extent_size	READ ONLY
GLOBAL_CPU_N	8	0	4294967294	N	8	0	global_cpu_n	READ ONLY
ENABLE_FAST_UPDATE	0	0	1	N	0	0	ENABLE_FAST_UPDATE	READ ONLY
FUPD_COL_LIMIT	32	1	10000	N	32	32	FUPD_COL_LIMIT	READ ONLY
TIME_ZONE	480	-780	780	N	480	0	TIME_ZONE	READ ONLY
LENGTH_IN_CHAR	1	0	1	Y	1	0	Column max length in CHAR or BYTE, 0: in BYTE, 1: in CHAR	READ ONLY
USE_NEW_HASH	1	0	1	Y	1	1	whether use new hash algorithm, 0: no, 1: yes	READ ONLY
IDLE_MEM_THRESHOLD	50	10	6000	N	50	50	Available Memory Warning Threshold Value	SYS
IDLE_DISK_THRESHOLD	1000	50	50000	N	1000	1000	Available Space Warning Threshold Value	SYS
IDLE_SESS_THRESHOLD	5	1	10	N	5	5	Available Session Warning Threshold Value	SYS
ENABLE_PRISVC	0	0	1	N	0	0	Whether to enable priority service	IN FILE
DSC_SEQNO	0	0	15	N	0	0	Node Number Of Dameng Share Cluster	READ ONLY
DSC_NODE	1	2	16	N	1	1	dsc_node	READ ONLY
DSC_MASTER_FLAG	1	0	1	N	1	0	dsc_master_flag	READ ONLY
RAC_N_CTLS	10000	10000	4294967294	N	10000	10000	Number of LBS/GBS ctls	IN FILE
DSC_N_CTLS	10000	10000	4294967294	N	10000	10000	Number of LBS/GBS ctls	IN FILE
RAC_N_POOLS	2	2	1024	N	2	2	Number of LBS/GBS pools	IN FILE
DSC_N_POOLS	2	2	1024	N	2	2	Number of LBS/GBS pools	IN FILE
DSC_N_OK_EP	1	0	16	N	1	1	Number of ok EP	IN FILE
RAC_USE_SBT	1	0	1	N	1	1	Use size balanced tree	IN FILE
DSC_USE_SBT	1	0	1	N	1	1	Use size balanced tree	IN FILE
DCR_PATH				N			Path of dcr disk	IN FILE
RAC_TRX_CMT_LSN_SYNC	3	0	3600	N	3	3	Whether to adjust lsn when trx commit	SYS
DSC_TRX_CMT_LSN_SYNC	3	0	3600	N	3	3	Whether to adjust lsn when trx commit	SYS
RAC_ENABLE_MONITOR	1	0	1	N	1	1	Whether to monitor request time	SYS
DSC_ENABLE_MONITOR	1	0	1	N	1	1	Whether to monitor request time	SYS
RAC_GBS_REVOKE_OPT	1	0	1	N	1	1	Whether to optimize GBS revoke	IN FILE
DSC_GBS_REVOKE_OPT	1	0	1	N	1	1	Whether to optimize GBS revoke	IN FILE
DSC_HALT_SYNC	0	0	1	N	0	0	Whether to halt other ep when resid_slot_wait overtime	IN FILE
DSC_TRX_VIEW_SYNC	0	0	1	N	0	0	Whether to wait response after broadcast trx view to other ep	IN FILE
MASTER_STARTUP_STATUS	1	0	4294967294	N	1	1	Startup status of Control Node	IN FILE
DSC_REMOTE_READ_MODE	1	0	2	N	1	1	PAGE remote read optimize mode	READ ONLY
DSC_FILE_INIT_ASYNC	1	0	1	N	1	1	DSC file init async flag	READ ONLY
DSC_TRX_CMT_OPT	0	0	1	N	0	0	Whether to wait rlog file flush when trx commit in DSC	READ ONLY
DSC_RESERVE_PERCENT	0.080000	0	10	N	0.080000	0.080000	Start ctl reserve percent	SYS
HA_OTHER_INST_IP				N			HA instance check IP	READ ONLY
HA_OTHER_INST_PORT	65534	1024	65534	N	65534	65534	HA instance check port	READ ONLY
HA_INST_CHECK_IP				N			HA instance check IP	READ ONLY
HA_INST_CHECK_PORT	65534	1024	65534	N	65534	65534	HA instance check port	READ ONLY
PWR_FLUSH_PAGES	1000	0	4294967294	N	1000	1000	Make special PWR rrec when n pages flushed	SYS
SYSDBA_PWD_LOCKED	0	0	1	N	0	0	SYSDBA password locked	READ ONLY
REDO_UNTIL_LSN				N			redo until lsn	READ ONLY
IGNORE_FILE_SYS_CHECK	1	0	1	N	1	1	ignore file sys check while startup	IN FILE
FILE_SCAN_PERCENT	100.000000	0	100	N	100.000000	100.000000	percent of data scanned when calculating file used space	SYS
STARTUP_CHECKPOINT	0	0	1	N	0	0	checkpoint immediately when startup after redo	IN FILE
DMKEY_POLICY	0	0	4294967294	N	0	0	dmkey_policy	SYS
CHECK_SVR_VERSION	1	0	1	N	1	1	Whether to check server version	READ ONLY
ID_RECYCLE_FLAG	0	0	1	N	0	0	Enable ID recycle	READ ONLY
BAK_USE_AP	1	1	2	N	1	1	backup use assistant plus-in, 0:use sub process; 1:use AP; 2:not use AP. default 1.	SYS
ENABLE_VERTICAL_TABLE	0	0	1	N	0	0	enable vertical table	SYS
ENABLE_DBLINK_TO_INV	0	0	1	N	0	0	Whether to convert correlated subquery which has dblink to temporary function	SESSION
ENABLE_BLOB_CMP_FLAG	0	0	1	N	0	0	Whether BLOB/TEXT types are allowed to be compared	SESSION
ENABLE_CREATE_BM_INDEX_FLAG	1	0	1	N	1	1	Allow bitmap index to be created	IN FILE
CVIEW_STAR_WITH_PREFIX	1	0	1	N	1	1	Whether append prefix for star item when create view	SESSION
ENABLE_ADJUST_NLI_COST	1	0	1	N	1	1	Whether adjust cost of nest loop inner join	SESSION
ENABLE_SEQ_REUSE	0	0	1	N	0	0	Whether allow reuse sequence expressions	SESSION

对象统计[上一项]

● 业务用户数据库对象统计

owner	object_type	cnt
LHR	SCH	1
LHR1	SCH	1
SYSJOB	SCH	1
SYSREP	SCH	1
SYSJOB	VIEW	3
SYSJOB	PACKAGE	2
SYSJOB	PACKAGE BODY	2
SYSJOB	TRIGGER	1
SYSJOB	TABLE	11
SYSREP	TABLE	7
SYSJOB	CONSTRAINT	13
SYSREP	INDEX	7
SYSREP	CONSTRAINT	6
SYSJOB	INDEX	13

● 最大的表top10

owner	segment_name	tablespace_name	size_mb	num_rows
SYS	WRH$_SQL_STAT_HISTORY	SYSAUX	472
SYS	WRH$_DMSQL_EXEC_TIME	SYSAUX	407
SYS	WRH$_LARGE_MEM_SQLS	SYSAUX	126
SYSDBA	TEST_LARGE	MAIN	107	708701
SYS	WRH$_SQLTEXT_TMP	SYSAUX	104
SYS	WRH$_SQLTEXT	SYSAUX	78
SYS	INDEX_DMSQL_EXEC_TIME	SYSAUX	68
SYS	WRH$_DM_INI	SYSAUX	41
SYS	WRH$_SESSION_WAIT_HISTORY	SYSAUX	27
SYS	INDEX_SQL_STAT_HISTORY	SYSAUX	26

● 行数最多的表top10

owner	table_name	tablespace_name	status	num_rows	size_mb
SYSDBA	TEST_LARGE	MAIN	VALID	708701	107
SYSDBA	DMINSPECTION_OPTION	MAIN	VALID	50	1

● 高水位的表

OWNER	TABLE_NAME	USED_MB	ALL_MB	USED_PER

● 高水位的索引

INDEX_SPACE	OWNER	TABLE_NAME	INDEX_NAME	USED_MB	ALL_MB	USED_PER

● 用户、索引和表TOP

USER_SPACE	USERNAME	TABLE_NAME	INDEX_NAME	USED_MB
USER_SPACE	SYSDBA			122
USER_SPACE	SYS			1321
USER_SPACE	SYSREP			3
USER_SPACE	LHR1			0
USER_SPACE	LHR			0
USER_SPACE	SYSSSO			0
USER_SPACE	SYSAUDITOR			0
TABLE_SPACE	SYS	WRH$_SQL_STAT_HISTORY		472
TABLE_SPACE	SYS	WRH$_DMSQL_EXEC_TIME		407
TABLE_SPACE	SYS	WRH$_LARGE_MEM_SQLS		126
TABLE_SPACE	SYSDBA	TEST_LARGE		107
TABLE_SPACE	SYS	WRH$_SQLTEXT_TMP		104
TABLE_SPACE	SYS	WRH$_SQLTEXT		78
TABLE_SPACE	SYS	WRH$_DM_INI		41
TABLE_SPACE	SYS	WRH$_SESSION_WAIT_HISTORY		27
TABLE_SPACE	SYS	WRH$_CKPT_HISTORY		12
TABLE_SPACE	SYS	WRH$_SYSSTAT		7
TABLE_SPACE	SYS	WRH$_LOCK		6
TABLE_SPACE	SYS	SYSTEXTS		5
TABLE_SPACE	SYS	WRH$_MEM_POOL		4
TABLE_SPACE	SYS	WRH$_SESSION_HISTORY		3
TABLE_SPACE	SYS	SYSOBJECTS		2
TABLE_SPACE	SYS	AQ$_QUEUES		2
TABLE_SPACE	SYS	WRH$_MTAB_USED_HISTORY		2
TABLE_SPACE	SYS	WRH$_SQL_HISTORY		2
TABLE_SPACE	SYS	SYSCOLUMNS		1
TABLE_SPACE	SYS	SYSCONS		1
INDEX_SPACE	SYS	WRH$_SQL_STAT_HISTORY	INDEX33555471	446
INDEX_SPACE	SYS	WRH$_DMSQL_EXEC_TIME	INDEX33555474	338
INDEX_SPACE	SYS	WRH$_LARGE_MEM_SQLS	INDEX33555473	126
INDEX_SPACE	SYSDBA	TEST_LARGE	INDEX33555510	107
INDEX_SPACE	SYS	WRH$_DMSQL_EXEC_TIME	INDEX_DMSQL_EXEC_TIME	68
INDEX_SPACE	SYS	WRH$_DM_INI	INDEX33555469	41
INDEX_SPACE	SYS	WRH$_SQLTEXT_TMP	INDEX33555490	34
INDEX_SPACE	SYS	WRH$_SQLTEXT	INDEX33555489	33
INDEX_SPACE	SYS	WRH$_SQL_STAT_HISTORY	INDEX_SQL_STAT_HISTORY	26
INDEX_SPACE	SYS	WRH$_SESSION_WAIT_HISTORY	INDEX33555492	15
INDEX_SPACE	SYS	WRH$_SESSION_WAIT_HISTORY	INDEX_SESSION_WAIT_HISTORY	12
INDEX_SPACE	SYS	WRH$_CKPT_HISTORY	INDEX33555461	12
INDEX_SPACE	SYS	WRH$_SYSSTAT	INDEX33555455	7
INDEX_SPACE	SYS	WRH$_SQLTEXT_TMP	INDEX_SQLTEXT_TMP	6
INDEX_SPACE	SYS	WRH$_LOCK	INDEX33555477	6
INDEX_SPACE	SYS	WRH$_SQLTEXT	INDEX_SQLTEXT	4
INDEX_SPACE	SYS	WRH$_MEM_POOL	INDEX33555476	4
INDEX_SPACE	SYS	WRH$_SESSION_HISTORY	INDEX33555478	3
INDEX_SPACE	SYS	WRH$_MTAB_USED_HISTORY	INDEX33555463	2
INDEX_SPACE	SYS	WRH$_SQL_HISTORY	INDEX_SQL_HISTORY	1