[B! statspack] replicationã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

replication id:replication

statspackã«é–¢ã™ã‚‹replicationã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{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}}

ä¸€ç·’ã«ã¾ãªã¼ï¼ã€Œhiromi ã¨æ¥½ã—ã‚€Oracleãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼ã€ã€Vol.2 Statspackã‚’è¦‹ã¦ã¿ã‚ˆã†ã€‘ | æ ªå¼ä¼šç¤¾ã‚¯ãƒãƒŽã‚¹
ã“ã‚“ã«ã¡ã‚ãï½žã²ã•ã—ã¶ã‚Šã ãï½ž ã¾ãŸè¦‹ã«ãã¦ãã‚Œã¦ã‚ã‚ŠãŒã¨ã‰ï½žOracleå¥³åã®hiromiã§ã™ ã¿ã‚“ãªå…ƒæ°—ã ã£ãŸã‹ãªãï¼Ÿhiromiã¯å…ƒæ°—ãƒ¼ ã§ã‚‚æœ€è¿‘ã€ãŠå‹é”ã¨ã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ã™ã‚‹ã‚ˆã‚Šã‚‚Oracleã®ã‚µã‚¤ã‚¸ãƒ³ã‚°ã«ã¤ã„ã¦è€ƒãˆã‚‹æ–¹ãŒæ¥½ã—ããªã£ã¡ã‚ƒã£ã¦ã€ä»²ã®ã„ã„å‹é”ãŒã©ã‚“ã©ã‚“é›¢ã‚Œã¦ã„ã£ã¡ã‚ƒã†ã‚ˆãƒ¼ã£ã¦ã®ãŒä¸€ç•ªã®æ‚©ã¿ã€‚ ã§ã‚‚ã¾ã‚Oracleè§¦ã£ã¦ãŸã‚‰ãã‚“ãªã“ã¨ã™ã¹ã¦å¿˜ã‚Œã¡ã‚ƒã†ã‚“ã ã‘ã©ãã€‚ãµãµ æ—©é€Ÿãªã‚“ã ã‘ã©ãƒ¼ã€å‰å›žã¯å®Ÿè¡Œè¨ˆç”»ã«ã¤ã„ã¦ã‚Œãã¡ã‚ƒãƒ¼ã—ãŸã‹ã‚‰ã€ä»Šå›žã¯Statspackã«ã¤ã„ã¦æ•™ãˆã¡ã‚ƒãŠã†ã¨æ€ã†ã®ãƒ¼ã€‚ã„ã„ã‹ãªãƒ¼ï¼Ÿ Statspackã€ã™ãŸã£ã¤ã±ã£ãã€ãã€‚ã¯ãƒ¼ï¼ŸStatspackã£ã¦ãªã«ãƒ¼ï¼Ÿã£ã¦æ„Ÿã˜ã ã‚ˆããƒ¼ï¼Ÿ æ—©ãçŸ¥ã‚ŠãŸã„ã‚ˆããƒ¼ï¼Ÿã˜ã‚ƒã‚ã‚‚ã†ã„ã£ã¡ã‚ƒãŠã‹ãƒ¼ Statspackã£ã¦ãªã«ãƒ¼ãªã«ãƒ¼ï¼Ÿ Statspackã£ã¦ã„ã†ã®ã¯ã€OracleãŒæ¨™æº–ã§æä¾›ã—ã¦ãã‚Œã¦ã„ã‚‹æ€§èƒ½ã‚’åˆ†æžã™ã‚‹ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã ã‚ˆã€‚ ç„¡
replication 2013/09/03
ã“ã®è¨˜äº‹ã™ã’ãˆâˆ’ã€‚ç”»åƒãŒå‡ã£ã¦ã‚‹ã€‚

Oracle

