[B! Oracle] takami_hirokiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

takami_hiroki id:takami_hiroki

Oracleã«é–¢ã™ã‚‹takami_hirokiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (50)

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

DB è¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚Š[æœ€æ–°ç‰ˆ] - Qiita
ã“ã‚“ã«ã¡ã¯ã€ã™ã£ã‹ã‚Šç§‹ã§ã™ãï¼@yone098 ã§ã™ã€‚ ã¿ãªã•ã‚“DBã®è¨è¨ˆã—ã¦ã¾ã™ã‹ï¼Ÿ DBè¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚Š ä»¥å‰ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ã§æ›¸ã„ãŸè¨˜äº‹ã¯5å¹´å‰ã®ã‚‚ã®ã§ã‚ã‚Šã€ãƒªãƒ³ã‚¯ãŒåˆ‡ã‚Œã¦ã„ã‚‹ã‚‚ã®ãŒã‚ã‚‹ã®ã§æœ€æ–°ç‰ˆã¨ã—ã¦ MySQL, PostgreSQL, Oracle, SQLServer ã«ãŠã‘ã‚‹DBè¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚Šã‚’ã¾ã¨ã‚ç›´ã—ã¾ã—ãŸã€‚ MySQL URLå†…ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³è¡¨è¨˜ã‚’å¤‰ãˆã‚‹ã¨ä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®æƒ…å ±ã«ãªã‚Šã¾ã™ã€‚ MySQLã¯ã€ã‚ã¾ã‚Šæƒ…å ±ã«å¤‰åŒ–ã¯ç„¡ã‹ã£ãŸã®ã§ Excel ã§ãƒžã‚¯ãƒãªã©ã‚’ä½œæˆã—ã¦è‡ªç¤¾ã§è‡ªå‹•ç®—å‡ºå‡ºæ¥ã‚‹ã‚ˆã†ã«ã™ã‚‹ã®ãŒè‰¯ã„ã¨æ€ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚¿ã‚¤ãƒ—ã”ã¨ã«å¿…è¦ãªè¦æ±‚ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãŒæ±ºã¾ã£ã¦ã„ã‚‹ã®ã§ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚µã‚¤ã‚ºãŒæ±ºã¾ã‚Šã€ã‚ã¨ã¯è¦ä»¶æ¬¡ç¬¬ã§ä½•ãƒ¬ã‚³ãƒ¼ãƒ‰ã«ãªã‚‹ã‹ã‚’äºˆæ¸¬ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚¿ã‚¤ãƒ—ã”ã¨ã«å¿…è¦ãªè¨˜æ†¶å®¹é‡ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æœ€å¤§ã‚µã‚¤ã‚ºé–¢é€£ http://dev.mysql.com/doc/re
takami_hiroki 2014/11/07
MySQL

DB

oracle

PostgreSQL

ã‚µã‚¤ã‚¸ãƒ³ã‚°
ãƒªãƒ³ã‚¯
OTN Japan ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«
é–€å¤–ä¸å‡ºã®Oracleç¾å ´ãƒ¯ã‚¶ ç¬¬5ç« ã€€DBã‚¢ã‚¯ã‚»ã‚¹ã®ç©ºç™½åœ°å¸¯ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã‚’æ¥µã‚ã‚‹ æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«æ ªå¼ä¼šç¤¾ ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°çµ±æ‹¬æœ¬éƒ¨ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°æœ¬éƒ¨ å°ç”° åœäºŒ(ãŠã ã‘ã„ã˜) ç›®æ¬¡ Part1ã€€Â DBæŽ¥ç¶šã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ç®¡ç†æ€§ã‚’æœ€å¤§åŒ–ã™ã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®ä»•çµ„ã¿ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ï¼Ÿ æŽ¥ç¶šã™ã‚‹ã‚¿ã‚¤ãƒŸãƒ³ã‚° ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®æ§‹æˆè¦ç´ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã«ä»˜éšã™ã‚‹æŠ€è¡“ å…±æœ‰ã‚µãƒ¼ãƒãƒ¼æ§‹æˆ OCIã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚° Part2ã€€Â Java ï¼†.NETã§ä½¿ãˆã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ç©¶æ¥µã®é¸æŠž Javaã«ãŠã‘ã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚° ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®é¸æŠžåŸºæº– ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®å®Ÿè£…ã®ç´¹ä»‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®åˆ‡ã‚Šæ›¿ãˆ .NETã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚° ãŠã‚ã‚Šã« Part1ã€€DBæŽ¥ç¶šã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ç®¡ç†æ€§ã‚’æœ€å¤§åŒ–ã™ã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³
takami_hiroki 2014/02/07
Oracle

ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«

DB
ãƒªãƒ³ã‚¯
OTN Japan ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«
takami_hiroki 2014/02/05
Oracle

sql

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
ã‚¼ãƒã‹ã‚‰ç†è§£ã™ã‚‹ã€ŒOracle RACã€
æœ¬é€£è¼‰ã¯ã€ä¼æ¥ã®æˆé•·ã«ä¸å¯æ¬ ãªã€Œãƒ‡ãƒ¼ã‚¿æ´»ç”¨ã€ã‚’æŽ¨é€²ã—ã¦ã„ããŸã‚ã«å¿…è¦ãªãƒ‡ãƒ¼ã‚¿åŸºç›¤ã®åŸºç¤Žã‚’â€œã‚ã‚‰ãŸã‚ã¦â€è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚ä»Šå›žã¯ã€Oracle Databaseã®ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°æ©Ÿèƒ½ã§ã‚ã‚‹ã€ŒOracle Real Application Clustersï¼ˆOracle RACï¼‰ã€ã®åŸºç¤Žã¨ä»•çµ„ã¿ã‚’è§£èª¬ã—ã¾ã™ã€‚ã€æ›´æ–°ç‰ˆã€‘
takami_hiroki 2013/12/27
Oracle

