표 샘플
DB CAFE
thumb_up 추천메뉴 바로가기
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
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
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) |