[B! top] hogetahogekoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hogetahogeko id:hogetahogeko

topã«é–¢ã™ã‚‹hogetahogekoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ã€Oracleã€‘é…ã„SQLã‚’ç‰¹å®šã™ã‚‹SQL - ã‚µãƒ¼ãƒ“ã‚¹æ¥ã§åƒãç¤¾å†…SEã®ãƒ–ãƒã‚°
ãƒ–ãƒã‚°ã®ç§»è¨ã¤ã„ã§ã«éŽåŽ»ã®ãƒ–ãƒã‚°å†…å®¹ã‚’æŠ•ç¨¿ã€‚ DBAã§ã‚ã‚Œã°OEMã§SQLç›£è¦–ã‹ã‚‰ç‰¹å®šã—ã¦ã¿ãŸã‚Š AWRãƒ¬ãƒãƒ¼ãƒˆã‚’ç™ºè¡Œã—ãŸã‚Šç‰ã§ã©ã®SQLãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã„ã‚‹ã‹ã‚’èª¿æŸ»ã™ã‚‹äº‹ãŒå‡ºæ¥ã¾ã™ãŒ é–‹ç™ºè€…ã‚µã‚¤ãƒ‰ã«ç«‹ã£ãŸå ´åˆã«ãªã‹ãªã‹ã“ã†ã„ã£ãŸã¨ã“ã‚ã¾ã§è¸ã¿è¾¼ã‚€äº‹ã¯é›£ã—ã„ã¨æ€ã„ã¾ã™ã€‚ ãã‚‚ãã‚‚ã¡ã‚ƒã‚“ã¨ã—ãŸä¼šç¤¾ã§ã‚ã‚Œã°å®Ÿè£…éƒ¨éšŠã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°éƒ¨éšŠã¨ãŒåˆ†ã‹ã‚Œã¦ã„ã‚‹(ã¨èžã‹ã•ã‚Œã¦ã„ã‚‹)ãŸã‚ æºã‚ã‚‹æ©Ÿä¼šã™ã‚‰ç„¡ã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ãã†ã„ã£ãŸå ´åˆã‚’è€ƒæ…®ã—SQL1ç™ºã§å–å¾—å‡ºæ¥ã‚‹ã‚¯ã‚¨ãƒªã‚’ä½œæˆã—ã¾ã—ãŸã€‚ SELECT DISTINCT S.SID , S.STATUS , S.PROGRAM , q.MODULE , q.SQL_ID , dbms_lob.substr(q.SQL_FULLTEXT,3000,1 ) SQL , s.LAST_CALL_ET å®Ÿè¡Œæ™‚é–“ , q.PARSING_SCHEMA_NAME
hogetahogeko 2018/03/26
Oracle

top