RAC

Oracle RAC
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“ã®ç¾…é‡ç›¤
ã‚ˆã‚Šè©³ç´°ãªCQRSã«é–¢ã™ã‚‹è³‡æ–™ã¯ã“ã¡ã‚‰ https://little-hands.hatena blog.com/entry/2019/12/02/cqrs å‚è€ƒè³‡æ–™ï¼šhttp://little-hands.hatena blog.com/entry/jjug2017fall ç¤¾å†…æ–°è¦ãƒ—ãƒãƒ€ã‚¯ãƒˆã§DDD, CQRSã®æ€æƒ³ã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ãŸã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’æ§‹ç¯‰ã—ã€ã‚³ãƒžãƒ³ãƒ‰(æ›´æ–°ç³»å‡¦ç†)ã§ã¯Spring Data JPA(Hibernate)ã‚’ã€ã‚¯ã‚¨ãƒª(å‚ç…§ç³»å‡¦ç†)ã§ã¯jOOQã‚’æŽ¡ç”¨ã—ã¾ã—ãŸã€‚ çµæžœã¨ã—ã¦ãã‚Œãžã‚Œã®ORMã®è‰¯ã„ã¨ã“ã‚ã‚’ç”Ÿã‹ã—ãŸçµ„ã¿åˆã‚ã›ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãŒæ§‹ç¯‰ã§ããŸã®ã§ã€ãã®çµŒç·¯ã¨å¾—ã‚‰ã‚ŒãŸçŸ¥è¦‹ã«ã¤ã„ã¦ãŠè©±ã—ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ä»¥ä¸‹ã®ã‚ˆã†ãªãƒˆãƒ”ãƒƒã‚¯ã‚’è€ƒãˆã¦ã„ã¾ã™ã€‚ ãƒ»CQRSã®å®šç¾©ã¨ãƒ¡ãƒªãƒƒãƒˆãƒ‡ãƒ¡ãƒªãƒƒãƒˆ ãƒ»DDD,CQRSã‚’æ¤œè¨Žã™ã‚‹ã«ã‚ãŸã£ã¦ã®ORMã®é¸å®šãƒã‚¤ãƒ³ãƒˆ ãƒ»æ§‹ç¯‰ã—ãŸã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£
takami_hiroki 2013/11/17
mysql

oracle

db

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

PostgreSQL
ãƒªãƒ³ã‚¯
ã‚ãƒ£ãƒƒã‚·ãƒ¥ã®å¤§ãã„RDB vs ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€æ€§èƒ½ãŒã©ã‚Œã ã‘é•ã†ã®ã‹èª¿ã¹ã¦ã¿ã‚‹ã¨
2é€±é–“ã»ã©å‰ã«ã€Œã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®ä¸»æµã«ãªã‚‹ã¨ã„ã†æœŸå¾…ã€ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ãã¾ã—ãŸã€‚ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã«ä»£ã‚ã‚Šã€ãƒ¡ãƒ¢ãƒªã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ°¸ç¶šåŒ–æ‰‹æ®µã¨ã™ã‚‹ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€è¶…é«˜é€Ÿãªã‚¢ã‚¯ã‚»ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã‚’å®Ÿç¾ã™ã‚‹ã€ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸»å½¹ã«ãªã‚‹ã®ã§ã¯ãªã„ã‹ã€ã¨ã„ã†å†…å®¹ã§ã™ã€‚ ã“ã®è¨˜äº‹ã«é–¢ã—ã¦ã€TechVisorã®æ —åŽŸã•ã‚“ã¨æ¬¡ã®ã‚ˆã†ãªã‚„ã‚Šã¨ã‚Šã‚’ã—ã¾ã—ãŸã€‚ ç¢ºã‹ã«ã€Oracle Real Application Clusterï¼ˆä»¥ä¸‹ã€Oracle RACï¼‰ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå…¨éƒ¨è¼‰ã‚‹ãã‚‰ã„ååˆ†ã«ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã®ãƒ¡ãƒ¢ãƒªã‚’å‰²ã‚Šå½“ã¦ã‚Œã°ã€ãƒ¡ãƒ¢ãƒªä¸Šã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨åŒã˜ã“ã¨ã§ã¯ãªã„ã®ã‹ã€ã¨ã‚‚æ€ã„ã¾ã™ã€‚ ä¸¡è€…ã®é•ã„ã¯ä½•ã‹ã‚ã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ èª¿ã¹ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯1000å€é€Ÿã„ èª¿ã¹ã¦ã¿ã‚‹ã¨ã™ãã«ã€ä¸¡è€…ã«ã¯æ˜Žç¢ºãªæ€§èƒ½å·®ãŒã‚
takami_hiroki 2010/12/13
ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚„æ§‹é€ ãŒãƒ¡ãƒ¢ãƒªä¸Šã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ã®ã«æœ€é©åŒ–ã•ã‚Œã¦ã„ã‚‹ã“ã¨ãŒã€ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’è±Šå¯Œã«è¨å®šã—ãŸRDBMSã‚ˆã‚Šã‚‚é«˜é€Ÿãªç†ç”±

DB

Oracle

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
HENNGEæ ªå¼ä¼šç¤¾
HENNGEã¨å…±ã«ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚’è§£ãæ˜Žã‹ã™ã€ã‚ªãƒ¼ãƒ—ãƒ³ãªå¯¾è©±ã‚¤ãƒ™ãƒ³ãƒˆã€ŒHENNGE TECH SYNC.ã€
takami_hiroki 2009/10/13
MVCC

DB

postgresql

