[B! tuning] ogawastã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ogawast id:ogawast

tuningã«é–¢ã™ã‚‹ogawastã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ã€ vmstat ã€‘ ãƒ¡ãƒ¢ãƒªãƒ¼ã‚„CPUã®è² è·çŽ‡ã‚„ä½¿ç”¨çŠ¶æ³ã‚’è¡¨ç¤ºã™ã‚‹
æŒ‡å®šã—ãŸå˜ä½ã§å®¹é‡ã‚’è¡¨ç¤ºã™ã‚‹ã€‚kã¯1,000ï¼ŒKã¯1,024ï¼Œmã¯1,000,000ï¼ŒMã¯1,048,576ãƒã‚¤ãƒˆå˜ä½ã§è¡¨ç¤ºã™ã‚‹ vmstatã¯ï¼Œã‚·ã‚¹ãƒ†ãƒ å†…ã®æƒ…å ±ã‚’è¡¨ç¤ºã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã ã€‚ä¾‹ãˆã°ï¼Œä¸»ãƒ¡ãƒ¢ãƒªãƒ¼ã®ç©ºãå®¹é‡ã‚„CPUã®å‹•ä½œçŠ¶æ³ãªã©ã‚’è¡¨ç¤ºã™ã‚‹ã€‚ vmstatã‚³ãƒžãƒ³ãƒ‰ã‚’ãã®ã¾ã¾å®Ÿè¡Œã™ã‚‹ã¨ï¼Œç¾åœ¨ã®ãƒ—ãƒã‚»ã‚¹ï¼Œãƒ¡ãƒ¢ãƒªãƒ¼ï¼Œã‚¹ãƒ¯ãƒƒãƒ—ï¼Œãƒ‡ãƒã‚¤ã‚¹ï¼Œå‰²ã‚Šè¾¼ã¿ï¼ŒCPUã®æƒ…å ±ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ã¾ãŸï¼Œã€Œ-dã€ã‚„ã€Œ-pã€ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ä»˜ã‘ã‚‹ã¨ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚„ãƒ‡ã‚£ã‚¹ã‚¯ã¸ã®èªã¿æ›¸ãçŠ¶æ³ãªã©ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ã€Œ-fã€ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æŒ‡å®šã™ã‚‹ã¨ã‚·ã‚¹ãƒ†ãƒ ãŒèµ·å‹•ã—ã¦ã‹ã‚‰ã‚³ãƒžãƒ³ãƒ‰å®Ÿè¡Œæ™‚ã¾ã§ã®é–“ã«ï¼Œãƒ—ãƒã‚»ã‚¹ã‚’ä½œæˆã—ãŸå›žæ•°ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ vmstatã®å¾Œã«ç§’å˜ä½ã§æ™‚é–“é–“éš”ã‚’æŒ‡å®šã™ã‚‹ã¨ï¼ŒæŒ‡å®šã—ãŸæ™‚é–“ã”ã¨ã«ã‚·ã‚¹ãƒ†ãƒ ã®çŠ¶æ³ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ã¾ãŸï¼Œå›žæ•°ã‚’æŒ‡å®šã™ã‚‹ã¨ï¼ŒæŒ‡å®šã—ãŸå›žæ•°æƒ…å ±ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ å®¹é‡ã«ã¤ã„ã¦ã¯ã€Œ-Sã€ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§å˜ä½ã‚’æŒ‡å®šã§ãã‚‹ã€‚ã€Œ-S
ogawast 2009/08/23
command

tuning

vmstat
ãƒªãƒ³ã‚¯
Dan Manges
Dan Manges Building rwx. Former CTO of Braintree and Root. CB Insights Future of Fintech conference interview Jun 12, 2019 The Modular Monolith: Rails Architecture Jan 23, 2018 em ail â€¢ linkedin â€¢ twitter â€¢ medium â€¢ github
ogawast 2009/02/18
rails

performance