statspack
ãƒªãƒ³ã‚¯
STATSPACK ãƒ¬ãƒãƒ¼ãƒˆã®è¦‹æ–¹ - ablog
è‡ªåˆ†ç”¨ã®ãƒ¡ãƒ¢ã§ã™ã€‚ablog å…¨èˆ¬ã«è¨€ãˆã‚‹ã“ã¨ã§ã™ãŒã€é–“é•ã„ã ã‚‰ã‘ãªã®ã§å‚è€ƒã«ã—ãªã„ã§ä¸‹ã•ã„w [STATSPACK report for -> Sessions] [æ¦‚è¦] ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆå–å¾—æ™‚ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³æ•°ã‚’è¦‹ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ å¹³å¸¸æ™‚ã®ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã‚’å–å¾—ã—ã¦ãŠãã€è² è·ãŒé«˜ã„ã¨ãã‚„ãƒ¬ã‚¹ãƒãƒ³ã‚¹ä½Žä¸‹æ™‚ãªã©ã«æ¯”è¼ƒã™ã‚‹ã€‚ æƒ³å®šã¨å¤§ããé•ã‚ãªã„ã‹ç¢ºèªã™ã‚‹ã€‚ [Load Profile] [æ¦‚è¦] ã‚·ã‚¹ãƒ†ãƒ ã®ç‰¹æ€§ãƒ»å‚¾å‘ã‚’è¦‹ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ å¹³å¸¸æ™‚ã®ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã‚’å–å¾—ã—ã¦ãŠãã€è² è·ãŒé«˜ã„ã¨ãã‚„ãƒ¬ã‚¹ãƒãƒ³ã‚¹ä½Žä¸‹æ™‚ãªã©ã«æ¯”è¼ƒã™ã‚‹ã€‚ [è¦‹æ–¹] Redo size: æ¸¬å®šæœŸé–“ä¸ã«ç”Ÿæˆã•ã‚ŒãŸREDOãƒã‚°é‡(byte)ã€‚ Hard parses: Parses ã«å¯¾ã—ã¦å‰²åˆãŒé«˜ã„å ´åˆã¯ãƒã‚¤ãƒ³ãƒ‰å¤‰æ•°ãŒä½¿ã‚ã‚Œã¦ã„ãªã„SQLãŒåŽŸå› ã®å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚ Logons: ãƒã‚°ã‚ªãƒ³æ•°ã€‚æŽ¥ç¶šãƒ¦ãƒ¼ã‚¶æ•°ã¨æ¯”ã¹ã¦å¤šã™ãŽã‚‹ã¨å•é¡Œã‚
replication 2013/08/23
statspack

Oracle
ãƒªãƒ³ã‚¯
Statspackã®æœ€ã‚‚å„ªã‚ŒãŸè§£èª¬æ›¸ã¨ã¯ï¼Ÿ â€•8æœˆã®äººæ°—è¨˜äº‹
EnterpriseZineï¼ˆã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¸ãƒ³ï¼‰ç·¨é›†éƒ¨ã§ã¯ã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ æ‹…å½“ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ‹…å½“ã®æ–¹ã€…å‘ã‘ã«ã€EnterpriseZine Dayã€Security Online Dayã€DataTechã¨ã„ã†ã€3ã¤ã®ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¦ãŠã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œç·¨é›†éƒ¨ç‹¬è‡ªã®åˆ‡ã‚Šå£ã§ã€æ¥ç•Œãƒˆãƒ¬ãƒ³ãƒ‰ã‚„æœ€æ–°äº‹ä¾‹ã‚’ç¶²ç¾…ã€‚æœ€æ–°ã®å‹•å‘ã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã‚‹å ´ã¨ã—ã¦ã€å¥½è©•ã‚’å¾—ã¦ã„ã¾ã™ã€‚
replication 2013/04/27
Oracle