Oracle
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒ“ãƒ¥ãƒ¼ã‚’ä½¿ç”¨ã—ãŸã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ã“ã®ç« ã®å¾ŒåŠã§ã¯ã€Oracleã®å‹•çš„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒ“ãƒ¥ãƒ¼ã‚’ä½¿ç”¨ã—ãŸã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ãŸã ã—ã€æ‹¡å¼µæ©Ÿèƒ½ãƒªã‚¹ãƒˆã«ã‚ˆã‚‹çµ±è¨ˆã®åŽé›†ã€ç›£è¦–ãŠã‚ˆã³ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¯ã€è‡ªå‹•ãƒ¯ãƒ¼ã‚¯ãƒãƒ¼ãƒ‰ãƒ»ãƒªãƒã‚¸ãƒˆãƒªãŠã‚ˆã³Automatic Database Diagnostic Monitorã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã‚’ãŠè–¦ã‚ã—ã¾ã™ã€‚ã€Œè‡ªå‹•ãƒ¯ãƒ¼ã‚¯ãƒãƒ¼ãƒ‰ãƒ»ãƒªãƒã‚¸ãƒˆãƒªã®æ¦‚è¦ã€ãŠã‚ˆã³ã€ŒAutomatic Database Diagnostic Monitorã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ å•é¡Œã®å®šç¾© ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã®å®Ÿè£…ã‚’è©¦ã¿ã‚‹å‰ã«ã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°èª¿æŸ»ã®ç›®çš„ã¨å•é¡Œã®æ€§è³ªã‚’ã‚ˆãç†è§£ã—ã¦ãŠãã“ã¨ãŒä¸å¯æ¬ ã§ã™ã€‚ã“ã‚Œã«ã¤ã„ã¦ç†è§£ã—ã¦ã„ãªã„ã¨ã€äº‹å®Ÿä¸Šã€åŠ¹æžœçš„ãªå¤‰æ›´ã¯å®Ÿè£…ã§ãã¾ã›ã‚“ã€‚ã“ã®æ®µéšŽã§åŽé›†ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ç”¨ã—ã¦ã€æ¬¡ã«è¡Œã†ã“ã¨ã€ãŠã‚ˆã³èª¿æŸ»ã™ã‚‹äº‹è±¡ã‚’ç°¡å˜ã«æ±ºå®šã§ãã¾ã™ã€‚ æ¬¡ã®ãƒ‡ãƒ¼ã‚¿ã‚’åŽé›†ã—ã¾ã™ã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ç›®çš„ã‚’è˜åˆ¥ã—ã¾ã™
takami_hiroki 2009/07/21
ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒã‚ã‚Šã€ã‹ã¤ã€ãã®ã‚«ãƒ©ãƒ ã‚’è¤‡æ•°ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã§æ›´æ–°ã—ã¦ã„ã‚‹ã¨ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ãŒç™ºç”Ÿã™ã‚‹ã€‚

Oracle

ãƒˆãƒ©ãƒ–ãƒ«ãƒãƒƒã‚¯

ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³

ãƒãƒƒã‚¯éšœå®³èª¿æŸ»
ãƒªãƒ³ã‚¯
OTN Japan - Oracle9i ç‰©ç†è¨è¨ˆï¼šç¬¬3éƒ¨ ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¨è¨ˆ
ç§ã®æ‰€å±žã™ã‚‹OracleDirectã§ã¯é›»è©±ã‚„ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‚’åˆ©ç”¨ã—ã¦ã€å„ç¨®ã®ãŠå•åˆã›ã‚’é ‚ã„ãŸãŠå®¢æ§˜ã«å¯¾ã—ã¾ã—ã¦ã€ãŠå®¢æ§˜ã®æ‹…å½“ã•ã‚Œã¦ãŠã‚‰ã‚Œã‚‹ã‚·ã‚¹ãƒ†ãƒ ã®æˆç´„ãƒ»æˆåŠŸã®ãŸã‚ã®å„ç¨®ã”æ”¯æ´ã‚’ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚å˜ã«ãŠå•åˆã›ã«å¯¾ã™ã‚‹å›žç”ã‚’è¡Œã†ã ã‘ã§ãªãã€ã”è¦æœ›ãŒã‚ã‚Œã°è£½å“ç´¹ä»‹ã‚„æ©Ÿèƒ½è§£èª¬ã®ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã€ãƒ‡ãƒ¢ç‰ã‚‚é›»è©±ã¨ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆçµŒç”±ã‚’ä½µç”¨ã—ã¦å®Ÿæ–½ã„ãŸã—ã¾ã™ã€‚ãŠå•åˆã›ã¯ç„¡å„Ÿã§ã™ã®ã§Oracleè£½å“ã«ã¤ã„ã¦ç¢ºèªã—ãŸã„ã“ã¨ãŒã”ã–ã„ã¾ã—ãŸã‚‰ãŠæ°—è»½ã«ã”é€£çµ¡ãã ã•ã„ã€‚ ã¯ã˜ã‚ã« ãƒ†ãƒ¼ãƒ–ãƒ«ã®å®¹é‡è¦‹ç©ã«ã¤ã„ã¦ã¯ã€OTN Japanã«ä»¥ä¸‹ã®è³‡æ–™ãƒ»ãƒ„ãƒ¼ãƒ«ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ é ˜åŸŸã‚µã‚¤ã‚ºã®è¦‹ç©ã‚‚ã‚Šæ–¹æ³• é ˜åŸŸã‚µã‚¤ã‚ºè¦‹ç©ã‚·ãƒ¼ãƒˆ ã“ã“ã§è§£èª¬ã—ã¦ã„ã‚‹è¦‹ç©æ–¹æ³•ã¯ã€è³‡æ–™ã€Œé ˜åŸŸã‚µã‚¤ã‚ºã®è¦‹ç©ã‚‚ã‚Šæ–¹æ³•ã€ã®è€ƒãˆæ–¹ã‚’ã‚„ã‚„ç°¡ç•¥åŒ–ã—ã¦ã€è¨ˆç®—ã—ã‚„ã™ãã—ãŸæ–¹æ³•ã§ã™ã€‚ã¾ãŸã€æŒ‡é‡ã‚’å‡ºã™ã¨ã„ã†ã“ã¨ã‚’å„ªå…ˆã—ã€ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã‚„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã‚‹é•ã„ã‚’
takami_hiroki 2009/02/12
Oracle