tuning

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ï¼ ITï¼š/procã«ã‚ˆã‚‹Linuxãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ï¼»å‰ç·¨ï¼½ï¼ˆ1/2ï¼‰
/procã«ã‚ˆã‚‹Linuxãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ï¼»å‰ç·¨ï¼½ ï½ž /procã§ç†è§£ã™ã‚‹OSã®çŠ¶æ…‹ ï½ž Linuxã®çŠ¶æ…‹ç¢ºèªã‚„æŒ™å‹•ã®å¤‰æ›´ã§é‡è¦ãªå½¹å‰²ã‚’æ‹…ã†ã®ãŒ/procãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã§ã‚ã‚‹ã€‚å‰ç·¨ã§ã¯/procã®æ¦‚å¿µã‚„/procã‚’åˆ©ç”¨ã—ãŸOSã®çŠ¶æ…‹ç¢ºèªæ–¹æ³•ã‚’ç†è§£ã—ã¦ã„ãŸã ããŸã„ã€‚ï¼ˆç·¨é›†å±€ï¼‰ é ç”° è€•å¹³ 2002/12/10 æœ¬ç¨¿ã§ã¯ã€/procãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã«ã‚ˆã‚‹ã‚«ãƒ¼ãƒãƒ«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ã‚«ãƒ¼ãƒãƒ«2.4.19ã‚’ãƒ™ãƒ¼ã‚¹ã«èª¬æ˜Žã—ã¦ã„ãã¾ã™ãŒã€ã‚«ãƒ¼ãƒãƒ«ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã£ã¦å†…å®¹ãŒç•°ãªã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€ãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚¿ãŒç‹¬è‡ªã®æ‹¡å¼µã‚’æ–½ã—ã¦ã„ã‚‹ã‚‚ã®ã‚‚ã‚ã‚Šã¾ã™ã€‚å¾“ã£ã¦ã€ã“ã‚Œã‹ã‚‰èª¬æ˜Žã™ã‚‹å†…å®¹ãŒã™ã¹ã¦å½“ã¦ã¯ã¾ã‚‹ã¨ã¯é™ã‚Šã¾ã›ã‚“ï¼ˆç«¯çš„ã«ã„ã†ã¨èª¬æ˜Žã®å¯¾è±¡ãŒå˜åœ¨ã—ãªã‹ã£ãŸã‚Šã€èª¬æ˜Žã•ã‚Œã¦ã„ãªã„æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã¦ã„ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ï¼‰ã€‚ /procãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã¨ã¯ /procã¯ã€Linuxã‚·ã‚¹ãƒ†ãƒ ã®/ï¼ˆãƒ«ãƒ¼ãƒˆï¼‰ã«ã€Œ
ogawast 2008/02/25
tuning
ãƒªãƒ³ã‚¯
ãƒ¦ãƒ¡ã®ãƒã‚«ãƒ©: ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã„ã†ã®ã‚‚éžå¸¸ã«é‡è¦ãªå•é¡Œã ã€‚é»’é”è¡“ã®ã‚ˆã†ãªã‹ã‚“ã˜ã‚‚ã—ãªãã‚‚ãªã„ãŒã€ãƒ¨ã‚¿è©±ã‚’ã„ã‚ã„ã‚æ›¸ã„ã¦ã¿ã‚‹ã€‚ æ€§èƒ½ã®å•é¡ŒãŒè¡¨é¢åŒ–ã—ãŸå ´åˆã€ã‚„ã¿ãã‚‚ã«ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ã„ã˜ãã‚Šã¾ã‚ã—ã¦å•é¡Œã‚’æ‚ªåŒ–ã•ã›ã¦ã—ã¾ã†å ´åˆãŒã‚ã‚‹ãŒã€ããƒ¼ã‚†ãƒ¼ã“ã¨ã¯é¿ã‘ãŸã„ã€‚ ä½•ãŒå•é¡Œãªã®ã‹ã€å®šé‡çš„ãªã‚´ãƒ¼ãƒ«ã‚’æ˜Žç¢ºåŒ–ã—ãªã„ã¨ã€å˜ãªã‚‹æ„Ÿè¦šè«–ã«ãªã£ã¦ã—ã¾ã£ã¦ä¸æ¯›ãªæ™‚é–“ã‚’ã¤ã„ã‚„ã™ã“ã¨ã«ãªã‚‹ã®ã§æ³¨æ„ãŒå¿…è¦ã§ã‚ã‚‹ã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®å‚è€ƒæ›¸ã¯ã„ã‚ã„ã‚ã‚ã‚‹ã¨æ€ã†ã®ã§é©å®œã¿ã¤ã‘ã ã—ã¦ã»ã—ã„ãŒå®šç•ªã®ã“ã‚Œã¯ã¨ã„ã†ã®ã¯ã€ã‚ã‚‹ã‚ˆã†ã§ã„ã¦ã‚ˆãã‚ã‹ã‚‰ãªã„ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã„ã†é¡Œæã§ã®æ›¸ç±ã¯ã„ã‚ã„ã‚ã‚ã‚‹ãŒã„ã‹ã‚“ã›ã‚“è£½å“ç‰¹æœ‰ã®Tipsã«ã‹ãŸã‚ˆã£ãŸã‚‚ã®ãŒå¤šãã¦ã‚ã¾ã‚Šæ±Žç”¨æ€§ãŒãªã‹ã£ãŸã‚Šã™ã‚‹ã€‚Oracleã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’å‹‰å¼·ã™ã‚‹ã¨ã„ã†ã®ã¯ãã‚Œã¯ãã‚Œã§å¿…è¦ãªã®ã ã‘ã©ã€ã‚ãŸã—ãŒç›®æŒ‡ã—ã¦ã„ã‚‹ã‚‚ã®ã¨ã¡ã‚‡ã£ã¨é•ã†ã€‚ ã“ã“ã§ã¯ä¸€èˆ¬çš„ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼
ogawast 2007/08/29
tuning
ãƒªãƒ³ã‚¯
Performance Tuning PostgreSQL
Introduction PostgreSQL is the most advanced and flexible Open Source SQL database today. With this power and flexibility comes a probl em. How do the PostgreSQL developers tune the default configuration for everyone? Unfortunately the answer is they can't. The probl em is that every database is not only different in its design, but also its requirements. Some systems are used to log mountains of da
ogawast 2007/07/07
postgres