statspack
ãƒªãƒ³ã‚¯
STATSPACKã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨ä½¿ç”¨ - ã¨ã‚ã‚‹SIerã®æ†‚é¬±
STATSPACKé–¢é€£ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ å…¬å¼ ORACLE_HOME/rdbms/admin/spdoc.txt (ä¸€å¿œ11gå‘ã‘ã«ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã•ã‚Œã¦ã„ã‚‹) Oracle 9i ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ã‚¬ã‚¤ãƒ‰ãŠã‚ˆã³ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ (10gã‹ã‚‰å…¬å¼ã®èª¬æ˜Žã¯ãªããªã£ãŸ) OTNãªã© OTN Japan - Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ æ€§èƒ½å¯¾ç–æ©Ÿèƒ½ ã€œ Statspackã¨Diagnostics Packã‚’ä½¿ã„ã“ãªã™ ã€œ ç¬¬1å›ž Statspackã¨Diagnostics Packã®æ¦‚è¦ã¨ä½¿ç”¨æ–¹æ³• é–€å¤–ä¸å‡ºã®Oracleç¾å ´ãƒ¯ã‚¶ ç¬¬ï¼‘ç« http://oracle tech.jp/products/tsushima/ è¡¨é ˜åŸŸã‚’ä½œæˆ STATSPACKãŒä½œæˆã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã‹ã‚’æŠŠæ¡ã—ãŸã„ã®ã§ã¨ã‚Šã‚ãˆãšå°‚ç”¨è¡¨é ˜åŸŸã‚’ä½œã‚‹ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ãŒæŽ¨å¥¨ã¨ã—ã¦é¸ã¶ã®ã¯ SYSAUX ã ãŒã€‚ å½“åˆã‹ã‚‰100M
replication 2013/04/27
Oracle

statspack
ãƒªãƒ³ã‚¯
STATSPACKã€€è¨å®šæ‰‹é †
ã‚ªãƒ©ã‚¯ãƒ«æ¨™æº–ã®æ€§èƒ½åˆ†æžãƒ„ãƒ¼ãƒ«STATSPACKã«ã¤ã„ã¦èª¿ã¹ã¦ã¿ãŸã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³• STATSPACKã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ä»¥ä¸‹æ‰‹é †ã«ã¦å®Ÿæ–½ã™ã‚‹ã€‚ è¤‡æ•°ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ãŒå˜åœ¨ã™ã‚‹å ´åˆã«ã¯ã€ç’°å¢ƒå¤‰æ•°ORACLE_SIDã‚’è¨å®šã—ã¦ã‹ã‚‰å®Ÿè¡Œã™ã‚‹ã“ã¨ã€‚ (1) SQL*PLUSã«ã¦ã€SYS åˆã¯ INTERNAL USERã¨ã—ã¦DBã«æŽ¥ç¶šã™ã‚‹ã€‚ (2) ä»¥ä¸‹ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’å®Ÿè¡Œã—ã¦ä¸‹ã•ã„ã€‚ SQL> @$ORACLE_HOME/rdbms/admin/spcreate.sql (3) STATS PACKã®ä½¿ç”¨ã™ã‚‹è¡¨ã¨ç´¢å¼•ã‚’æ ¼ç´ã™ã‚‹è¡¨é ˜åŸŸã‚’æŒ‡å®šã™ã‚‹ã€‚â†’ï¼ˆè‡ªå‹•ä½œæˆï¼‰ (4) STATS PACKã®ä½¿ç”¨ã™ã‚‹ä¸€æ™‚è¡¨é ˜åŸŸã‚’æŒ‡å®šã™ã‚‹ã€‚â†’ï¼ˆè‡ªå‹•ä½œæˆï¼‰ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã€ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ã¦ã„ãªã„ã‹ã©ã†ã‹ä»¥ä¸‹ã®ãƒã‚°ã‚’ç¢ºèªã€‚ ãƒ»spcpkg.lis ãƒ»spctab.lis ãƒ»spcusr.lis çµ±è¨ˆæƒ…å ±
replication 2013/04/27
Oracle

statspack
ãƒªãƒ³ã‚¯
1