è¨å®š
ãƒªãƒ³ã‚¯
ã‚ªãƒ©ã‚¯ãƒ«ãƒžã‚¹ã‚¿ãƒ¼ã¸ã®é“: Goldå®Ÿè·µè¬›åº§
ã†ã‚Œã—ã„ï¼ã€Œå‰å›žã€DBAè¬›åº§ã§å–ã‚Šä¸Šã’ã¦æ¬²ã—ã„ã‚«ãƒ†ã‚´ãƒªãŒã‚ã‚Šã¾ã—ãŸã‚‰ã”é€£çµ¡ä¸‹ã•ã„ã€‚ã€ã¨ãŠé¡˜ã„ã—ãŸã‚‰ã•ã£ãããƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’é ‚ãã¾ã—ãŸã€‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ï¼ ã‚ãªãŸã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã«ãŠå¿œãˆã—ã¦ã€ã€Œè¨˜æ†¶æ§‹é€ ã€ã‚’ãŠå±Šã‘ã—ã¾ã™ã€‚ï¼ˆãªã‚“ã¦ã€ãƒ©ã‚¸ã‚ªã®DJã¿ãŸã„ã§ã™ãï¼‰ ã“ã®ã‚«ãƒ†ã‚´ãƒªã§æŠ¼ã•ãˆã¦ãŠããƒã‚¤ãƒ³ãƒˆã¯æ¬¡ã®2ã¤ã¨è€ƒãˆã‚Œã°è‰¯ã„ã§ã—ã‚‡ã†ã€‚ è¨˜æ†¶é ˜åŸŸç®¡ç†ãƒ‘ãƒ©ãƒ¡ã‚¿ ãƒ»PCTFREE ãƒ»PCTUSED ãƒ»INITRANSï¼ˆãƒ–ãƒãƒƒã‚¯ã‚ãŸã‚Šã®åŒæ™‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆæœŸæ•°ï¼‰ ãƒ»MAXTRANSï¼ˆãƒ–ãƒãƒƒã‚¯ã‚ãŸã‚Šã®åŒæ™‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æœ€å¤§æ•°ï¼‰ é ˜åŸŸã«é–¢ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ‡ã‚£ã‚¯ã‚·ãƒ§ãƒŠãƒª ãƒ»DBA_FREE_SPACEï¼ˆè¡¨é ˜åŸŸå†…ã®ç©ºãé ˜åŸŸï¼‰ ãƒ»DBA_SEGMENTS ãƒ»DBA_EXTENTS 1.è¨˜æ†¶é ˜åŸŸç®¡ç†ãƒ‘ãƒ©ãƒ¡ã‚¿ï¼ˆPCTFREEã¨PCTUSEDï¼‰ Oracleã§ã€ŒPCTã€ã¨ããŸã‚‰ã€ã€ŒPe
takami_hiroki 2009/02/12
PCT_FREEã¨PCT_USEDã«ã¤ã„ã¦

Oracle