tuning
ãƒªãƒ³ã‚¯
pgbenchã®å°Žå…¥pgbenchSQL -TECHSCORE-
2.1. pgbenchã¨ã¯ pgbenchã¨ã¯çŸ³äº•é”å¤«æ°ã«ã‚ˆã£ã¦ä½œæˆã•ã‚ŒãŸPostgreSQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆã‚’è¡Œã†ãŸã‚ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã€ PostgreSQL æœ¬ä½“ã¨ã¨ã‚‚ã«é…å¸ƒã•ã‚Œã¦ã„ã¾ã™ã€‚ ã‚µãƒ¼ãƒãƒ¼å´ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åŸºæœ¬çš„ãªãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã«ç”¨ã„ã‚‰ã‚Œã‚‹TPC-Bã‚’åŸºã«ä½œæˆã•ã‚Œã¦ãŠã‚Šã€ 1ç§’é–“ã«å®Ÿè¡Œã§ãã‚‹ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ•°ã§æ€§èƒ½ã‚’åˆ¤æ–ã—ã¾ã™ã€‚ ç‰¹å¾´ã¨ã—ã¦ã€ãƒžãƒ«ãƒãƒ¦ãƒ¼ã‚¶ãƒ¼ç’°å¢ƒã‚’ã‚·ãƒŸãƒ¥ãƒ¬ãƒ¼ãƒˆã™ã‚‹ã“ã¨ãŒã§ãã€å®¹æ˜“ã«åŒæ™‚æŽ¥ç¶šç’°å¢ƒã‚’ãƒ†ã‚¹ãƒˆã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã¾ãŸã€ç§»æ¤æ€§ãŒé«˜ãã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚ç°¡å˜ã§ã™ 2.2. ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« pgbenchã¯PostgreSQLã‚’è§£å‡ã—ã¦ä½œã‚‰ã‚ŒãŸãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªå†…ã®contrib/pgbenchã«å˜åœ¨ã—ã¾ã™ã€‚ ãã®ãŸã‚ã€æ”¹ã‚ã¦å…¥æ‰‹ã™ã‚‹å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ contrib/pgbenchã«ç§»å‹•ã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†è€…ï¼ˆã¾ãŸã¯ã‚¹ãƒ¼ãƒ‘ãƒ¼ãƒ¦ãƒ¼ã‚¶ãƒ¼ï¼‰ã®æ¨©é™ã§ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ãƒ»ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’ã™
ogawast 2007/05/29
tuning

