행위

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

DB CAFE
82번째 줄: 82번째 줄:
 
|Butter
 
|Butter
 
|Ice cream  
 
|Ice cream  
 +
|}
 +
 +
 +
{| class="wikitable" style="color:green; background-color:#ffffcc;" cellpadding="5" border="1"
 +
|-
 +
! 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
 +
|-
 +
|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||설정하지 않음
 +
|-
 +
|parallel_servers_target||instance target in terms of number of parallel servers||설정하지 않음
 +
Def. = 4 * CPU_COUNT *
 +
PARALLEL_THREADS_PER_CPU *
 +
ACTIVE_INSTANCE_COUNT
 +
  PARALLEL_DEGREE_POLICY가
 +
AUTO인 경우에 한함
 +
PARALLEL_MAX_SERVERS보다
 +
작게 설정해야 한다.
 +
|-
 +
|parallel_threads_per_cpu number of parallel execution threads per CPU||설정하지 않음 (자동 설정)
 +
D  Def. = OS Dependent (usually 2)
 
|}
 
|}

2023년 9월 5일 (화) 23:53 판

thumb_up 추천메뉴 바로가기

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


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
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 설정하지 않음
parallel_servers_target instance target in terms of number of parallel servers 설정하지 않음

Def. = 4 * CPU_COUNT * PARALLEL_THREADS_PER_CPU * ACTIVE_INSTANCE_COUNT 

 PARALLEL_DEGREE_POLICY가

AUTO인 경우에 한함 PARALLEL_MAX_SERVERS보다 작게 설정해야 한다.

parallel_threads_per_cpu number of parallel execution threads per CPU 설정하지 않음 (자동 설정)

D Def. = OS Dependent (usually 2)

원본 주소 "http://dbcafe.co.kr/wiki/index.php?title=표_샘플&oldid=9592"