è¨å®š
ãƒªãƒ³ã‚¯
SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ã‚¢ãƒ‰ãƒã‚¤ã‚¶ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®äº‹å‰ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚·ãƒ§ãƒƒãƒˆã®è¡¨ç¤º ã“ã®ã‚¢ã‚¤ã‚³ãƒ³ã®ä¸Šã«ã‚«ãƒ¼ã‚½ãƒ«ã‚’ç½®ãã¨ã€ã™ã¹ã¦ã®ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚·ãƒ§ãƒƒãƒˆãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ å„é …ç›®ã«é–¢é€£ã™ã‚‹ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚·ãƒ§ãƒƒãƒˆã®ã¿ã‚’è¡¨ç¤ºã™ã‚‹å ´åˆã¯ã€ãã‚Œãžã‚Œã®ã‚¢ã‚¤ã‚³ãƒ³ã®ä¸Šã«ã‚«ãƒ¼ã‚½ãƒ«ã‚’ç½®ã„ã¦ãã ã•ã„ã€‚ æ¦‚è¦ ãƒˆãƒ”ãƒƒã‚¯ãƒ»ãƒªã‚¹ãƒˆã«æˆ»ã‚‹ Oracle Enterprise Managerã®æ–°æ©Ÿèƒ½ã§ã‚ã‚‹SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãŠã‚ˆã³è¨ºæ–æ©Ÿèƒ½ã®ç‰¹é•· Automatic Workload Repository(AWR)ã¯ã€å•é¡Œã®æ¤œå‡ºã‚„è‡ªå·±ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãªã©ã‚’ç›®çš„ã¨ã™ã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹çµ±è¨ˆã‚’åŽé›†ã€å‡¦ç†ã€ãŠã‚ˆã³ç®¡ç†ã—ã¾ã™ã€‚ Automatic Database Diagnostic Monitorï¼ˆADDMï¼‰ã¯ã€Oracleã‚·ã‚¹ãƒ†ãƒ ã®è¨ºæ–ã‚„ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«å¿…è¦ãªåŠ´åŠ›ã‚’è»½æ¸›ã—ã¾ã™ã€‚ SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ã‚¢ãƒ‰ãƒã‚¤ã‚¶ã®æ©Ÿèƒ½ã‚’ä½¿ç”¨ã—ã¦ã€SQLæ–‡ã‚’ç´ æ—©ãåŠ¹æžœçš„ã«æœ€é©åŒ–ã§ãã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚’è¨ºæ–ã™ã‚‹ç›£è¦–ã®å®Œäº†å¾Œã€ãƒ‘ãƒ•
takami_hiroki 2009/02/05
Oracle

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒˆãƒ©ãƒ–ãƒ«10é¸---ç¬¬3å›žã€€Oracleã®ã‚¨ãƒ©ãƒ¼ã«å¯¾å‡¦ã™ã‚‹ï¼ˆ4ï¼‰
æ¬¡ã¯ï¼Œãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ãƒ»ã‚»ã‚°ãƒ¡ãƒ³ãƒˆï¼Šã«é–¢ã™ã‚‹ã‚¨ãƒ©ãƒ¼ã ã€‚ã€ŒORA-01555 ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆãŒå¤ã™ãŽã¾ã™ã€ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãƒ»ã‚³ãƒ¼ãƒ‰ã¯æœ‰åãªãŸã‚ï¼Œã‚ã‚‹ç¨‹åº¦Oracleã§é‹ç”¨ã‚„é–‹ç™ºã‚’çµŒé¨“ã•ã‚ŒãŸæ–¹ã§ã‚ã‚Œã°ï¼Œéé‡ã—ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ ãƒˆãƒ©ãƒ–ãƒ«ã®ç¾è±¡ã¨ã—ã¦ã¯ï¼Œå‚ç…§ç³»ãƒ—ãƒã‚°ãƒ©ãƒ ã®ã‚¨ãƒ©ãƒ¼ãŒå ±å‘Šã•ã‚ŒãŸã‚Šï¼Œå‡¦ç†ãŒç„¡å¿œç”ã«ãªã£ãŸã‚Šã™ã‚‹ã€‚ã“ã®çŠ¶æ³ã§ï¼Œä¾‹ã«ã‚ˆã£ã¦ã‚¢ãƒ©ãƒ¼ãƒˆãƒ»ãƒ•ã‚¡ã‚¤ãƒ«ã‚’èª¿ã¹ã¦ã¿ã‚‹ã€‚ç„¡å¿œç”ã«ãªã£ãŸæ™‚é–“ã®å‰å¾Œã‚’è¦‹ã‚‹ã¨ï¼Œã€ŒORA-01555 ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆãŒå¤ã™ãŽã¾ã™ï¼ˆãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ãƒ»ã‚»ã‚°ãƒ¡ãƒ³ãƒˆç•ªå·: 1ï¼Œåå‰:rollbacksegment_name ãŒå°ã•ã™ãŽã¾ã™ï¼‰ã€ã¨ã‚ã‚‹ã€‚ ãã®æ„å‘³ã‚’ã”å˜çŸ¥ã®æ–¹ã‚‚å¤šã„ã¨æ€ã†ãŒï¼Œæ”¹ã‚ã¦ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ãƒ»ã‚»ã‚°ãƒ¡ãƒ³ãƒˆã®å½¹å‰²ã‹ã‚‰ãŠã•ã‚‰ã„ã—ã¦ãŠã“ã†ã€‚ç¬¬1å›žã§ã‚‚è§¦ã‚ŒãŸãŒï¼Œãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ãƒ»ã‚»ã‚°ãƒ¡ãƒ³ãƒˆã¯ï¼Œãƒ‡ãƒ¼ã‚¿ã®å¤‰æ›´å‰ã®ã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’ä¿æŒã—ï¼Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ï¼Œå›žå¾©ï¼Œèªã¿å–ã‚Š
takami_hiroki 2008/10/01
oracle

éšœå®³åˆ‡ã‚Šåˆ†ã‘
ãƒªãƒ³ã‚¯
ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆãƒ»ãƒ‘ã‚¹ãƒ»ã‚¤ãƒ³ã‚µãƒ¼ãƒˆ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracleã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆãƒ»ãƒ‘ã‚¹ãƒ»ã‚¤ãƒ³ã‚µãƒ¼ãƒˆ ï¼ˆãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆãƒ»ãƒãƒ¼ãƒ‰ãƒ»ã‚¤ãƒ³ã‚µãƒ¼ãƒˆï¼‰ ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆãƒ»ãƒ‘ã‚¹ãƒ»ã‚¤ãƒ³ã‚µãƒ¼ãƒˆã¨ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒƒãƒ•ã‚¡ã‚’çµŒç”±ã›ãšãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã¸ ç›´æŽ¥ãƒ‡ãƒ¼ã‚¿ã‚’è½ã¨ã—è¾¼ã‚€ã¨ã„ã†ç‚¹ã‹ã‚‰ã€ã‚ã‚‹ç‰¹å®šæ¡ä»¶ä¸‹ã§éžå¸¸ã«å„ªã‚ŒãŸå‡¦ç†æ–¹æ³•ã§ã‚ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒãƒ•ã‚¡å‡¦ç†ã‚’çµŒç”±ã—ãªã„ã“ã¨ã§é«˜é€Ÿã«å‡¦ç†ã§ãã€ãƒãƒƒãƒ•ã‚¡ã‹ã‚‰ä»–ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’è¿½ã„å‡ºã™ã“ã¨ã«ã‚ˆã‚‹ã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ’ãƒƒãƒˆçŽ‡ã®ä½Žä¸‹ã‚’é˜²ãã“ã¨ã‚‚ã§ãã‚‹ã€‚ é«˜é€Ÿã«å¤§é‡ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ã‚µãƒ¼ãƒˆã•ã›ã‚‹ãŸã‚ã®æ‰‹æ³• ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆãƒ»ãƒ‘ã‚¹ãƒ»ã‚¤ãƒ³ã‚µãƒ¼ãƒˆã«ã‚ˆã‚‹é«˜é€Ÿã®ã‚¤ãƒ³ã‚µãƒ¼ãƒˆå‡¦ç†ã«ã¯ãƒˆãƒ¬ãƒ¼ãƒ‰ã‚ªãƒ•ãŒã‚ã‚‹ãŒè„…å¨çš„ãªé€Ÿã•ã‚’èª‡ã‚‹ã€‚ æ•°ç™¾ä¸‡ä»¶ã‚ªãƒ¼ãƒ€ã®ãƒ‡ãƒ¼ã‚¿ã®æŠ•å…¥ã™ã‚‹ã®ã«æ•°åˆ†ã¨ã‹ã‹ã‚‰ãªã„(ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚µã‚¤ã‚ºã€ã‚¹ãƒšãƒƒã‚¯ã«å·¦å³ã¯ã•ã‚Œã‚‹) é€šå¸¸ã®ãƒ‘ã‚¹ã®ãƒãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã«æ¯”ã¹ã¦ æ•°åˆ†ã®1 ç¨‹åº¦ã®æ™‚é–“ã§æŠ•å…¥ã§ãã‚‹ã€‚ NOLOGGING çŠ¶æ…‹ã®å ´åˆ REDO ãƒã‚°ãŒå‡ºåŠ›ã•ã‚Œãªã„ã€‚ï¼ˆé«˜é€Ÿã«ã¯ãªã‚‹ä¸€æ–¹ã§ãƒ•ãƒ«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã¾ã§
takami_hiroki 2008/09/19
Oracle

