¸¸È·Î º¸´Â ¿À¶óŬ Æ©´×
- ÀúÀÚ(ÁÖ)¿¢¼À ÄÁ¼³Æú»ºÎ
- ÃâÆǻ翢¼À
- ÃâÆÇÀÏ2023-09-14
- µî·ÏÀÏ2023-11-23
- SNS°øÀ¯
- ÆÄÀÏÆ÷¸ËEPUB
- ÆÄÀÏÅ©±â37MB
- °ø±Þ»çºÏÅ¥ºê
-
Áö¿ø±â±â
PC
PHONE
TABLET
ÇÁ·Î±×·¥ ¼öµ¿¼³Ä¡
ÀüÀÚÃ¥ ÇÁ·Î±×·¥ ¼öµ¿¼³Ä¡ ¾È³»
¾ÆÀÌÆù, ¾ÆÀÌÆеå, ¾Èµå·ÎÀ̵åÆù, ÅÂºí¸´,
º¸À¯ 1, ´ëÃâ 0,
¿¹¾à 0, ´©Àû´ëÃâ 6, ´©Àû¿¹¾à 0
Ã¥¼Ò°³
¿¢¼ÀÀº OWI °ü·Ã ±â¼ú¼ÀûÀ» ÃâÆÇÇÏ°í °í°´»çÀÇ DB ¼º´É ÄÁ¼³Æÿ¡ OWI ¹æ¹ý·ÐÀ» Àû¿ëÇÏ¿© ²ÙÁØÈ÷ Áö½Ä°ú °æÇèÀ» ÃàÀûÇØ ¿Ô´Ù. ÀÌ·¯ÇÑ Áö½ÄÀ» ÀÚ»çÀÇ ½Ã½ºÅÛ ¼º´É ¸ð´ÏÅ͸µ ¼Ö·ç¼Ç¿¡ ¹Ý¿µÇÔÀ¸·Î½á ¿¢¼ÀÀÌ ±¹³»¿¡¼ OWI ¹æ¹ý·ÐÀ» °³Ã´ÇØ ¿Â ¼±±¸ÀÚ¶ó°íµµ ÀÚºÎÇÑ´Ù.À̹ø¿¡´Â ¿¢¼ÀÀÌ ¸¸È¸¦ ÅëÇؼ Oracle DBMSÀÇ OWI °³³ä°ú SQL Æ©´×À» ½±°Ô ¼³¸íÇØ º¸·Á°í ÇÑ´Ù. ¿©·¯ºÐÀ» À§ÇØ ¼º½ÇÈ÷ ÁغñÇØ ¿Â Áö½Ä±â¾÷ ¿¢¼ÀÀÇ ÄÁÅÙÃ÷¸¦ ¸¶À½²¯ Áñ°Ü Áֽñ⠹ٶõ´Ù. ÀúÈñ ¿¢¼ÀÀº ¾ÕÀ¸·Îµµ ÁÖ±âÀûÀ¸·Î ±â¼ú¼ÀûÀ» Ãâ°£Çؼ ¿À¶óŬ ¼º´É Áö½ÄÀ» °øÀ¯Çϴµ¥ ¾ÕÀå¼³ °ÍÀÌ´Ù.
ÀúÀÚ¼Ò°³
±×¸² : ±èÇý¸²13³âÂ÷ µðÀÚÀ̳ÊÀÌÀÚ ±Í¿©¿î µÎ µþ, ¼ÇÏ ¼ºóÀÌÀÇ ¾ö¸¶ÀÌ´Ù.
½Ã°¢µðÀÚÀÎÀ» Àü°øÇß°í ´Ù¾çÇÑ ¿µ¿ª¿¡¼ µðÀÚÀÎ È°µ¿À» ÇÏ°í ÀÖ´Ù.
2008³â ¡°¿À¶óŬ À̺¥Æ® Åõ¾î¡±¸¦ ù ½ÃÀÛÀ¸·Î ±â¼ú ¸¸È 5ÆíÀ» ±×·ÈÀ¸¸ç ÇöÀç
³×À̹ö À¥Å÷ ¡°ºò¾Øµ¥À̶󡱸¦ ¿¬Àç ÁßÀÌ´Ù.
¸ñÂ÷
[ ¾Æ½ºÅÍ¿Í ÇÔ²²ÇÏ´Â Oracle Event Tour ]I/O
1È db file sequential read 10
2È db file scattered read 14
3È direct path read 18
4È direct path write 26
5È direct path read temp 30
6È db file parallel read 34
7È db file parallel write 38
8È control file parallel write 42
9È read by other session 48
10È write complete waits 52
Library Cache
11È SQLÀÇ ÀÛ¼º 58
12È SQLÀÇ ÆÄ½Ì 60
13È child LCO »ý¼º 62
14È latch:library cache(Function call·Î ÀÎÇÑ ¼öÇà Ƚ¼ö Áõ°¡) 64
15È latch:cache buffers chains 68
16È latch:cache buffers lru chain 72
17È library cache pin 76
18È latch:shared pool(bind mismatch) 80
19È kksfbc child completion 84
20È cursor pin s wait on x 88
21È latch free(simulator lru latch) 92
Lock
22È enq: TX - row lock contention(µ¿ÀÏ Row º¯°æ¿¡ ÀÇÇÑ TX Enqueue) 96
23È enq:TX-index contention 104
24È enq:TX-allocate ITL entry 108
25È enq:TM-contention 112
26È enq:US-contention 116
27È enq:SQ-contention 120
28È enq:HW-contention 124
29È enq:ST-contention 128
30È enq:TC-contention 130
Redo Log
31È log buffer space 134
32È log file parallel write 138
33È log file switch completion 142
34È Log file sync 146
RAC
35È gc cr/current block 2 - way/3 - way 142
36È gc cr/current grant 2-way 166
37È gc cr/current multi block reques 172
38È gc buffer busy 178
39È gc current block busy(Redo Flush¿¡ ÀÇÇÑ Áö¿¬) 182
40È gc cr/current block congested 188
41È gc current split 194
42È DFS lock handle 198
43È gc cr failure 208
±âŸ
44È buffer busy waits(µ¿ÀÏ ºí·Ï º¯°æ¿¡ ÀÇÇÑ Data Block¿¡ ´ëÇÑ °æÇÕ) 212
45È free buffer waits 218
46È SQLnet more data from/to client 224
47È SGA allocation forcing component growth 228
[ Mr.Å¥ ]
1È SQL Tuning ÃÊÂ¥°¡ °í¼ö µÇ´Â ¹ý! 232
2È Oracle Dictionary View(DBA_HIST_) 234
3È Åë°è Á¤º¸°ü¸®°¡ Áß¿äÇØ! 236
4È À妽º Ä÷³ÀÇ µ¥ÀÌÅÍ Çü º¯È¯ 239
5È ¹èÄ¡ ÇÁ·Î±×·¥¿¡¼ Æ©´×´ë»ó SQL ÃßÃâÇϱâ 242
6È Table Full Scan Äõ¸® ÃßÃâÇϱâ 244
7È Table Full ScanÀÌ Ç×»ó ºñÈ¿ÈáÀûÀÎ °ÍÀº ¾Æ´Ï´Ù! 247
8È 10046 Trace vs. DBMS_XPLAN.DISPLAY_CURSOR 250
9È FunctionÀº ÃÖÁ¾ ÃßÃâ °á°ú¸¸Å¸¸ ¼öÇàÇÏÀÚ! 253
10È WithÀý µ¿ÀÛ¹æ½Ä ÀÌÇØÇϱâ 256
ºÎ·Ï
[ ¸Æ°¡À̵å(MaxGauge Guide) ]
1È Lock Tree¤Ó¸¶Àϸ®Áö¸¦ Àâ¾Æ¶ó! 262
2È Alert ±â´É¤Ó¹ã»õÁö ¸»¶õ ¸»¾ß~! 264
3È Daily Trend ±â´É¤Ó³»¸¾´ë·Î ºñ±³Çϱâ 266
4È Top SQL¤Ó±â´É Á¨Æ²¸Ç 268
5È Event Description ±â´É ±Ã±ÝÇØ¿ä? ±Ã±ÝÇϸé Ŭ¸¯! 270
6È RAC View ±â´É¤Óº»´Ù º»´Ù ´Ùº»´Ù 272
7È Table Space ±â´É¤Ó´Ã¸±±î ¸»±î? 274
8È SQL List±â´É¤Ó Àá±ñ! SQL ÇÊÅ͸µ ÇÏ°í °¡½Ç°Ô¿ä 276
9È Trend Comparison ±â´É¤Ó¿Ïº®ÇÑ ºñ±³ 278
10È Stat analysis ±â´É¤ÓÇÑÅ¥¿¡ ºÐ¼®Çϱâ 280
[ ÀÎÅ͹̳×ÀÌÅÍ(InterMax Guide) ]
1È I¡¯ll Be Back 284
2È GC ¸ð´ÏÅ͸µ 286
3È WAS-DB ¿¬°èºÐ¼® 288
4È Transaction Path View 290
5È Connection Pool Monitoring 292
6È Exception ºÐ¼® 294
7È JAVA Source Diff ±â´É 296
8È WAS Workload summary 298
ÇÑÁÙ ¼Æò
- º°Á¡4°³2024-07-12*01711** ¸¸È´Â Àç¹ÕÁö¸¸ ¿À¶óŬ Æ©´×¿¡ ´ëÇØ 1µµ ¸ð¸£¸é 1µµ ÀÌÇØ ¾È°¡´Â Ã¥