kill
ãƒªãƒ³ã‚¯
TOPã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã„ã“ãªã—ã¦TOPã‚’ç‹™ã†ã€‚ - ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã‚¯ãƒ¯ã‚¬ã‚¿
æ°—ã¾ãã‚Œã§ã€topã‚³ãƒžãƒ³ãƒ‰ã®manã‚’ç°¡å˜ã«ç¢ºèªã—ã¦ã¿ã¾ã—ãŸã€‚åˆã‚ã«è¨€ã£ã¦ãŠãã¨ã€manã‚³ãƒžãƒ³ãƒ‰ã«è¨˜è¼‰ã•ã‚Œã¦ã„ã‚‹ä»¥ä¸Šã®ã“ã¨ã¯ãªã„ã®ã§ãã‚Œã‚’èªã‚ã‚‹äººã¯å¿…è¦ãªã„ã¨æ€ã„ã¾ã™ã€‚ ç’°å¢ƒã¨ã—ã¦ã¯ã€CentOS 4.4ã§ã™ã€‚ å¯¾è©±ç”»é¢ã®åŸºæœ¬ ã¾ãšã€topã‚’å˜ç´”ã«å®Ÿè¡Œã—ãŸå ´åˆã®è¦‹ã‹ãŸã€èµ·å‹•å¾Œã®ã‚³ãƒžãƒ³ãƒ‰ã®ä½¿ã„æ–¹ã‚’ç¢ºèªã™ã‚‹ã€‚ å¯¾è©±ç”»é¢ã®è¦‹ã‹ãŸ topã‚³ãƒžãƒ³ãƒ‰ã‚’å˜ç´”ã«ã‚ªãƒ—ã‚·ãƒ§ãƒ³ç„¡ã—ã§å®Ÿè¡Œã™ã‚‹ã¨ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚‹ã€‚ top - 20:49:53 up 7 min, 1 user, load average: 0.03, 0.36, 0.23 Tasks: 79 total, 2 running, 77 sleeping, 0 stopped, 0 zombie Cpu(s): 0.0% us, 0.3% sy, 0.0% ni, 99.7% id, 0.0% wa, 0.0% hi, 0.0% si Mem: 103
hogetahogeko 2018/03/26
top
ãƒªãƒ³ã‚¯
ã€Oracle Databaseã€‘ãƒ¡ãƒ¢ãƒªã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’èª¿ã¹ã‚‹æ–¹æ³• | ã‚¢ã‚·ã‚¹ãƒˆ
ã€Œâ—‹â—‹ã—ã¦ã„ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’èª¿ã¹ã‚‹æ–¹æ³•ã‚’æ•™ãˆã¦æ¬²ã—ã„ã€ã¨ã„ã†ãŠå•ã„åˆã‚ã›ã‚’ã„ãŸã ãã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚â—‹â—‹ã®éƒ¨åˆ†ã¯ã€ŒCPUã‚’ä½¿ç”¨ã€ã€ã€Œãƒ¡ãƒ¢ãƒªã‚’ä½¿ç”¨ã€ã€ã€ŒREDOã‚’å¤šãç”Ÿæˆã€ãªã©æ§˜ã€…ã§ã™ãŒã€ã“ã‚Œã‚‰ã®ç¢ºèªæ–¹æ³•ã‚’çŸ¥ã£ã¦ãŠãã“ã¨ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†ã‚’è¡Œã†ä¸Šã§é‡è¦ã§ã™ã€‚ ä»Šå›žã¯ãƒ¡ãƒ¢ãƒªã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®ç¢ºèªæ–¹æ³•ã‚’2ã¤ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨çŽ‡ãŒé«˜é¨°ã—ãŸéš›ã«ã¯ã€ã¾ãšã€OSå´(Windowsï¼šãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ¢ãƒ‹ã‚¿ã€Unixç³»ï¼špsã‚„topãªã©)ã‹ã‚‰Oracle Databaseã®ãƒ—ãƒã‚»ã‚¹ãŒãƒ¡ãƒ¢ãƒªã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã®ã‹ã®ç¢ºèªã‚’è¡Œã„ã¾ã™ã€‚ ã‚‚ã—ãƒ¡ãƒ¢ãƒªã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã®ãŒOracle Databaseã®ãƒ—ãƒã‚»ã‚¹ã ã£ãŸå ´åˆã¯ã€ãã®ãƒ—ãƒã‚»ã‚¹ã¯ã©ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã«ç´ä»˜ã„ã¦ã„ã¦ã€ã©ã®ã‚ˆã†ãªå‡¦ç†ã§ãƒ¡ãƒ¢ãƒªã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã®ã‹ç¢ºèªã—ã¾ã™ã€‚ ãƒ¡ãƒ¢ãƒªã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®ç‰¹å®šã«ã¯å‹•çš„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ“ãƒ¥ãƒ¼ï¼ˆV$ãƒ“ãƒ¥
hogetahogeko 2018/03/26
Oracle

kill