postgres
ãƒªãƒ³ã‚¯
DSASé–‹ç™ºè€…ã®éƒ¨å±‹:5åˆ†ã§ã§ãã‚‹ã€MySQLã®ãƒ¡ãƒ¢ãƒªé–¢ä¿‚ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼
MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦éžå¸¸ã«é‡è¦ã¨ãªã‚‹ãƒ¡ãƒ¢ãƒª(ãƒãƒƒãƒ•ã‚¡)é–¢é€£ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã€ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆ DSASã®ã¨ã‚ã‚‹DBã‚µãƒ¼ãƒ(å®Ÿãƒ¡ãƒ¢ãƒª4GB)ã®å®Ÿéš›ã®è¨å®šå€¤ ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã¾ãŸã€å¿…è¦ãƒ¡ãƒ¢ãƒªã®ç·é‡ã®è¨ˆç®—ã‚„é™ç•Œå€¤ã‚’è¶Šãˆã¦ãªã„ã‹ãƒã‚§ãƒƒã‚¯ã—ã¦ãã‚Œã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚‚ç´¹ä»‹ã—ã¾ã™ã€‚ æ˜¯éžã€å‚è€ƒã«ã—ã¦ã¿ã¦ãã ã•ã„ï¼ ã¾ãšæœ€åˆã«æ³¨æ„ç‚¹ã‚’ã€‚ ãƒãƒƒãƒ•ã‚¡ã«ã¯2ã¤ã®ã‚¿ã‚¤ãƒ—ãŒã‚ã‚Šã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã¯mysqldå…¨ä½“ã§ãã®ãƒãƒƒãƒ•ã‚¡ãŒ1ã¤ã ã‘ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã€ ã“ã‚Œã«å¯¾ã—ã€ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã¯ã‚¹ãƒ¬ãƒƒãƒ‰(ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³)ã”ã¨ã«ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®éš›ã«ã¯ã‚°ãƒãƒ¼ãƒãƒ«/ã‚¹ãƒ¬ãƒƒãƒ‰ã®é•ã„ã‚’æ„è˜ã™ã‚‹ã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã€‚ ãªãœãªã‚‰ã€ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã«å¤šãã®ãƒ¡ãƒ¢ãƒªã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå¢—ãˆãŸã¨ãŸã‚“ã«ã‚¢ãƒƒã¨ã„ã†é–“ã«ãƒ¡ãƒ¢ãƒªä¸è¶³ã«ãªã£ã¦ã—ã¾ã†ã‹ã‚‰ã§ã™ã€‚ in
ogawast 2006/12/28
tuning

db
ãƒªãƒ³ã‚¯
3-6-2-2 æ£ã—ã„ç´¢å¼•ã®ä½¿ç”¨æ–¹æ³•
3-6-2-2 æ£ã—ã„ç´¢å¼•ã®ä½¿ç”¨æ–¹æ³• 3-6 SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€€âˆ’æœ€é©ãªSQLæ–‡ã®æ›¸ãæ–¹âˆ’ 9 April, 1998 Updatedã€€ã€€ PCDN OracleWG S.Yamazakiã€€ã€€ ã•ã¦ã€ã€Œæœ€é©ãªSQLæ–‡ã®æ›¸ãæ–¹ã€ã§è¿°ã¹ãŸã‚ˆã†ã«ã€ç´¢å¼•ã‚’ä½¿ç”¨ã™ã‚‹ã‹ã—ãªã„ã‹ã«ã‚ˆã‚Šã€ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã«å½±éŸ¿ã™ã‚‹ã“ã¨ã¯ãŠã‚ã‹ã‚Šã„ãŸã ã‘ãŸã¨æ€ã„ã¾ã™ã€‚ç´¢å¼•ãŒä½¿ç”¨ã•ã‚Œã‚‹ã‹ã©ã†ã‹ï¼Žï¼Žï¼Žã“ã‚Œã¯ã€ã©ã®ã‚ˆã†ãªæ¤œç´¢æ¡ä»¶ã‚’ã‚‚ã£ã¦ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã™ã‚‹ã‹ã«ã‚ˆã‚Šã¾ã™ã€‚ã“ã‚Œã‚’è§£æ±ºã™ã‚‹ãŸã‚ã«ã¯ã€ãã®æ¥å‹™ã®æ€§è³ªãªã‚Šã‚’æŠŠæ¡ã—ãªã‘ã‚Œã°ã€æ˜Žç¢ºãªç”ãˆãŒã§ã‚‹ã¨ã‚‚æ€ãˆã¾ã›ã‚“ã€‚ã“ã“ã§ã¯ã€ã‚ˆã‚Šæ˜Žç¢ºãªç”ãˆã‚’å°ŽããŸã‚ã®æŒ‡é‡ã‚’ç¤ºã›ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ ã¾ãŸã€Oracle7.3ä»¥é™ã‹ã‚‰ã®ç´¢å¼•ã«é–¢ã™ã‚‹æ–°æ©Ÿèƒ½ã‚‚ä½µã›ã¦ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚æ©Ÿä¼šãŒã‚ã‚Œã°ãŠè©¦ã—ãã ã•ã„ã€‚ ç´¢å¼•ã¨ã¯ ç´¢å¼•(INDEX)ã¨ã¯ã€å®Ÿè¡¨(TABLE)ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’
ogawast 2006/10/04
db

