행위

"표 샘플"의 두 판 사이의 차이

DB CAFE

126번째 줄: 126번째 줄:
 
  Def. = MANUAL
 
  Def. = MANUAL
 
|-  
 
|-  
|parallel_execution_message_size||- message buffer size for parallel execution if PARALLEL_AUTOMATIC_TUNING is
+
 
set to false, then 2148bytes
 
  if PARALLEL_AUTOMATIC_TUNING is
 
set to true, then 4096 bytes
 
||16384 유지
 
Def. = 16384 (OSVersion Dependent)
 
|-
 
|parallel_force_local||force single instance execution||TRUE 설정
 
Def. = FALSE
 
|-
 
|parallel_io_cap_enabled||enable capping DOP by IO bandwidth||설정하지 않음
 
Def. = FALSE
 
  PARALLEL_DEGREE_LIMIT로 대체
 
|- 
 
|parallel_max_servers|| maximum parallel query servers per instanc-||CPU_COUNT를 감안하여 설정
 
|-
 
|parallel_min_percent|| minimum percent of threads required for parallel query||설정하지 않음
 
  Def. = 0 (%)
 
|-
 
|parallel_min_time_threshold||threshold above which a plan is a candidate for parallelization (in seconds)
 
AUTO
 
integer||설정하지 않음
 
Def. = AUTO (30 seconds)
 
  PARALLEL_DEGREE_POLICY가 AUTO 또는 LIMITED인 경우에 한함
 
 
|-
 
|parallel_min_servers||minimum parallel query servers per instanc-||Def. = 0 유지
 
D 0보다 큰 값을 설정하는 경우 Large Pool에 대해 ORA-4031 발생 빈도수가 증가할 수 있음
 
|-
 
|parallel_server_instances||number of instances to use for sizing OPS SGA structures||설정하지 않음
 
|-
 
  
 
|}
 
|}

2023년 9월 6일 (수) 00:03 판

thumb_up 추천메뉴 바로가기


Shopping List
Bread & Butter Pie Buns Danish Croissant
Cheese Ice cream Butter Yogurt

https://www.tablesgenerator.com/mediawiki_tables#

11 22 33
33
44 55 66
66 77 88


Type Code Type Description Acts On Level
C Check on a table Column
O Read Only on a view Object
P Primary Key Object
R Referential AKA Foreign Key Column
U Unique Key Column
V Check Option on a view Object
  • 표2
1 2 3 4 5
1 1 1 1 1
2 2 2 222 2
vㅍㅍ vㅍㅍ vㅍ
  • 표3
Food complements
Orange Apple
Bread Pie
Butter Ice cream


Parameter Description 비고
parallel_adaptive_multi_user enable adaptive setting of degree for multiple user streams 설정하지 않음
parallel_automatic_tuning enable intelligent defaults for parallel execution parameters 설정하지 않음
Def. = FALSE
Deprecated Parameter in 11g
parallel_degree_limit limit placed on degree of parallelism
CPU
IO
integer||설정하지 않음 (자동 설정)
Def. = CPU 
parallel_degree_policy policy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO)
MANUAL
LIMITED
AUTO	
설정하지 않음
Def. = MANUAL