æ€§èƒ½ãƒ†ã‚¹ãƒˆã§ä½¿ãˆãã†

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

DB
ãƒªãƒ³ã‚¯
ã‚¹ã‚ãƒ¼ãƒžçµ±è¨ˆæƒ…å ± - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracleã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
ã‚¹ã‚ãƒ¼ãƒžçµ±è¨ˆæƒ…å ±ã®åŽé›† ã‚¹ã‚ãƒ¼ãƒžçµ±è¨ˆæƒ…å ±ã‚’åŽé›†ã¨å¯¾è±¡ãƒªã‚¹ãƒˆã‚’æŠ½å‡ºã™ã‚‹æ–¹æ³• GATHER_SCHEMA_STATS ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã«ã¯ã€ã‚¹ã‚ãƒ¼ãƒžå˜ä½ ã®çµ±è¨ˆã®åŽé›†ã¨ãƒªã‚¹ãƒˆå–å¾—ã® 2ã¤ã®æ©Ÿèƒ½*1ãŒã‚ã‚‹ã€‚ çµ±è¨ˆæƒ…å ±ã®åŽé›† (DBMS_STATS) ã«æˆ»ã‚‹ã€‚ ã‚¹ã‚ãƒ¼ãƒžçµ±è¨ˆæƒ…å ±ã®åŽé›† ã‚¹ã‚ãƒ¼ãƒžå…¨ä½“ã«ã‚ãŸã‚Šã€OPTIONS ã«æŒ‡å®šã—ãŸæ–¹æ³•ã§çµ±è¨ˆæƒ…å ±ã‚’åŽé›†ã™ã‚‹ã€‚ åŸºæœ¬çš„ãªãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ DBMS_STATS.GATHER_SCHEMA_STATS ( OWNNAME Â Â Â Â Â => 'ã‚¹ã‚ãƒ¼ãƒž' ,OPTIONS Â Â Â Â Â => 'ã‚ªãƒ—ã‚·ãƒ§ãƒ³' ,ESTIMATE_PERCENT => 'ã‚µãƒ³ãƒ—ãƒ«ãƒ¬ãƒ¼ãƒˆ' ,BLOCK_SAMPLE Â Â => 'ã‚µãƒ³ãƒ—ãƒ«ãƒ¬ãƒ¼ãƒˆ(block)' ,DEGREE Â Â Â Â Â => 'ä¸¦åˆ—åº¦' ,GRANULARITY Â Â Â => 'ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³è¡¨ã‚ª
takami_hiroki 2008/09/18
Oracle10gã§çµ±è¨ˆæƒ…å ±ã‚’ã€æ‰‹å‹•ã§å–å¾—ã™ã‚‹æ–¹æ³•ï¼ˆ10gã¯åŸºæœ¬çš„ã«å®šæœŸçš„ã«è‡ªå‹•å–å¾—ã—ã¦ãã‚Œã‚‹ãŒã€æ€§èƒ½ãƒ†ã‚¹ãƒˆã®éš›ãªã©æ‰‹å‹•å–å¾—ã—ãŸã„å ´åˆã‚‚ã‚ã‚‹ã¯ãšï¼‰

Oracle

Oracle10g

å®Ÿè¡Œè¨ˆç”»
ãƒªãƒ³ã‚¯
ORACLEï¼ã‚ªãƒ©ã‚¯ãƒ«ã¡ã‚‡ã“ã£ã¨ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
æœ€çµ‚æ›´æ–°æ—¥ï¼š2023/01/03 ã¯ã˜ã‚ã« ã‚ªãƒ©ã‚¯ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚·ã‚¹ãƒ†ãƒ ã®é–‹ç™ºã‚’ã—ãŸã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å‹‰å¼·ã‚’ã—ã¦ã„ã‚‹æ™‚ã« ã€Œã‚ã€ã“ã®æ§‹æ–‡ã©ã†ã‚„ã£ã¦æ›¸ãã‚“ã ã£ãŸã‹ãªãã€ã¨ã‹ ã€Œã“ã†ã„ã†å‡¦ç†ãŒã—ãŸã„ã‚“ã ã‘ã©ä½•ã‹ã„ã„é–¢æ•°ãŒãªã„ã‹ãªãã€ã€ ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æƒ…å ±ãŒå–å¾—ã—ãŸã„ã‚“ã ã‘ã©ã€ã©ã†ã‚„ã‚‹ã‚“ã ã‚ã†ï¼Ÿã€ã¨ã„ã£ãŸ ã¡ã‚‡ã“ã£ã¨èª¿ã¹ãŸã„æ™‚ã«ä½¿ã£ã¦ã‚‚ã‚‰ãˆã‚Œã°ã¨æ€ã„ã€å½“ã‚µã‚¤ãƒˆã‚’é–‹è¨ã—ã¾ã—ãŸã€‚ å†…å®¹ã¯è‡ªåˆ†ãŒé–‹ç™ºã—ã¦ã‚‹æ™‚ã«ã¡ã‚‡ã£ã¨èª¿ã¹ãŸã„ã¨æ€ã£ãŸã“ã¨ã‚’ä¸å¿ƒã«æ›¸ãã¾ã—ãŸã®ã§ã€ ãŸã¶ã‚“çš†ã•ã‚“ã®ãŠå½¹ã«ç«‹ã¦ã‚‹ã¨æ€ã„ã¾ã™ã€‚ å½“ã‚µã‚¤ãƒˆã¯ãƒªãƒ³ã‚¯ãƒ•ãƒªãƒ¼ã§ã™ã€‚ çš†æ§˜ã®ãƒšãƒ¼ã‚¸ã«ãƒªãƒ³ã‚¯ã‚’è²¼ã£ã¦ã„ãŸã ã‘ã‚Œã°å¬‰ã—ã„ã§ã™ã€‚(*^_^*)
takami_hiroki 2008/09/08
oracle

tips
ãƒªãƒ³ã‚¯
ayumu-baby.com
This domain may be for sale!
takami_hiroki 2008/07/28
oracle
ãƒªãƒ³ã‚¯
ã‚·ã‚¹ãƒ†ãƒ æ¨©é™ä¸€è¦§ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracleã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
ã‚·ã‚¹ãƒ†ãƒ æ¨©é™ä¸€è¦§ ã‚·ã‚¹ãƒ†ãƒ æ¨©é™ã®ç¨®é¡žã¨å„ã‚µãƒ–ã‚¿ã‚¤ãƒ—(ã‚ªãƒ—ã‚·ãƒ§ãƒ³)ä¸€è¦§ GRANT [ã‚µãƒ–ã‚¿ã‚¤ãƒ—] {æ¨©é™å} TO {ãƒ¦ãƒ¼ã‚¶ãƒ¼å} ä¾‹ãˆã° æ¨©é™å CONTEXT ã®å ´åˆ GRANT CREATE ANY CONTEXT ... TO ... GRANT DROP ANY CONTEXT ...
takami_hiroki 2008/07/14
Oracle

ã‚·ã‚¹ãƒ†ãƒ æ¨©é™ä¸€è¦§
ãƒªãƒ³ã‚¯
ã€åˆç´šã€‘æ–°äººSEã®ãŸã‚ã®SQLã®åŸºç¤Žã€€ç¬¬3å›žï¼ˆå‰åŠï¼‰ã€€æ—¥ä»˜åž‹ã®æ³¨æ„ç‚¹
å›³1â—ä»Šå›žå–ã‚Šä¸Šã’ã‚‹SQLæ–‡ã®æ³¨æ„ç‚¹<BR>ï¼ˆ1ï¼‰æ—¥ä»˜åž‹ï¼Œï¼ˆ2ï¼‰SUMã‚„AVGãªã©ã®é›†ç´„é–¢æ•°ï¼Œï¼ˆ3ï¼‰GROUP BYå¥ã¨HAVINGå¥â€•â€•ä»Šå›žã¯ã“ã®3ç‚¹ã«ã¾ã¤ã‚ã‚‹SQLæ–‡ã®æ³¨æ„ç‚¹ã‚’èª¬æ˜Žã™ã‚‹ å›³2â—æ—¥ä»˜åž‹ã®æ™‚é–“ãƒ‡ãƒ¼ã‚¿ã«æ³¨æ„<BR>Oracleã®æ—¥ä»˜åž‹ï¼ˆDATEï¼‰ã«ã¯æ™‚é–“ã®ãƒ‡ãƒ¼ã‚¿ãŒå«ã¾ã‚Œã‚‹ãŸã‚ï¼Œï¼ˆ1ï¼‰æ—¥ä»˜åž‹ã‚«ãƒ©ãƒ ã«å¯¾ã—ã¦æ—¥ä»˜ã ã‘ã®æ¤œç´¢æ¡ä»¶ã‚’æŒ‡å®šã—ã¦ã‚‚æ¤œç´¢ã§ããªã„ã€‚æ—¥ä»˜ã‚’æ¤œç´¢æ¡ä»¶ã«ã—ãŸã„å ´åˆï¼Œæ—¥ä»˜åž‹ã«æ™‚é–“ãƒ‡ãƒ¼ã‚¿ãŒå«ã¾ã‚Œã‚‹ã“ã¨ã‚’æ„è˜ã—ï¼Œã€Œï¼ˆ2ï¼‰ç¯„å›²æŒ‡å®šã™ã‚‹ã€ï¼Œã€Œï¼ˆ3ï¼‰æ™‚é–“ã‚’åˆ‡ã‚Šæ¨ã¦ã‚‹ã€ï¼Œã€Œï¼ˆ4ï¼‰æ—¥ä»˜ã‚’å–ã‚Šå‡ºã™ã€ãªã©ã®æ–¹æ³•ã‚’æŽ¡ã‚‹å¿…è¦ãŒã‚ã‚‹ ä»Šå›žå–ã‚Šä¸Šã’ã‚‹æ—¥ä»˜åž‹ï¼Œé›†ç´„é–¢æ•°ï¼ŒGROUP BYå¥ï¼ŒHAVINGå¥ã¯ï¼Œä¾¿åˆ©ãªã®ã§ã‚ˆãä½¿ã‚ã‚Œã‚‹ã€‚ã—ã‹ã—ã“ã‚Œã‚‰ã‚’ä½¿ã„å§‹ã‚ã®ã“ã‚ã«ä¸€åº¦ã¯ã‚„ã£ã¦ã—ã¾ã†å¤±æ•—ä¾‹ãŒã‚ã‚‹ã€‚ä¸€åº¦çµŒé¨“ã™ã‚‹ã¨å¤§ä¸ˆå¤«ãªã®ã ãŒï¼Œåˆ†ã‹ã‚‰ãªã„ã†ã¡ã¯æˆ¸æƒ‘ã†ã“ã¨ã«ãªã‚‹ã€‚Oracleã®æ—¥ä»˜åž‹ã«ã¯æ™‚é–“ãƒ‡ãƒ¼ã‚¿ãŒå«ã¾ã‚Œã‚‹
takami_hiroki 2008/07/07
æ—¥ä»˜ã‚’æ¡ä»¶ã«ã—ãŸæ¤œç´¢ã¯æ³¨æ„ãŒå¿…è¦

sql

Oracle
ãƒªãƒ³ã‚¯
SQL*Plus ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ä¸€è¦§ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracle SQL*Plus ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
SQL*Plus ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•° SQL*Plus ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã¨ã¯ SQL*Plus ã®å®Ÿè¡Œæ™‚ã®å¼•æ•°ã ã‘ã§ã¯è¨å®šã—ãã‚Œãªã„ã‚‚ã®ã‚„å‹•çš„ã«è¨å®šã‚’å¤‰æ›´ã™ã‚‹ãŸã‚ã«ã€Œã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’éšæ™‚å¤‰æ›´å¯èƒ½ãªå¤‰æ•°ã€ã«ã—ãŸã‚ˆã†ãªã‚‚ã®ã§ã‚ã‚‹ã€‚ ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã®è¨å®šã¯ SQL*Plus ã‚³ãƒžãƒ³ãƒ‰ã® SET ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•° å€¤ ã¨ã„ã†å½¢å¼ã§è¡Œãªã„ã€‚ ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã®ç¾åœ¨ã®å€¤ã‚’å‚ç…§ã—ãŸã„å ´åˆã«ã¯ SHOW ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•° ã‚’å®Ÿè¡Œã™ã‚‹ã¨ç¢ºèªã§ãã‚‹ã€‚ SQL*Plus ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ä¸€è¦§
takami_hiroki 2008/05/07
oracle

SQL*Plus

tips
ãƒªãƒ³ã‚¯
PL/SQL ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³åž‹ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracle PL/SQL ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
PL/SQL ã®é…åˆ— ï¼ ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³åž‹ PL/SQL ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³åž‹ã«ã¯ å¤§ããåˆ†ã‘ã¦ PL/SQL è¡¨ã¨ VARRAY(å¯å¤‰é•·é…åˆ—) ãŒå˜åœ¨ã™ã‚‹ã€‚ PL/SQL è¡¨ PL/SQL è¡¨ã¨ã¯ã€ã‚ªãƒ©ã‚¯ãƒ«ã®ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³åž‹ã®ä¸€ç¨®ã€‚ çµåˆé…åˆ—(ç´¢å¼•ä»˜ãè¡¨) ã¨ ãƒã‚¹ãƒˆã—ãŸè¡¨ (NESTED TABLE) ãŒ PL/SQL è¡¨ã¨å‘¼ã°ã‚Œã¦ã„ã‚‹ã€‚ æ˜”ã®ã‚ªãƒ©ã‚¯ãƒ«ã«ã¯ ç´¢å¼•ä»˜ãè¡¨ã—ã‹ãªãã€ç´¢å¼•ä»˜ãè¡¨ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ ¼ç´ã§ããš PL/SQL ã§ã—ã‹æ‰±ãˆãªã‹ã£ãŸãŸã‚ PL/SQL è¡¨ã¨å‘¼ã°ã‚ŒãŸã¨æ€ã‚ã‚Œã‚‹ã€‚ ç¾åœ¨ã¯ ãƒã‚¹ãƒˆã—ãŸè¡¨ ã‚‚ PL/SQL è¡¨ã«å«ã¾ã‚Œã¦ã„ã‚‹ãŒã€ã“ã¡ã‚‰ã¯ ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ ¼ç´å¯èƒ½ã€‚ PL/SQL è¡¨ ã¨ã„ã†è¨€è‘‰ãŒæ£ç¢ºãªæ„å‘³ã‚’ã‚ã‚‰ã‚ã—ã¦ã„ãªã„ãŸã‚ã€ãã®è¡¨ç¾ã¯æ¶ˆãˆã¤ã¤ã‚ã‚‹(ã¨æ€ã†)ã€‚ çµåˆé…åˆ— (ç´¢å¼•ä»˜ã®è¡¨) ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã«ã¯çµåˆé…åˆ—ã¨è¨³ã•ã‚Œã¦ã„ã‚‹ãŒã€åŽŸæ–‡ã§ã¯ Associative Array (ï¼é€£
takami_hiroki 2008/04/28
[PL/SQL]PL/SQLã®ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³åž‹

Oracle
ãƒªãƒ³ã‚¯
1 2 3 æ¬¡ã®ãƒšãƒ¼ã‚¸