tuning
ãƒªãƒ³ã‚¯
3-6 ãƒ’ãƒ³ãƒˆã‚’ä½¿ç”¨ã™ã‚‹
30 March, 1998 Updatedã€€ã€€ PCDN OracleWG S.Yamazakiã€€ã€€ ã“ã“ã§ã¯ã€å®Ÿéš›ã©ã‚“ãªæ™‚ã«ãƒ’ãƒ³ãƒˆã‚’ä½¿ã†ã¹ããªã®ã‹ï¼Žï¼Žï¼ŽCBOã§ã¯ã€ãªã«ã‚‚æŒ‡ç¤ºãŒãªãã¦ã‚‚æœ€å°ã‚³ã‚¹ãƒˆã®ã‚¢ã‚¯ã‚»ã‚¹ãƒ‘ã‚¹ã‚’é¸æŠžã™ã‚‹ã¨è¨€ã„ã¾ã—ãŸã€‚ ã‘ã‚Œã©ã€ãã‚Œã¯ã€åŽ³å¯†ã«çµ±è¨ˆãŒæŽ¡ã‚‰ã‚Œã€ã‹ã¤ã€ç´¢å¼•ã®æ•°ã‚‚å¤šããªã„å ´åˆã§ã™ã€‚ã„ã‚ã„ã‚ã¨é‹ç”¨ã—ã¦ã„ãã†ã¡ã«ã€è‡ªåˆ†ã®æ€ã†ã‚ˆã†ãªã‚¢ã‚¯ã‚»ã‚¹ãƒ‘ã‚¹ã‚’é¸æŠžã—ã¦ãã‚Œãªã„æ™‚ãŒã‚ã‚‹ã§ã—ã‚‡ã†ã€‚ãã®ãŸã‚ã«ãƒ’ãƒ³ãƒˆã¯ã‚ã‚Šã¾ã™ã€‚ ãƒ’ãƒ³ãƒˆã¨ã¯ è³¢ã„CBOã‚‚ç´¢å¼•ã®æ•°ãŒãŸãã•ã‚“ã‚ã£ãŸã‚Šã€ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚°ã®çµ±è¨ˆè¡Œæ•°ã ã‘ã§ã¯ã€æœ€é©ãªã‚¢ã‚¯ã‚»ã‚¹ãƒ‘ã‚¹ã‚’é¸æŠžã—ã¦ãã‚Œãªã„å ´åˆã‚‚ã‚ã‚Šã¾ã™ã€‚ãƒ’ãƒ³ãƒˆã¯ã€ãã†ã—ãŸå ´åˆã«ã‚³ã‚¹ãƒˆãƒ™ãƒ¼ã‚¹ã®ç›®æ¨™ã‚’å¤‰æ›´(Oracleã«æŒ‡ç¤ºã‚’å‡ºã™)ã™ã‚‹ãŸã‚ã«ä½¿ç”¨ã—ã¾ã™ã€‚ ãŸã¨ãˆã°ã€OracleãŒã€Œind_Aã€ã¨ã„ã†ç´¢å¼•ã‚’ä½¿ç”¨ã—ãŸãƒ‘ã‚¹ã‚’é¸æŠžã—ãŸãŒã€æ€ã†ã‚ˆã†ãªå¿œç”æ™‚é–“ã‚’å¾—ã‚‰ã‚Œãªã„å ´åˆã€ã€Œ
ogawast 2006/10/04
Oracle

tuning
ãƒªãƒ³ã‚¯
1