표 샘플
DB CAFE
thumb_up 추천메뉴 바로가기
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
| Shopping List | |||||
|---|---|---|---|---|---|
| Bread & Butter | Pie | Buns | Danish | Croissant | |
| Cheese | Ice cream | Butter | Yogurt | ||
| 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) |