top
ãƒªãƒ³ã‚¯
Oracle ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ ID ã¨ OSPID ã‚’ç´ã¥ã‘ã‚‹æ–¹æ³• - Qiita
Oracle ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ ID ã¨ OSPID ã‚’ç´ã¥ã‘ã‚‹æ–¹æ³• Oracle ã® v$session ã§å‡ºåŠ›ã•ã‚Œã‚‹æƒ…å ±ã¯ SID(ã‚»ãƒƒã‚·ãƒ§ãƒ³ ID)ã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã¾ã™ã€‚ãŸã ã—ã€å„ãƒ—ãƒã‚»ã‚¹ã® CPU ä½¿ç”¨çŽ‡ã‚’è¿½ã†å ´åˆã«ã¯ã€SID ã¨ OSPID ã‚’ç´ã¥ã‘ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ç´ã¥ã‘ãŸã„å ´åˆã¯ä»¥ä¸‹ã® SQL ã§å¯èƒ½ã§ã™ã€‚SPID åˆ—ãŒ OSPID ã«ç›¸å½“ã—ã¾ã™ã€‚ SID PID SPID USERNAME OSUSER PROGRAM ---- --- ----- -------- -------- ------------------------------- 2 2 5537 ora11204 oracle@ol66.local (PMON) 3 3 5539 ora11204 oracle@ol66.local (PSP0) 4 4 5541 ora11204 oracle@ol66.l
hogetahogeko 2018/03/26
Oracle

kill

top
ãƒªãƒ³ã‚¯
ã€Ž[Oracle] çµ‚äº†ã—ãŸã¯ãšã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ»ãƒ—ãƒã‚»ã‚¹ãŒOSä¸Šã«æ®‹ã‚Šç¶šã‘ã‚‹ï¼Žï¼Žï¼Žã€
[Oracle] çµ‚äº†ã—ãŸã¯ãšã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ»ãƒ—ãƒã‚»ã‚¹ãŒOSä¸Šã«æ®‹ã‚Šç¶šã‘ã‚‹ï¼Žï¼Žï¼Ž | Archive Redo Blog Oracle ã§ã¯ã€å°‚ç”¨ã‚µãƒ¼ãƒãƒ¼æ§‹æˆã®å ´åˆã€ã‚µãƒ¼ãƒãƒ¼ä¸Šã«ã¯ã‚»ãƒƒã‚·ãƒ§ãƒ³ã”ã¨ã«ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ»ãƒ—ãƒã‚»ã‚¹ãŒç«‹ã¡ä¸ŠãŒã‚Šã¾ã™ã€‚ ã“ã‚Œã‚‰ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ»ãƒ—ãƒã‚»ã‚¹ã¯æ£å¸¸ã«åˆ‡æ–ã•ã‚Œã‚Œã°çµ‚äº†ã•ã‚Œã¾ã™ãŒã€å¼·åˆ¶çµ‚äº†ã—ãŸã‚Šã€ä¸æ„ã«ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãŒåˆ‡ã‚ŒãŸã‚Šã—ãŸã¨ãã«ã¯ã€ã‚µãƒ¼ãƒãƒ¼ä¸Šã«æ®‹ã‚Šç¶šã‘ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã—ã‹ã‚‚ã€ã“ã‚Œã‚‰ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ»ãƒ—ãƒã‚»ã‚¹ã¯ CPU ã‚’å æœ‰ã—ç¶šã‘ã€ã‚µãƒ¼ãƒãƒ¼ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«æ‚ªå½±éŸ¿ã‚’åŠã¼ã™ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã®ã§è¦æ³¨æ„ã§ã™ã€‚ ã“ã®ã‚ˆã†ãªãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ»ãƒ—ãƒã‚»ã‚¹ã‚’ç™ºè¦‹ã™ã‚‹ã«ã¯ã€Oracleã€OS ã®ä¸¡ã‚µã‚¤ãƒ‰ã‹ã‚‰ã‚¢ãƒ—ãƒãƒ¼ãƒã—ã€ä¸¡è€…ã®æƒ…å ±ã‚’ç…§åˆã—ã¦å¯¾å‡¦ã™ã‚‹ã“ã¨ã«ãªã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ Oracle ã‚µã‚¤ãƒ‰ã‹ã‚‰ã‚¢ãƒ—ãƒãƒ¼ãƒã™ã‚‹å ´åˆã¯ã€V$SESSION ã¨ V$PROCESS ã®æƒ…å ±ã‚’å‚ç…§ã—ã¾ã™ã€‚ ä¾‹ãˆã°ã€ä»¥ä¸‹ã® SQ
hogetahogeko 2018/03/26
Oracle

kill

top
ãƒªãƒ³ã‚¯
1