행위

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

DB CAFE
 
(같은 사용자의 중간 판 14개는 보이지 않습니다)
1번째 줄: 1번째 줄:
−
{| class="wikitable"
+
{| class="wikitable sortable" border="1" bordercolor="#ffffff"
 +
|+ Sortable table
 +
|-
 +
! scope="col" | Alphabetic
 +
! scope="col" | Numeric
 +
! scope="col" | Date
 +
! scope="col" class="unsortable" | Unsortable
 +
|-
 +
| d || 20 || 2008-11-24 || This
 +
|-
 +
| b || 8 || 2004-03-01 || column
 +
|-
 +
| a || 6 || 1979-07-23 || cannot
 +
|-
 +
| c || 4 || 1492-12-08 || be
 +
|-
 +
| e || 0 || 1601-08-13 || sorted.
 +
|}
 +
 
 +
{| class="wikitable" border="1"
 +
|-
 +
|<!--col1-->[[File:Liberty-statue-with-manhattan.jpg|199x95px]]
 +
|<!--col2-->[[File:New-York-Jan2005.jpg|199x95px]]
 +
|<!--col3-->[[File:Gold star on blue.gif|199x95px]]
 +
|<!--col4-->[[File:Worms 01.jpg|100x95px]]<!--smaller-->
 +
|-
 +
|<!--col1-->Statue of Liberty
 +
|<!--col2-->New York City
 +
|<!--col3-->Star on blue
 +
|<!--col4-->Bridge to Worms
 +
|}<!--end wikitable-->
 +
 
 +
{| summary="Artistic renderings of Germania became more triumphant and monumental."
 +
| [[File:Philipp Veit 008.jpg|thumb|upright|alt=Robed woman, seated, with sword on her lap|Philipp Veit, ''Germania'', 1834–36]]
 +
| [[File:Image Germania (painting).jpg|thumb|upright|alt=Robed woman, standing, holding a sword|Philipp Veit, ''Germania'', 1848]]
 +
| [[File:Niederwald memorial 2.JPG|thumb|upright|alt=Monument of robed woman, standing, holding a crown in one hand and a partly sheathed sword in another|Johannes Schilling, ''Germania'', 1871–83]]
 +
|}
 +
 
 +
 
 +
{| class="wikitable"  bordercolor="#ffffff"  
 
!colspan="6"|Shopping List
 
!colspan="6"|Shopping List
 
|-
 
|-
13번째 줄: 52번째 줄:
 
|Yogurt
 
|Yogurt
 
|}
 
|}
 +
https://www.tablesgenerator.com/mediawiki_tables#
  
−
 
+
{| class="wikitable" style="text-align:center; bordercolor='#ffffff' "
−
{| border="2" bordercolor="#ffffff" cellpadding="2" cellspacing="0" width="90%"
+
|- style="font-size:14px; font-family:'Arial Black', Gadget, sans-serif !important; background-color:#c0c0c0; color:#ffffff;"
 +
! 11
 +
! 22
 +
! 33
 +
|- style="font-size:12px; font-family:'Arial Black', Gadget, sans-serif !important; background-color:#efefef;"
 +
| colspan="3" | 33
 +
|- style="text-align:left;"
 +
| 44
 +
| 55
 +
| 66
 +
|- style="font-size:12px; font-family:'Arial Black', Gadget, sans-serif !important; background-color:#efefef;"
 +
| 66
 +
| 77
 +
| 88
 +
|}
 +
{| border="1" cellpadding="5" cellspacing="0" bordercolor="#ffffff"
 +
|-
 +
| Column 1 || Column 2 || Column 3
 +
|-
 +
| rowspan="2" | A
 +
| colspan="2" style="text-align: center;" | B
 +
|-
 +
| C <!-- column 1 occupied by cell A -->
 +
| D
 +
|-
 +
| E
 +
| rowspan="2" colspan="2" style="text-align: center;" |F
 +
|-
 +
| G <!-- column 2+3 occupied by cell F -->
 +
|-
 +
| colspan="3" style="text-align: center;" | H
 +
|}
 +
=== 표 1 ===
 +
{| border="5" bordercolor="#ffffff" cellpadding="2" cellspacing="0" width="90%"
 
|-  border="2" bordercolor="#ffffff" cellpadding="2" cellspacing="0" width="90%"
 
|-  border="2" bordercolor="#ffffff" cellpadding="2" cellspacing="0" width="90%"
 
| align="center" | <b><font face="Arial" size="2">Type Code</font></b>
 
| align="center" | <b><font face="Arial" size="2">Type Code</font></b>
45번째 줄: 118번째 줄:
 
| align="center" | <font face="Arial" size="2">Object</font>
 
| align="center" | <font face="Arial" size="2">Object</font>
 
|}
 
|}
−
* 표2  
+
=== 표2 ===
 
{| border="1" bordercolor="#123123" cellpadding="2" cellspacing="0" width="90%"
 
{| border="1" bordercolor="#123123" cellpadding="2" cellspacing="0" width="90%"
  
69번째 줄: 142번째 줄:
 
|}
 
|}
  
−
* 표3
+
=== 표3===
  
 
{| border="1" cellpadding="5" cellspacing="0"
 
{| border="1" cellpadding="5" cellspacing="0"
85번째 줄: 158번째 줄:
  
  
−
{| class="wikitable" style="color:green; background-color:#ffffcc;" cellpadding="5" border="1"
+
{| class="wikitable" style="color:green; background-color:#ffffcc;" cellpadding="5" border="1" bordercolor="#ffffff"
 
|-
 
|-
 
! Parameter !! Description !! 비고
 
! Parameter !! Description !! 비고
108번째 줄: 181번째 줄:
 
  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||설정하지 않음
 
−
|-
 
−
|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)
 
 
|}
 
|}

2024년 6월 15일 (토) 23:49 기준 최신판

thumb_up 추천메뉴 바로가기

Sortable table
Alphabetic Numeric Date Unsortable
d 20 2008-11-24 This
b 8 2004-03-01 column
a 6 1979-07-23 cannot
c 4 1492-12-08 be
e 0 1601-08-13 sorted.
Liberty-statue-with-manhattan.jpg New-York-Jan2005.jpg Gold star on blue.gif Worms 01.jpg
Statue of Liberty New York City Star on blue Bridge to Worms
Robed woman, seated, with sword on her lap
Philipp Veit, Germania, 1834–36
Robed woman, standing, holding a sword
Philipp Veit, Germania, 1848
Monument of robed woman, standing, holding a crown in one hand and a partly sheathed sword in another
Johannes Schilling, Germania, 1871–83


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
Column 1 Column 2 Column 3
A B
C D
E F
G
H

1 표 1[편집]

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 표2[편집]

1 2 3 4 5
1 1 1 1 1
2 2 2 222 2
vㅍㅍ vㅍㅍ vㅍ

3 표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
원본 주소 "http://dbcafe.co.kr/wiki/index.php?title=표_샘플&oldid=11777"