"표 샘플"의 두 판 사이의 차이
DB CAFE
| 31번째 줄: | 31번째 줄: | ||
| 88 | | 88 | ||
|} | |} | ||
| − | + | <style type="text/css"> | |
| + | .tg {border-collapse:collapse;border-spacing:0;} | ||
| + | .tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px; | ||
| + | overflow:hidden;padding:10px 5px;word-break:normal;} | ||
| + | .tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px; | ||
| + | font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;} | ||
| + | .tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top} | ||
| + | .tg .tg-0pky{border-color:inherit;text-align:left;vertical-align:top} | ||
| + | </style> | ||
| + | <table class="tg"> | ||
| + | <thead> | ||
| + | <tr> | ||
| + | <th class="tg-c3ow">11</th> | ||
| + | <th class="tg-c3ow">22</th> | ||
| + | <th class="tg-c3ow">33</th> | ||
| + | </tr> | ||
| + | </thead> | ||
| + | <tbody> | ||
| + | <tr> | ||
| + | <td class="tg-c3ow">33</td> | ||
| + | <td class="tg-c3ow">44</td> | ||
| + | <td class="tg-c3ow">55</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td class="tg-0pky">44</td> | ||
| + | <td class="tg-0pky">55</td> | ||
| + | <td class="tg-0pky">66</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td class="tg-c3ow">66</td> | ||
| + | <td class="tg-c3ow">77</td> | ||
| + | <td class="tg-c3ow">88</td> | ||
| + | </tr> | ||
| + | </tbody> | ||
| + | </table> | ||
{| border="2" bordercolor="#ffffff" cellpadding="2" cellspacing="0" width="90%" | {| border="2" bordercolor="#ffffff" cellpadding="2" cellspacing="0" width="90%" | ||
2023년 9월 6일 (수) 00:02 판
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 |
<style type="text/css"> .tg {border-collapse:collapse;border-spacing:0;} .tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;
overflow:hidden;padding:10px 5px;word-break:normal;}
.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;
font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}
.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top} .tg .tg-0pky{border-color:inherit;text-align:left;vertical-align:top} </style>
<thead> </thead> <tbody> </tbody>| 11 | 22 | 33 |
|---|---|---|
| 33 | 44 | 55 |
| 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) |