disql sysdba/damengdameng@localhost:5236
E:\dmdbms\bin>disql /as sysdba
用法:CONN[ECT] <logon>
<logon> 为::= {<username>[/<password>] | /}[@<connect_identifier>][<option>] [<os_auth>]
<connect_identifier>为[<svc_name> | host[:port] | <unixsocket_file>]
HOST如果是IPv6的地址，需要用[]指明是IPv6地址,例如[fe80::1e6f:65ff:fed1:3724%6]
INET_TYPE如果是UNIXSOCKET类型，<connect_identifier>需要指明是unixsocket地址,例如:/data/sdb/DAMENG/foo.sock
<option> ::= #{<extend_option>=<value>[,<extend_option>=<value>]...}
<os_auth> ::= AS {SYSDBA|SYSSSO|SYSAUDITOR|USERS|AUTO}
<extend_option> <value>
MPP_TYPE GLOBAL/LOCAL
INET_TYPE UDP/TCP/IPC/RDMA/UNIXSOCKET
SSL_PATH <path_str>
SSL_PWD <pwd_str>
PROXY_CLIENT <user_str>
GWDSN <GATEWAY DSN>
UKEY_NAME <ukey_name_str>
UKEY_PIN <ukey_pin_str>
SHAKE_CRYPTO <shake_crypto_str>
USER_NEW_PWD <new_pwd>
version: 03134284094-20231109-208042-20067 Pack10
DISQL 用法1:disql -h|help 显示disql版本信息和帮助信息
DISQL 用法2:disql [ [<option>] [<logon> | {/NOLOG}] [<start>] ]
<option> 为: [-L] [-S]
-L 只尝试登录一次
-S 隐藏模式，隐藏<SQL>标识符
<logon> 为::= {<username>[/<password>] | /}[@<connect_identifier>][<option>] [<os_auth>]
<connect_identifier>为[<svc_name> | host[:port] | <unixsocket_file>]
HOST如果是IPv6的地址，需要用[]指明是IPv6地址,例如[fe80::1e6f:65ff:fed1:3724%6]
INET_TYPE如果是UNIXSOCKET类型，<connect_identifier>需要指明是unixsocket地址,例如:/data/sdb/DAMENG/foo.sock
<option> ::= #{<extend_option>=<value>[,<extend_option>=<value>]...}
<os_auth> ::= AS {SYSDBA|SYSSSO|SYSAUDITOR|USERS|AUTO}
<extend_option> <value>
MPP_TYPE GLOBAL/LOCAL
INET_TYPE UDP/TCP/IPC/RDMA/UNIXSOCKET
SSL_PATH <path_str>
SSL_PWD <pwd_str>
PROXY_CLIENT <user_str>
GWDSN <GATEWAY DSN>
UKEY_NAME <ukey_name_str>
UKEY_PIN <ukey_pin_str>
SHAKE_CRYPTO <shake_crypto_str>
USER_NEW_PWD <new_pwd>
<start> ::= <`sql脚本> | <direct cmd> | <direct sql> 运行disql脚本
/NOLOG 选项能在未登录DM服务器的情况下启动disql
<`sql脚本>::= `<filename>[<parameter> { <parameter>}...]"
<direct sql>::= -e "<SQL语句>[;<SQL语句>]"
<direct cmd>::= -c "<set 命令>"
E:\dmdbms\bin>disql sysdba/damengdameng@localhost:5236
服务器[localhost:5236]:处于普通打开状态
登录使用时间 : 14.883(ms)
disql V8
SQL> show parameter
行号 PARA_NAME PARA_VALUE
---------- ------------- -----------------------------
1 CTL_PATH E:\dmdbms\data\DAMENG\dm.ctl
2 CTL_BAK_PATH E:\dmdbms\data\DAMENG\ctl_bak
3 CTL_BAK_NUM 10
4 SYSTEM_PATH E:\dmdbms\data\DAMENG
5 CONFIG_PATH E:\dmdbms\data\DAMENG
6 TEMP_PATH E:\dmdbms\data\DAMENG
7 BAK_PATH E:\dmdbms\data\DAMENG\bak
8 AUD_PATH NULL
9 DFS_PATH $/DAMENG
10 INSTANCE_NAME DMSERVER
11 INSTANCE_ADDR NULL
行号 PARA_NAME PARA_VALUE
---------- ---------------------- ----------
12 MAX_OS_MEMORY 70
13 MEMORY_POOL 700
14 MEMORY_N_POOLS 2
15 MEMORY_TARGET 1000
16 MEMORY_EXTENT_SIZE 32
17 MEMORY_LEAK_CHECK 0
18 MEMORY_MAGIC_CHECK 1
19 HUGEPAGE_THRESHOLD 16
20 MEMORY_BAK_POOL 4
21 HUGE_MEMORY_PERCENTAGE 50
22 HUGE_BUFFER 80
行号 PARA_NAME PARA_VALUE
---------- ----------------- ----------
23 HUGE_BUFFER_POOLS 4
24 BUFFER 4000
25 BUFFER_POOLS 17
26 BUFFER_MODE 0
27 FAST_POOL_PAGES 3000
28 FAST_ROLL_PAGES 1000
29 KEEP 8
30 RECYCLE 440
31 RECYCLE_POOLS 5
32 ROLLSEG 1
33 ROLLSEG_POOLS 1
行号 PARA_NAME PARA_VALUE
---------- -------------------- ----------
34 BUFFER_FAST_RELEASE 1
35 MULTI_PAGE_GET_NUM 1
36 PRELOAD_SCAN_NUM 0
37 PRELOAD_EXTENT_NUM 0
38 MAX_BUFFER 4000
39 SORT_BUF_SIZE 2
40 SORT_BLK_SIZE 1
41 SORT_BUF_GLOBAL_SIZE 500
42 SORT_FLAG 0
43 HAGR_HASH_SIZE 100000
44 MAIL_BUF_SIZE 100
行号 PARA_NAME PARA_VALUE
---------- -------------------- ----------
45 MAIL_VPOOL_SIZE 128
46 MAL_LEAK_CHECK 0
47 HJ_BUF_GLOBAL_SIZE 688
48 HJ_BUF_SIZE 69
49 HJ_BLK_SIZE 2
50 HAGR_BUF_GLOBAL_SIZE 688
51 HAGR_BUF_SIZE 69
52 HAGR_BLK_SIZE 2
53 MTAB_MEM_SIZE 8
54 FTAB_MEM_SIZE 0
55 MMT_GLOBAL_SIZE 4000
行号 PARA_NAME PARA_VALUE
---------- ---------------- ----------
56 MMT_SIZE 0
57 MMT_FLAG 1
58 DICT_BUF_SIZE 50
59 HFS_CACHE_SIZE 160
60 VM_STACK_SIZE 256
61 VM_POOL_SIZE 64
62 VM_POOL_TARGET 16384
63 SESS_POOL_SIZE 64
64 SESS_POOL_TARGET 16384
65 RT_HEAP_TARGET 8192
66 VM_MEM_HEAP 0
行号 PARA_NAME PARA_VALUE
---------- ----------------------------- ----------
67 RFIL_RECV_BUF_SIZE 16
68 COLDATA_POOL_SIZE 0
69 HAGR_DISTINCT_HASH_TABLE_SIZE 10000
70 CNNTB_HASH_TABLE_SIZE 100
71 GLOBAL_RTREE_BUF_SIZE 100
72 SINGLE_RTREE_BUF_SIZE 10
73 SORT_OPT_SIZE 0
74 TSORT_OPT 1
75 DFS_BUF_FLUSH_OPT 0
76 BIND_PLN_PERCENT 30
77 WORKER_THREADS 8
行号 PARA_NAME PARA_VALUE
---------- ---------------------- ----------
78 TASK_THREADS 4
79 MAL_UTHR_FLAG 1
80 FAST_RW_LOCK 1
81 SPIN_TIME 4000
82 WORK_THRD_STACK_SIZE 8192
83 WORK_THRD_RESERVE_SIZE 256
84 WORKER_CPU_PERCENT 0
85 NESTED_C_STYLE_COMMENT 0
86 USE_PLN_POOL 1
87 DYN_SQL_CAN_CACHE 1
88 VPD_CAN_CACHE 0
行号 PARA_NAME PARA_VALUE
---------- ------------------------ ----------
89 RS_CAN_CACHE 0
90 RS_CACHE_TABLES NULL
91 RS_CACHE_MIN_TIME 0
92 RS_BDTA_FLAG 0
93 RS_BDTA_BUF_SIZE 32
94 RS_TUPLE_NUM_LIMIT 2000
95 RESULT_SET_LIMIT 10000
96 RESULT_SET_FOR_QUERY 0
97 SESSION_RESULT_SET_LIMIT 10000
98 BUILD_FORWARD_RS 0
99 MAX_OPT_N_TABLES 6
行号 PARA_NAME PARA_VALUE
---------- -------------------- ----------
100 MAX_N_GRP_PUSH_DOWN 5
101 CNNTB_MAX_LEVEL 20000
102 CTE_MAXRECURSION 100
103 CTE_OPT_FLAG 1
104 BATCH_PARAM_OPT 0
105 CLT_CONST_TO_PARAM 0
106 BUILD_HASH_BASE_COST 0
107 CPU_COST_FACTOR 9500
108 LIKE_OPT_FLAG 127
109 FILTER_PUSH_DOWN 2
110 USE_MCLCT 2
行号 PARA_NAME PARA_VALUE
---------- ---------------------- ----------
111 MPP_OP_JUMP 1
112 PHF_NTTS_OPT 1
113 MPP_MOTION_SYNC 200
114 USE_FTTS 0
115 INV_DETERMINISTIC_FLAG 0
116 MULTI_HASH_DIS_OPT 1
117 MPP_UPD_DEL_OPT 2
118 UPD_DEL_OPT 2
119 MPP_DML_FORCE_OPT 0
120 ENABLE_INVISIBLE_COL 1
121 ENABLE_INJECT_HINT 1
行号 PARA_NAME PARA_VALUE
---------- --------------------------- ----------
122 FETCH_PACKAGE_SIZE 512
123 UPD_QRY_LOCK_MODE 0
124 ENABLE_DIST_IN_SUBQUERY_OPT 0
125 MAX_OPT_N_OR_BEXPS 7
126 USE_HAGR_FLAG 0
127 DTABLE_PULLUP_FLAG 1
128 VIEW_PULLUP_FLAG 1
129 VIEW_PULLUP_MAX_TAB 7
130 STR_NULL_OPS_COMPATIBLE 0
131 GROUP_OPT_FLAG 60
132 FROM_OPT_FLAG 0
行号 PARA_NAME PARA_VALUE
---------- ---------------------------- ----------
133 HAGR_PARALLEL_OPT_FLAG 4
134 HAGR_DISTINCT_OPT_FLAG 2
135 REFED_EXISTS_OPT_FLAG 1
136 REFED_OPS_SUBQUERY_OPT_FLAG 1
137 HASH_PLL_OPT_FLAG 107
138 PARTIAL_JOIN_EVALUATION_FLAG 1
139 MOTION_OPT_FLAG 0
140 USE_FK_REMOVE_TABLES_FLAG 1
141 USE_FJ_REMOVE_TABLE_FLAG 1
142 OUTER_JOIN_INDEX_OPT_FLAG 0
143 SLCT_OPT_FLAG 383
行号 PARA_NAME PARA_VALUE
---------- --------------------------- ----------
144 SLCT_ERR_PROCESS_FLAG 0
145 MPP_HASH_LR_RATE 10
146 LPQ_HASH_LR_RATE 30
147 USE_HTAB 1
148 SEL_ITEM_HTAB_FLAG 0
149 OR_CVT_HTAB_FLAG 1
150 OP_SUBQ_CVT_IN_FLAG 1
151 ENHANCED_SUBQ_MERGING 3
152 CASE_WHEN_CVT_IFUN 9
153 OR_NBEXP_CVT_CASE_WHEN_FLAG 0
154 NONCONST_OR_CVT_IN_LST_FLAG 0
行号 PARA_NAME PARA_VALUE
---------- --------------------------------- ----------
155 OUTER_CVT_INNER_PULL_UP_COND_FLAG 11
156 AUTOTRACE_LEVEL 0
157 OPT_OR_FOR_HUGE_TABLE_FLAG 0
158 ORDER_BY_NULLS_FLAG 0
159 SUBQ_CVT_SPL_FLAG 1
160 ENABLE_RQ_TO_SPL 1
161 MULTI_IN_CVT_EXISTS 1
162 PRJT_REPLACE_NPAR 1
163 ENABLE_RQ_TO_INV 0
164 SUBQ_EXP_CVT_FLAG 193
165 USE_REFER_TAB_ONLY 0
行号 PARA_NAME PARA_VALUE
---------- ----------------------- ----------
166 MAX_PHC_BE_NUM 512
167 MAX_TABLES_IN_SELECT 100
168 REFED_SUBQ_CROSS_FLAG 1
169 IN_LIST_AS_JOIN_KEY 0
170 OUTER_JOIN_FLATING_FLAG 1
171 TOP_ORDER_OPT_FLAG 5
172 TOP_ORDER_ESTIMATE_CARD 300
173 PLACE_GROUP_BY_FLAG 0
174 SINGLE_HTAB_REMOVE_FLAG 1
175 TOP_DIS_HASH_FLAG 1
176 ENABLE_RQ_TO_NONREF_SPL 1
行号 PARA_NAME PARA_VALUE
---------- ------------------------------ ----------
177 ENABLE_CHOOSE_BY_ESTIMATE_FLAG 0
178 OPTIMIZER_MODE 1
179 NEW_MOTION 1
180 LDIS_NEW_FOLD_FUN 0
181 DYNAMIC_CALC_NODES 0
182 OPTIMIZER_MAX_PERM 7200
183 ENABLE_INDEX_FILTER 1
184 OPTIMIZER_DYNAMIC_SAMPLING 0
185 TABLE_STAT_FLAG 0
186 AUTO_STAT_OBJ 0
187 MONITOR_MODIFICATIONS 0
行号 PARA_NAME PARA_VALUE
---------- -------------------------- ----------
188 MON_CHECK_INTERVAL 3600
189 NONREFED_SUBQUERY_AS_CONST 1
190 HASH_CMP_OPT_FLAG 0
191 OUTER_OPT_NLO_FLAG 0
192 DISTINCT_USE_INDEX_SKIP 2
193 USE_INDEX_SKIP_SCAN 0
194 INDEX_SKIP_SCAN_RATE 0.002500
195 SPEED_SEMI_JOIN_PLAN 9
196 COMPLEX_VIEW_MERGING 2
197 HLSM_FLAG 1
198 DEL_HP_OPT_FLAG 0
行号 PARA_NAME PARA_VALUE
---------- --------------------- ----------
199 OPTIMIZER_OR_NBEXP 29
200 NPLN_OR_MAX_NODE 20
201 OPTIMIZER_IN_NBEXP 1
202 CNNTB_OPT_FLAG 193
203 ADAPTIVE_NPLN_FLAG 0
204 MULTI_UPD_OPT_FLAG 1
205 MULTI_UPD_MAX_COL_NUM 128
206 ENHANCE_BIND_PEEKING 0
207 PHC_BE_ARR_NUM 0
208 GSA_NUM 10
209 NBEXP_OPT_FLAG 7
行号 PARA_NAME PARA_VALUE
---------- ------------------------- ----------
210 HAGR_HASH_ALGORITHM_FLAG 0
211 DIST_HASH_ALGORITHM_FLAG 0
212 UNPIVOT_OPT_FLAG 0
213 INVOCATION_OPT_FLAG 119
214 VIEW_FILTER_MERGING 138
215 ENABLE_PARTITION_WISE_OPT 1
216 OPT_MEM_CHECK 0
217 ENABLE_JOIN_FACTORIZATION 1
218 QUERY_INFO_BITS 0
219 EXPLAIN_SHOW_FACTOR 1
220 ERROR_COMPATIBLE_FLAG 0
行号 PARA_NAME PARA_VALUE
---------- --------------------------- ----------
221 HI_RIGHT_ORDER_FLAG 0
222 HASH_JOIN_LOOP_TIMES 10
223 ENABLE_NEST_LOOP_JOIN_CACHE 0
224 ENABLE_TABLE_EXP_REF_FLAG 1
225 OPT_CVT_VAR_COST_FACTOR 1
226 OPT_MAX_ADAPTIVE_EXEC_TIMES 1000
227 OPERATION_NEW_MOTION 31
228 SPL_SHARE_FLAG 0
229 USE_MD_STAT 0
230 BEXP_CALC_ST_FLAG 128
231 AND_CVT_OR_BEXP_MAX_NUM 1024
行号 PARA_NAME PARA_VALUE
---------- -------------------- ----------
232 BIND_PARAM_OPT_FLAG 2
233 EXP_BALANCE_FLAG 0
234 VIEW_OPT_FLAG 1
235 DEPENDENCE_CHECK 1
236 SEL_RATE_EQU 0.025000
237 SEL_RATE_SINGLE 0.050000
238 HAVING_RATE_FACTOR 1
239 INTER_RATE_FACTOR 1
240 RET_NULL_RATE_FACTOR 100
241 NLIJ_AMPLIFY_FACTOR 4
242 CPU_SPEED 3145728
行号 PARA_NAME PARA_VALUE
---------- ----------------- -----------
243 N_RUNS 1
244 MEM_BANDWIDTH 3145728
245 LPQ_MOTION_FACTOR 58.000000
246 MPP_MOTION_FACTOR 100.000000
247 COST_RANK_FACTOR 1000.000000
248 BASE_SCAN_CPU 140000
249 BASE_SEEK_CPU 140000
250 BASE_LKUP_CPU 62000
251 BASE_NLIJ_CPU 16000
252 BASE_HI_CPU 2683000
253 BASE_MI_CPU 1000000
行号 PARA_NAME PARA_VALUE
---------- ------------- ----------
254 BASE_NL_CPU 1000000
255 BASE_FLT_CPU 140000
256 BASE_SORT_CPU 36000
257 SCAN_CPU 330
258 SEEK_CPU 400
259 LKUP_CPU 2500
260 NLIJ_CPU 200
261 HI_CPU 400
262 HI_SEARCH_CPU 200
263 MI_CPU 300
264 NL_CPU 200
行号 PARA_NAME PARA_VALUE
---------- ------------------ ----------
265 FLT_CPU 30
266 LARGE_SORT_CPU 40000
267 SMALL_SORT_CPU 200
268 MEM_INTENSE_DEGREE 0
269 JOIN_ST_OPT_FLAG 1
270 CKPT_RLOG_SIZE 128
271 CKPT_DIRTY_PAGES 0
272 CKPT_INTERVAL 180
273 CKPT_FLUSH_RATE 5.000000
274 CKPT_FLUSH_PAGES 1000
275 CKPT_WAIT_PAGES 1024
行号 PARA_NAME PARA_VALUE
---------- ------------------- ----------
276 FORCE_FLUSH_PAGES 8
277 DIRECT_IO 0
278 IO_THR_GROUPS 4
279 HIO_THR_GROUPS 2
280 FIL_CHECK_INTERVAL 0
281 FAST_EXTEND_WITH_DS 0
282 MAX_SESSIONS 1500
283 MAX_CONCURRENT_TRX 0
284 CONCURRENT_TRX_MODE 0
285 CONCURRENT_DELAY 16
286 TRX_VIEW_SIZE 512
行号 PARA_NAME PARA_VALUE
---------- ------------------------- ----------
287 TRX_VIEW_MODE 1
288 TRX_CMTARR_SIZE 10
289 MAX_SESSION_STATEMENT 20000
290 MAX_SESSION_MEMORY 0
291 MAX_CONCURRENT_OLAP_QUERY 0
292 BIG_TABLE_THRESHHOLD 1000
293 MAX_EP_SITES 64
294 PORT_NUM 5236
295 LISTEN_IP NULL
296 FAST_LOGIN 0
297 DDL_AUTO_COMMIT 1
行号 PARA_NAME PARA_VALUE
---------- --------------- ----------
298 DDL_TV_TRIGGER 0
299 COMPRESS_MODE 0
300 PK_WITH_CLUSTER 0
301 EXPR_N_LEVEL 200
302 N_PARSE_LEVEL 100
303 MAX_SQL_LEVEL 500
304 BDTA_SIZE 1000
305 OLAP_FLAG 2
306 JOIN_HASH_SIZE 500000
307 USE_DHASH_FLAG 0
308 ONE_GROUP_SIZE 32
行号 PARA_NAME PARA_VALUE
---------- ----------------------- ----------
309 HFILES_OPENED 256
310 FAST_COMMIT 0
311 ISO_IGNORE 0
312 TEMP_SIZE 1024
313 TEMP_SPACE_LIMIT 102400
314 FILE_TRACE 0
315 COMM_TRACE 0
316 ERROR_TRACE 0
317 CACHE_POOL_SIZE 200
318 PLN_DICT_HASH_THRESHOLD 20
319 STAT_COLLECT_SIZE 10000
行号 PARA_NAME PARA_VALUE
---------- --------------------------- ----------
320 STAT_ALL 0
321 PHC_MODE_ENFORCE 0
322 ENABLE_HASH_JOIN 1
323 ENABLE_INDEX_JOIN 1
324 ENABLE_MERGE_JOIN 1
325 MPP_INDEX_JOIN_OPT_FLAG 1
326 MPP_NLI_OPT_FLAG 1
327 MAX_PARALLEL_DEGREE 1
328 PARALLEL_POLICY 2
329 PARALLEL_THRD_NUM 10
330 PARALLEL_MODE_COMMON_DEGREE 1
行号 PARA_NAME PARA_VALUE
---------- --------------------------- ----------
331 PUSH_SUBQ 0
332 OPTIMIZER_AGGR_GROUPBY_ELIM 1
333 UPD_TAB_INFO 0
334 ENABLE_IN_VALUE_LIST_OPT 6
335 ENHANCED_BEXP_TRANS_GEN 3
336 ENABLE_DIST_VIEW_UPDATE 0
337 STAR_TRANSFORMATION_ENABLED 0
338 OPTIMIZER_VERSION 70100
339 MONITOR_INDEX_FLAG 0
340 AUTO_COMPILE_FLAG 1
341 RAISE_CASE_NOT_FOUND 0
行号 PARA_NAME PARA_VALUE
---------- ----------------------- ----------
342 PESUDO_TRXID_NAME TRXID
343 PESUDO_PHYROWID_NAME PHYROWID
344 FIRST_ROWS 100
345 LIST_TABLE 0
346 ENABLE_PAGE_CHECK 3
347 ENABLE_SPACELIMIT_CHECK 1
348 BUILD_VERTICAL_PK_BTREE 0
349 BDTA_PACKAGE_COMPRESS 0
350 HFINS_PARALLEL_FLAG 0
351 HFINS_MAX_THRD_NUM 100
352 LINK_CONN_KEEP_TIME 15
行号 PARA_NAME PARA_VALUE
---------- --------------------------------- ----------
353 DETERMIN_CACHE_SIZE 5
354 FAST_RELEASE_LOB_PAGE 0
355 NTYPE_MAX_OBJ_NUM 1000000
356 CTAB_SEL_WITH_CONS 0
357 HUGE_WITH_DELTA 1
358 HLDR_BUF_SIZE 8
359 HLDR_BUF_TOTAL_SIZE 4294967294
360 HLDR_REPAIR_FLAG 0
361 HLDR_FORCE_COLUMN_STORAGE 1
362 HLDR_FORCE_COLUMN_STORAGE_PERCENT 80
363 HLDR_HOLD_RATE 1.500000
行号 PARA_NAME PARA_VALUE
---------- -------------------- ----------
364 HLDR_MAX_RATE 2
365 HUGE_ACID 0
366 HUGE_STAT_MODE 2
367 HFS_CHECK_SUM 1
368 HBUF_DATA_MODE 0
369 HUGE_TABLE_SWITCH 0
370 DBLINK_OPT_VIEW 1
371 DBLINK_OPT_FLAG 509
372 ELOG_REPORT_LINK_SQL 0
373 DBLINK_COL_EXTEND 1
374 DBLINK_LOB_LEN 8
行号 PARA_NAME PARA_VALUE
---------- -------------------- ----------
375 FILL_COL_DESC_FLAG 0
376 BTR_SPLIT_MODE 1
377 TS_RESERVED_EXTENTS 64
378 TS_SAFE_FREE_EXTENTS 512
379 TS_MAX_ID 8192
380 TS_FIL_MAX_ID 255
381 DECIMAL_FIX_STORAGE 0
382 FORCE_RECLAIM 0
383 SAVEPOINT_LIMIT 512
384 SQL_SAFE_UPDATE_ROWS 0
385 ENABLE_HUGE_SECIND 1
行号 PARA_NAME PARA_VALUE
---------- ------------------------- ----------
386 TRXID_UNCOVERED 0
387 LOB_MAX_INROW_LEN 900
388 RS_PRE_FETCH 0
389 DFS_PAGE_FLUSH_VALIDATE 1
390 GEN_SQL_MEM_RECLAIM 1
391 TIMER_TRIG_CHECK_INTERVAL 60
392 DFS_HUGE_SUPPORT 1
393 INNER_INDEX_DDL_SHOW 1
394 HP_STAT_SAMPLE_COUNT 50
395 MAX_SEC_INDEX_SIZE 16384
396 LOAD_TABLE NULL
行号 PARA_NAME PARA_VALUE
---------- ------------------------ ----------
397 LOAD_HTABLE NULL
398 CLT_CACHE_TABLES NULL
399 RLOG_BUF_SIZE 1024
400 RLOG_POOL_SIZE 256
401 RLOG_PARALLEL_ENABLE 0
402 RLOG_GEN_FOR_HUGE 1
403 RLOG_IGNORE_TABLE_SET 1
404 RLOG_APPEND_LOGIC 0
405 RLOG_APPEND_SYSTAB_LOGIC 0
406 RLOG_CHECK_SPACE 1
407 RLOG_SAFE_SPACE 256
行号 PARA_NAME PARA_VALUE
---------- ----------------------- ----------
408 RLOG_RESERVE_THRESHOLD 0
409 RLOG_RESERVE_SIZE 32767
410 RLOG_SEND_APPLY_MON 64
411 LOG_BUF_SIZE 1024
412 LOG_POOL_SIZE 256
413 RLOG_COMPRESS_LEVEL 0
414 RLOG_ENC_CMPR_THREAD 4
415 RLOG_PKG_SEND_ECPR_ONLY 0
416 DFS_RLOG_SEND_POLICY 1
417 RLOG_HASH_NAME NULL
418 REDO_PWR_OPT 1
行号 PARA_NAME PARA_VALUE
---------- ---------------------- ----------
419 REDO_IGNORE_DB_VERSION 0
420 REDO_BUF_SIZE 64
421 REDOS_BUF_SIZE 1024
422 REDOS_MAX_DELAY 1800
423 REDOS_BUF_NUM 4096
424 REDOS_PRE_LOAD 0
425 REDOS_PARALLEL_NUM 1
426 REDOS_ENABLE_SELECT 1
427 ISOLATION_LEVEL 1
428 DDL_WAIT_TIME 10
429 BLDR_WAIT_TIME 10
行号 PARA_NAME PARA_VALUE
---------- --------------------------- ----------
430 MPP_WAIT_TIME 10
431 FAST_RELEASE_SLOCK 1
432 SESS_CHECK_INTERVAL 3
433 LOCK_TID_MODE 1
434 LOCK_TID_UPGRADE 0
435 NOWAIT_WHEN_UNIQUE_CONFLICT 0
436 UNDO_EXTENT_NUM 16
437 MAX_DE_TIMEOUT 10
438 TRX_RLOG_WAIT_MODE 0
439 TRANSACTIONS 75
440 MVCC_RETRY_TIMES 5
行号 PARA_NAME PARA_VALUE
---------- ---------------------- ----------
441 MVCC_PAGE_OPT 1
442 ENABLE_FLASHBACK 0
443 UNDO_RETENTION 90.000000
444 PARALLEL_PURGE_FLAG 1
445 PSEG_MGR_FLAG 0
446 PURGE_WAIT_TIME 500
447 PURGE_DEL_OPT 0
448 PSEG_PAGE_OPT 1
449 FAST_RELEASE_LOB_SLOCK 0
450 HASH_ACTIVE_TRX_VIEW 0
451 PSEG_RECV 3
行号 PARA_NAME PARA_VALUE
---------- ----------------------- ----------
452 ENABLE_IGNORE_PURGE_REC 2
453 ENABLE_TMP_TAB_ROLLBACK 1
454 ROLL_ON_ERR 0
455 XA_TRX_IDLE_TIME 60
456 XA_TRX_LIMIT 1024
457 LOB_MVCC 1
458 LOCK_DICT_OPT 2
459 TRX_DICT_LOCK_NUM 64
460 DEADLOCK_CHECK_INTERVAL 1000
461 PWD_POLICY 2
462 PWD_MIN_LEN 9
行号 PARA_NAME PARA_VALUE
---------- -------------------- ----------
463 ENABLE_ENCRYPT 0
464 CLIENT_UKEY 0
465 MIN_SSL_VERSION 771
466 ENABLE_UDP 0
467 UDP_TRACE_MODE 0
468 UDP_MAX_IDLE 15
469 UDP_BTU_COUNT 8
470 ENABLE_IPC 0
471 ENABLE_AUDIT 0
472 AUDIT_FILE_FULL_MODE 1
473 AUDIT_SPACE_LIMIT 8192
行号 PARA_NAME PARA_VALUE
---------- -------------------- ----------
474 AUDIT_MAX_FILE_SIZE 100
475 AUDIT_IP_STYLE 0
476 ENABLE_OBJ_REUSE 0
477 ENABLE_REMOTE_OSAUTH 0
478 ENABLE_LOCAL_OSAUTH 0
479 MSG_COMPRESS_TYPE 2
480 ENABLE_STRICT_CHECK 0
481 MAC_LABEL_OPTION 1
482 RESTRICT_DBA 0
483 LDAP_HOST NULL
484 AUTO_ENCRYPT 0
行号 PARA_NAME PARA_VALUE
---------- ---------------------------- ----------
485 COMM_ENCRYPT_NAME NULL
486 COMM_VALIDATE 1
487 MESSAGE_CHECK 0
488 STARTUP_TIMEOUT 5
489 ENABLE_EXTERNAL_CALL 0
490 EXTERNAL_JFUN_PORT 6363
491 EXTERNAL_AP_PORT 4236
492 ENABLE_PL_SYNONYM 0
493 ENABLE_DDL_ANY_PRIV 0
494 FORCE_CERTIFICATE_ENCRYPTION 0
495 SEC_PRIV_MODE 0
行号 PARA_NAME PARA_VALUE
---------- ------------------------------- ----------
496 REGEXP_MATCH_PATTERN 0
497 SHOW_LOGIN_FAIL_TIMES 0
498 DATA_VALIDATE 0
499 VM_STACK_VALIDATE 2
500 UNIX_SOCKET_PATHNAME NULL
501 BACKSLASH_ESCAPE 0
502 STR_LIKE_IGNORE_MATCH_END_SPACE 1
503 CLOB_LIKE_MAX_LEN 10240
504 EXCLUDE_DB_NAME NULL
505 MS_PARSE_PERMIT 0
506 COMPATIBLE_MODE 0
行号 PARA_NAME PARA_VALUE
---------- ---------------------- ----------
507 ORA_DATE_FMT 0
508 JSON_MODE 0
509 DATETIME_FMT_MODE 0
510 DOUBLE_MODE 0
511 CASE_COMPATIBLE_MODE 1
512 XA_COMPATIBLE_MODE 0
513 EXCLUDE_RESERVED_WORDS NULL
514 COUNT_64BIT 1
515 EXCLUDE_MS_DBO 0
516 CALC_AS_DECIMAL 0
517 DEC_CALC_MODE 0
行号 PARA_NAME PARA_VALUE
---------- --------------------- ----------
518 CMP_AS_DECIMAL 0
519 CAST_VARCHAR_MODE 1
520 PL_SQLCODE_COMPATIBLE 0
521 EXCLUDE_PKG_NAME 0
522 CHAR_TO_BLOB_DIRECT 0
523 BINARY_TO_LOB_FLAG 1
524 TIMESTAMP_WITH_PREC 0
525 LEGACY_SEQUENCE 0
526 DM6_TODATE_FMT 0
527 MILLISECOND_FMT 1
528 NLS_DATE_FORMAT NULL
行号 PARA_NAME PARA_VALUE
---------- --------------------------- ----------
529 NLS_TIME_FORMAT NULL
530 NLS_TIMESTAMP_FORMAT NULL
531 NLS_TIME_TZ_FORMAT NULL
532 NLS_TIMESTAMP_TZ_FORMAT NULL
533 EMPTY_STR_TO_NULL_LOB 1
534 PK_MAP_TO_DIS 0
535 MERGE_SRC_MULTI_ROWS_IGNORE 0
536 SYS_INDEX_MATCH_IGNORE 0
537 PROXY_PROTOCOL_MODE 0
538 SPACE_COMPARE_MODE 0
539 DATETIME_FAST_RESTRICT 1
行号 PARA_NAME PARA_VALUE
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
