[B! oracle] tgkã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

tgk id:tgk

oracleã«é–¢ã™ã‚‹tgkã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (28)

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

åŸºæœ¬çš„ãªãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼
9 åŸºæœ¬çš„ãªãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ ã“ã®ç« ã§ã¯ã€ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ã®ä½¿ç”¨æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚å†…å®¹ã¯æ¬¡ã®ã¨ãŠã‚Šã§ã™ã€‚ ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ã‚’ä½¿ç”¨ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ»ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã®æ¦‚è¦ ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ã®ã‚¿ã‚¤ãƒ— ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ã®ä½œæˆ æ—¢å˜ã®ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ã®ç™»éŒ² ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ã«å¯¾ã™ã‚‹ç´¢å¼•ä»˜ã‘ã®é¸æŠž ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ã®å‰Šé™¤ ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼æ©Ÿèƒ½ã®åˆ†æž ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ã‚’ä½¿ç”¨ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ»ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã®æ¦‚è¦ ä¸€èˆ¬çš„ã«ã€ãƒ‡ãƒ¼ã‚¿ã¯æœˆã€é€±ã¾ãŸã¯æ—¥å˜ä½ã§ã€1ã¤ä»¥ä¸Šã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ»ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†(OLTP)ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã«é€ã‚‰ã‚Œã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ã¯é€šå¸¸ã€ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã«è¿½åŠ ã•ã‚Œã‚‹å‰ã« ã‚¹ãƒ†ãƒ¼ã‚¸ãƒ³ã‚°ãƒ»ãƒ•ã‚¡ã‚¤ãƒ«ã§å‡¦ç†ã•ã‚Œã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã®ã‚µã‚¤ã‚ºã¯ã€ä¸€èˆ¬çš„ã«ã€æ•°åGBã‹ã‚‰æ•°TBã®ç¯„å›²ã«ã‚ãŸã‚Šã¾ã™ã€‚é€šå¸¸ã€ãƒ‡ãƒ¼ã‚¿ã®
tgk 2016/05/07
ã€Œãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ“ãƒ¥ãƒ¼ã¯ã€é€šå¸¸ã€ã‚¯ã‚¨ãƒªãƒ¼ãƒ»ãƒªãƒ©ã‚¤ãƒˆæ©Ÿèƒ½ã‚’ä½¿ç”¨ã—ã¦ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã¾ã™ãŒã€ã‚¨ãƒ³ãƒ‰ãƒ¦ãƒ¼ã‚¶ã¾ãŸã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ“ãƒ¥ãƒ¼ã«ç›´æŽ¥ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹å•åˆã›ã‚‚ä½œæˆã§ãã¾ã™ã€

sql

oracle
ãƒªãƒ³ã‚¯
Oracle Instant Client ã‚’Windows ODBC ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã¨ã—ã¦ç™»éŒ²æ‰‹é †ãƒ¡ãƒ¢ â€“ hrendoh's tech memo
Oracle Instant Clientã‚’åˆ©ç”¨ã—ã¦ODBCãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã‚’å®šç¾©ã™ã‚‹æ‰‹é †ã‚’èª¿ã¹ãŸã®ã§ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—æ‰‹é † 1. Oracle Instant Clientã‚’å…¥æ‰‹ Oracleã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‚µã‚¤ãƒˆã‚ˆã‚ŠOracle Instant Clientã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¾ã™ã€‚ http://www.oracle.com/tech network/database/features/instant-client/index-097480.html ä»Šå›žã¯32bitç‰ˆã‚’åˆ©ç”¨ã™ã‚‹ã®ã§ã€Instant Client Downloads for Microsoft Windows (32-bit)ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ä»¥ä¸‹ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’è½ã¨ã—ã¾ã™ã€‚ instantclient-basic-nt-12.1.0.2.0.zip instantclient-odbc-nt-12.1.0.2.0.zip
tgk 2016/02/02
ã€Œodbc_installã‚’å®Ÿè¡Œã™ã‚‹ã¨ã€sqresus.dllãŒæ¶ˆã•ã‚Œã¦ã—ã¾ã†ã®ã§ã€å†åº¦instantclient-odbc-nt-12.1.0.2.0.zipã‚’è§£å‡ã—ãªãŠã—ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã™ã€

oracle
ãƒªãƒ³ã‚¯
Oracle Application Express
tgk 2014/07/22
oracle
ãƒªãƒ³ã‚¯
ORACLE:ORACLEã®ãƒ•ãƒªãƒ¼ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚½ãƒ•ãƒˆã€ŒInstant Clientã€ã®ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—æ–¹æ³•
ã€ŒInstant Clientã€ã¯ã€ORACLEãŒæä¾›ã—ã¦ã„ã‚‹ç„¡æ–™ã®ORACLEæŽ¥ç¶šç”¨ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ ã€ŒInstant Clientã€ã‚’ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã™ã‚Œã°ã€ã“ã‚Œã¾ã§ã®ã‚ˆã†ã«æ¨™æº–ã®Oracle Clientã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã›ãšã«ã€ã¾ãŸã¯ORACLE_HOMEãŒãªãã¦ã‚‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿè¡Œã§ãã‚‹ã€‚ ORACLEã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã®è¨˜è¼‰ã«ã‚ˆã‚‹ã¨ã€ ã€ŒOCIã€OCCIã€ODBCã€ãŠã‚ˆã³JDBCã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒä¿®æ£ãªã—ã«å‹•ä½œã™ã‚‹ã»ã‹ã€ä½¿ç”¨ã™ã‚‹ãƒ‡ã‚£ã‚¹ã‚¯é ˜åŸŸã‚‚ã“ã‚Œã¾ã§ã‚ˆã‚Šå¤§å¹…ã«æ¸›ã‚Šã¾ã™ã€‚Instant Clientã¨ã¨ã‚‚ã«SQL*Plusã‚‚ä½¿ç”¨ã§ãã¾ã™ã€‚å†ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã‚‚ä¸è¦ã§ã™ã€‚ã€ ã ãã†ã§ã™ã€‚ ODBCãƒ‰ãƒ©ã‚¤ãƒã‚‚é…å¸ƒã•ã‚Œã¦ã„ã‚‹ã®ã§ã€Accessã‚„Excelã€VBã‹ã‚‰ODBCæŽ¥ç¶šã§ORACLEã«æŽ¥ç¶šã—ãŸã„ãªã‚“ã¦ã„ã†æ™‚ã«ã‚‚ã€ŒInstant Clientã€ã‚’ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã—ã¦ãŠã‘ã°å•é¡ŒãªãæŽ¥ç¶šã§ã
tgk 2014/07/10
oracle
ãƒªãƒ³ã‚¯
Myth: The Oracle Database Cannot Index NULL
tgk 2012/01/31
è¤‡åˆindexã®ä¸€éƒ¨ã®åˆ—ãŒnullã®ã¨ãã€ãã®nullã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã•ã‚Œã‚‹ã€‚ã€ŒOracleã¯nullã‚’ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã—ãªã„ã€ã¨ã„ã†ã®ã¯å…¨åˆ—nullã®å ´åˆã®è©±

oracle
ãƒªãƒ³ã‚¯
ã‚¯ã‚¨ãƒªãŒç¾åœ¨å®Ÿè¡Œæ®µéšŽã®ã©ã“ã‚’å®Ÿè¡Œã—ã¦ã„ã‚‹ã®ã‹åˆ†ã‹ã‚‹æ–¹æ³•ãŒãªã„ã‚“ã§ã—ã‚‡ã†ã‹
ã“ã®å‰ã€ç¤¾å†…ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŸã¡ã¨è©±ã—åˆã†ã†ã¡ã“ã‚“ãªç–‘å•ãŒæèµ·ãŒæèµ·ã•ã‚Œã¾ã—ãŸã€‚ ã‚¯ã‚¨ãƒªãŒç¾åœ¨å®Ÿè¡Œæ®µéšŽã®ã©ã“ã‚’å®Ÿè¡Œã—ã¦ã„ã‚‹ã®ã‹åˆ†ã‹ã‚‹æ–¹æ³•ãŒãªã„ã‚“ã§ã—ã‚‡ã†ã‹ã€‚ SQL*Traceã®ã‚ˆã†ãªä¸€èˆ¬çš„ãªæ–¹æ³•ã§ã¯ä¸å¯èƒ½ã§ã™ã€‚ãŸã¶ã‚“å”¯ä¸€ãªæ–¹æ³•ã¯ã‚ªãƒ©ã‚¯ãƒ«ãŒå®Ÿè¡Œè¨ˆç”»ã«ã‚ˆã£ã¦ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ãªãŒã‚‰å‘¼ã³å‡ºã™é–¢æ•°(Function)ã‚’ãƒˆãƒ¬ãƒ¼ã‚¹ã™ã‚‹ã“ã¨ã§ã—ã‚‡ã†ã€‚ã‚ªãƒ©ã‚¯ãƒ«ãŒå‘¼ã³å‡ºã™é–¢æ•°ã‚’ãƒˆãƒ¬ãƒ¼ã‚¹ã™ã‚‹ä¸€ç•ªç°¡å˜ãªæ–¹æ³•ã¯oradebug short_stackã‚³ãƒžãƒ³ãƒ‰ã§ã™ã€‚ ç°¡å˜ãªä¾‹ã‚’é€šã˜ã¦è¦‹ã¾ã—ã‚‡ã†ã€‚ã¾ãšæ¬¡ã®ã‚ˆã†ã«å¿…è¦ãªã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œã‚Šã¾ã™ã€‚ create table t1 as select level as c1, 'x' as c2 from dual connect by level <= 1000; create table t2 as select level as c1, 'x' as c2 from dual
tgk 2011/07/26
oradebug short_stack

oracle
ãƒªãƒ³ã‚¯
https://blogs.oracle.com/oracle4engineer/post/entry/post_73
tgk 2011/07/06
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¿½åŠ ã®å½±éŸ¿ç¯„å›²ã‚’é™å®šã™ã‚‹ãŸã‚ã«ï¼šã€Œç´¢å¼•ã‚’ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã«å¯¾ã—ã¦éžè¡¨ç¤ºã«ã—...ãã®ç´¢å¼•ã‚’ä½¿ç”¨ã—ãªã„ã‚ˆã†ã«ã§ãã‚‹ã€ã€Œå•åˆã›ãŒç´¢å¼•ã‚’ä½¿ç”¨ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã¨ãã¯ã€ãƒ’ãƒ³ãƒˆã¨ã—ã¦æ˜Žç¤ºçš„ã«æŒ‡å®šã™ã‚‹ã€

sql

oracle

tuning
ãƒªãƒ³ã‚¯
https://blogs.oracle.com/oracle4engineer/post/column/technical/020849.html
tgk 2010/12/29
oracle
ãƒªãƒ³ã‚¯
Oracle Knowledge ã‚¢ãƒ¼ã‚«ã‚¤ãƒ– | EXEM Japan HP
â€œScene25 â€“ SGAï¼š allocation forcing Component growthâ€...
tgk 2010/10/08
oracle

tuning
ãƒªãƒ³ã‚¯
ã€Ž[Oracle] 11gã§ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å¤§æ–‡å—å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ã€
Oracle 11g ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã€Object Browser 9 ã§æŽ¥ç¶šã—ã‚ˆã†ã¨ã™ã‚‹ã¨ã€ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ã¾ã—ãŸã€‚ ORA-01017: ãƒ¦ãƒ¼ã‚¶ãƒ¼å/ ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒç„¡åŠ¹ã§ã™ã€‚ãƒã‚°ã‚ªãƒ³ã¯æ‹’å¦ã•ã‚Œã¾ã—ãŸã€‚ 11g ã‹ã‚‰ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å¤§æ–‡å—å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ã‚ˆã†ã«ãªã£ãŸã“ã¨ãŒåŽŸå› ã®ã‚ˆã†ã§ã™ã€‚ Object Browser 9 ã¯ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å°æ–‡å—ã§å…¥åŠ›ã—ã¦ã‚‚å¤§æ–‡å—ã«è‡ªå‹•å¤‰æ›ã—ã¦ Oracle ã«æŠ•ã’ã‚‹ãŸã‚ã€å°æ–‡å—ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒè¨å®šã•ã‚Œã¦ã„ã‚‹å ´åˆã€ãƒã‚°ã‚ªãƒ³ã§ããªããªã£ã¦ã—ã¾ã†ã¨ã„ã†ã‚ã‘ã§ã™ã€‚ 10g ä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨åŒã˜ã‚ˆã†ã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å¤§æ–‡å—å°æ–‡å—ã‚’åŒºåˆ¥ã—ãªã„ã‚ˆã†ã«ã™ã‚‹ã«ã¯ã€åˆæœŸåŒ–ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ SEC_CASE_SENSITIVE_LOGON ã‚’ FALSE ã«å¤‰æ›´ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON
tgk 2010/01/19
oracle
ãƒªãƒ³ã‚¯
OTN Japan - Oracle9i ç‰©ç†è¨è¨ˆï¼šç¬¬3éƒ¨ ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¨è¨ˆ
ç§ã®æ‰€å±žã™ã‚‹OracleDirectã§ã¯é›»è©±ã‚„ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‚’åˆ©ç”¨ã—ã¦ã€å„ç¨®ã®ãŠå•åˆã›ã‚’é ‚ã„ãŸãŠå®¢æ§˜ã«å¯¾ã—ã¾ã—ã¦ã€ãŠå®¢æ§˜ã®æ‹…å½“ã•ã‚Œã¦ãŠã‚‰ã‚Œã‚‹ã‚·ã‚¹ãƒ†ãƒ ã®æˆç´„ãƒ»æˆåŠŸã®ãŸã‚ã®å„ç¨®ã”æ”¯æ´ã‚’ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚å˜ã«ãŠå•åˆã›ã«å¯¾ã™ã‚‹å›žç”ã‚’è¡Œã†ã ã‘ã§ãªãã€ã”è¦æœ›ãŒã‚ã‚Œã°è£½å“ç´¹ä»‹ã‚„æ©Ÿèƒ½è§£èª¬ã®ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã€ãƒ‡ãƒ¢ç‰ã‚‚é›»è©±ã¨ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆçµŒç”±ã‚’ä½µç”¨ã—ã¦å®Ÿæ–½ã„ãŸã—ã¾ã™ã€‚ãŠå•åˆã›ã¯ç„¡å„Ÿã§ã™ã®ã§Oracleè£½å“ã«ã¤ã„ã¦ç¢ºèªã—ãŸã„ã“ã¨ãŒã”ã–ã„ã¾ã—ãŸã‚‰ãŠæ°—è»½ã«ã”é€£çµ¡ãã ã•ã„ã€‚ ã¯ã˜ã‚ã« ãƒ†ãƒ¼ãƒ–ãƒ«ã®å®¹é‡è¦‹ç©ã«ã¤ã„ã¦ã¯ã€OTN Japanã«ä»¥ä¸‹ã®è³‡æ–™ãƒ»ãƒ„ãƒ¼ãƒ«ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ é ˜åŸŸã‚µã‚¤ã‚ºã®è¦‹ç©ã‚‚ã‚Šæ–¹æ³• é ˜åŸŸã‚µã‚¤ã‚ºè¦‹ç©ã‚·ãƒ¼ãƒˆ ã“ã“ã§è§£èª¬ã—ã¦ã„ã‚‹è¦‹ç©æ–¹æ³•ã¯ã€è³‡æ–™ã€Œé ˜åŸŸã‚µã‚¤ã‚ºã®è¦‹ç©ã‚‚ã‚Šæ–¹æ³•ã€ã®è€ƒãˆæ–¹ã‚’ã‚„ã‚„ç°¡ç•¥åŒ–ã—ã¦ã€è¨ˆç®—ã—ã‚„ã™ãã—ãŸæ–¹æ³•ã§ã™ã€‚ã¾ãŸã€æŒ‡é‡ã‚’å‡ºã™ã¨ã„ã†ã“ã¨ã‚’å„ªå…ˆã—ã€ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã‚„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã‚‹é•ã„ã‚’
tgk 2009/12/02
numberåˆ—ã®é•·ã• = 1 + CEIL (n / 2)

oracle
ãƒªãƒ³ã‚¯
ROWNUM - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracleã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
ROWNUM æ“¬ä¼¼åˆ— ROWNUM æ“¬ä¼¼åˆ—ã®ç‰¹å¾´ã¯ ã‚½ãƒ¼ãƒˆå‰ã®æŠ½å‡ºã—ãŸçµæžœã‚»ãƒƒãƒˆã®ãƒ¬ã‚³ãƒ¼ãƒ‰ç•ªå·ã‚’ã‚ã‚‰ã‚ã™ã€‚ WHERE æ¡ä»¶ã«å…¥ã‚Œã‚‹ã“ã¨ã§ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã‚’åˆ¶é™ã§ãã‚‹ã€‚(ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã«åŠ©è¨€ã‚’ã‚ãŸãˆã¦ã„ã‚‹) æ¡ä»¶ã®è©•ä¾¡é †åºã¯ã€ãã®æ¡ä»¶æ–‡ã«ãŠã„ã¦æœ€å¾Œã«è©•ä¾¡ã•ã‚Œã‚‹ã€‚ ORDER BY ã¨ WHERE ã«ä½µç”¨ã™ã‚‹ã¨ WHERE æ¡ä»¶ãŒå…ˆã«è©•ä¾¡ã•ã‚Œã‚‹ã€‚ è¡Œç•ªå· (ROWNUM) ã®å‰²ã‚Šå½“ã¦ã¯ä¸¦ã³æ›¿ãˆå‡¦ç†å‰ã®æ¡ä»¶ã«ä¸€è‡´ã—ãŸãƒ‡ãƒ¼ã‚¿å–ã‚Šå‡ºã—æ™‚ã«å‰²ã‚Šå½“ã¦æ¸ˆã¿ã§ã‚ã‚‹ã€‚ æŠ½å‡ºã—ãŸçµæžœãƒ¬ã‚³ãƒ¼ãƒ‰ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ç•ªå·ã‚’ã‚ã‚‰ã‚ã™ ROWNUM ã¯çµæžœã‚»ãƒƒãƒˆã«å¯¾ã™ã‚‹ä¸€æ„ã®æ˜‡é †ã®è¡Œç•ªå·ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã€‚(å–ã‚Šå‡ºã—é †) SELECT ROWNUM FROM EMP ; ROWNUM ---------- 1 2 ... å–å¾—ã™ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã®åˆ¶é™ ROWNUM ã‚’æ¡ä»¶ã«åŠ ãˆã‚‹ã“ã¨ã§ è¡Œç•ªå· (ROWNUM) ã®æ¡ä»¶ã‚’é™¤ã„ã¦çµžã‚Šè¾¼ã‚“ã çµæžœ ã‹
tgk 2009/11/14
ã“ã‚Œã¯ STOPKEY ã«ã‚ˆã‚‹ã‚‚ã®ã§ 1 ãƒ¬ã‚³ãƒ¼ãƒ‰ã‹ã‚‰è©•ä¾¡ã—ã€è¡Œç•ªå·ã¸ã®è©•ä¾¡ãŒå½ã«ãªã£ãŸæ™‚ç‚¹ã§çµ‚äº†ã™ã‚‹ã€‚ã¤ã¾ã‚Š ROWNUM = 2 ã‚’æœ€åˆã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã§è©•ä¾¡ã—ãŸå ´åˆ 1 =2 .. false ã«ãªã‚Šå–ã‚Šå‡ºã—å‡¦ç†ãŒçµ‚äº†ã•ã‚Œã‚‹

oracle
ãƒªãƒ³ã‚¯
AWRã‹ã‚‰å®Ÿè¡Œè¨ˆç”»ã‚’ã¾ã‚‹ã£ã¨æŠœã„ã¦ãã‚‹ - MATSUâ€™s vision
select * from ( select 'select * from table(DBMS_XPLAN.DISPLAY_AWR(''' || SQL_ID || ''',null,null,' ||'''ALL'''||'));' from dba_hist_sqlstat order by ELAPSED_TIME_DELTA desc ) where <ã»ã’ã»ã’>; å®Ÿè¡Œè¨ˆç”»ãŒæ™‚é–“å¸¯ã«ã‚ˆã£ã¦ã“ã‚ã“ã‚å¤‰ã‚ã‚‹å ´åˆã«ã€‚ å¯¾è±¡ã¨ãªã‚‹SQLãŒæ•°ç™¾æœ¬ã¨ã‹ã‚ã‚‹ã¨ãŸã„ã¸ã‚“ã§ã™ã‚ˆãã€‚ ãã‚“ãªå ´åˆã¯SQLã§SQLæ–‡ã‚’ç”Ÿæˆã—ã¦ä¸€æ°—ã«å®Ÿè¡Œã€‚ ã‚ã¨ã§å¥½ãã«ç·¨é›†ã—ã¦ã€‚ ãªã«ã‹ã¨ä¾¿åˆ©ã§ã™ã€‚
tgk 2009/11/04
oracle
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ•ã‚©ãƒãƒ¥ãƒ¼ã§ä¸€ç•ªæœ€åˆã«è¦‹ã‚‹ã¨ã“ã‚ - MATSUâ€™s vision
å•ç”ç„¡ç”¨ã§ã€Œdba_hist_sqlstatã€ã‚’è¦‹ã«è¡Œãã¾ã™ã€‚ 10gã‹ã‚‰è‡ªå‹•ã§SQLç¨¼å‹•ãƒã‚°ãŒå…¨éƒ¨å–å¾—ã•ã‚Œã‚‹ã“ã®è¡¨ã€‚ ã‚‚ã®ã™ã”ãä¾¿åˆ©ãªã®ã§ãœã²æ´»ç”¨ã—ã¦ãã ã•ã„ãã€‚ ã•ã£ããã¿ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ SQL> select SQL_ID,SNAP_ID,ELAPSED_TIME_DELTA 2 from dba_hist_sqlstat 3 order by ELAPSED_TIME_DELTA desc 4 ; SQL_ID SNAP_ID ELAPSED_TIME_DELTA ---------- ------------------ g2wr3u7s1gtf3 352 22746 4ynyjw64rp857 374 22731 0h6b2sajwb74n 351 22662 0h6b2sajwb74n 362 22637 4ynyjw64rp857 399 22549 ï¼ˆä»¥ä¸‹ã¨ã¦ã‚‚é•·ã„ã®ã§ç•¥
tgk 2009/10/31
dba_hist_sqlstat

oracle
ãƒªãƒ³ã‚¯
Oracle
2025å¹´2æœˆ13æ—¥ã«æ±äº¬ã§é–‹å‚¬ã•ã‚Œã‚‹ã€ã‚ªãƒ©ã‚¯ãƒ«ã®ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ãŠã‚ˆã³ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚ãƒ³ã‚°ã‚¤ãƒ™ãƒ³ãƒˆã€ŒCloudWorld Tourã€ã«ãœã²ã”å‚åŠ ãã ã•ã„ã€‚ã‚ªãƒ©ã‚¯ãƒ«ã®ã‚¨ã‚°ã‚¼ã‚¯ãƒ†ã‚£ãƒ–ã‚„å°‚é–€å®¶ã€ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã€åŒæ¥ä»–ç¤¾ã¨äº¤æµã—ã€ã‚¯ãƒ©ã‚¦ãƒ‰ã‚„AIãªã©ã«ã¤ã„ã¦æ„è¦‹ã‚’äº¤ã‚ã—ã¾ã—ã‚‡ã†ã€‚
tgk 2009/10/30
oracle

è¨è¨ˆ
ãƒªãƒ³ã‚¯
Oracleã®SQLãƒˆãƒ¬ãƒ¼ã‚¹ã®å–ã‚Šæ–¹ãŒåˆ†ã‹ã‚‰ãªã„
Q è³ªå• Oracleã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚SQLæ–‡ãŒåŽŸå› ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒæ‚ªããªã£ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ã€Œãƒˆãƒ¬ãƒ¼ã‚¹ã‚’å–ã£ã¦èª¿ã¹ã¦ã¿ã‚ã€ã¨è¨€ã‚ã‚Œã¾ã—ãŸãŒï¼Œã©ã†ã™ã‚Œã°è‰¯ã„ã®ã‹åˆ†ã‹ã‚Šã¾ã›ã‚“ A å›žç” ALTER SESSIONã§å–å¾—ã—ãŸçµ±è¨ˆæƒ…å ±ã‹ã‚‰ï¼Œã‚ãƒ£ãƒƒã‚·ãƒ¥ã®ãƒ’ãƒƒãƒˆçŽ‡ã‚„å®Ÿè¡Œè¨ˆç”»ãªã©ã‚’èª¿ã¹ã¾ã™ Oracleã®SQLãƒˆãƒ¬ãƒ¼ã‚¹æ©Ÿèƒ½ã‚’åˆ©ç”¨ã™ã‚‹ã¨ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§å®Ÿè¡Œã•ã‚ŒãŸãã‚Œãžã‚Œã®SQLæ–‡ã«ã¤ã„ã¦ï¼Œï¼ˆ1ï¼‰è§£æžï¼Œå®Ÿè¡Œï¼Œå–ã‚Šå‡ºã—ã®å›žæ•°ï¼Œï¼ˆ2ï¼‰CPUå‡¦ç†æ™‚é–“ã‚„çµŒéŽæ™‚é–“ï¼Œï¼ˆ3ï¼‰ç‰©ç†çš„ãªèªã¿è¾¼ã¿ã¨è«–ç†çš„ãªèªã¿è¾¼ã¿ã®ãƒ–ãƒãƒƒã‚¯æ•°ï¼Œï¼ˆ4ï¼‰å‡¦ç†ã—ãŸãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãªã©ãŒèª¿ã¹ã‚‰ã‚Œã¾ã™ã€‚ ãƒˆãƒ¬ãƒ¼ã‚¹ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã¯ï¼Œä¸»ã«2é€šã‚Šã‚ã‚Šã¾ã™ã€‚ä¸€ã¤ã¯ç¾è¡Œã‚»ãƒƒã‚·ãƒ§ãƒ³ã®ãƒˆãƒ¬ãƒ¼ã‚¹ã‚’å–ã‚‹æ–¹æ³•ï¼Œã‚‚ã†ä¸€ã¤ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹å…¨ä½“ã®ãƒˆãƒ¬ãƒ¼ã‚¹ã‚’å–ã‚‹æ–¹æ³•ã§ã™ã€‚ å‰è€…ã¯ï¼Œâ€œALTER SESSION SET sql_trace = trueâ€ã¨ã„ã†SQLæ–‡ã‚’å®Ÿ
tgk 2009/10/29
oracle
ãƒªãƒ³ã‚¯
ORA-00600 - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracle ã‚¨ãƒ©ãƒ¼ FAQ
ã‚«ãƒ†ã‚´ãƒªï¼šãã®ä»– ORA-00600: å†…éƒ¨ã‚¨ãƒ©ãƒ¼ãƒ»ã‚³ãƒ¼ãƒ‰ã€å¼•æ•°: [string] â€¦ ã‚µãƒãƒ¼ãƒˆã«å•ã„åˆã‚ã›ã‚‹ã‹ã€ãã®æ©Ÿèƒ½ã‚„ä½¿ç”¨æ–¹æ³•ã‚’ã‚„ã‚ã‚‹ã€‚ã®äºŒæŠžã§ã‚ã‚‹ã¨è¨€ã£ã¦ã‚‚éŽè¨€ã§ã¯ãªã„ã€‚ ã‚ã¨ã¯è¦‹ãªã‹ã£ãŸã“ã¨ã«ã—ã¦ã€å®¢å…ˆã§ã¯å‡ºãªã„ã“ã¨ã‚’ç¥ˆã‚‹ã¨ã„ã†é¸æŠžè‚¢ã‚‚çµæ§‹å¤šã„ï¼Ÿ ã‚‚ã—å‡ºã¦ã‚‚ ORA-00600 ã¯ä»•æ–¹ãŒç„¡ã„ã‚“ã§ã™ã¨ã‹ã€å†ç¾æ€§ãŒãªã‘ã‚Œã°ãŠã‹ã—ã„ã§ã™ãã¨é€ƒã’ã‚‹ãƒ»ãƒ»ãƒ» â€» ORA-600 ãŒå‡ºãŸã‹ã‚‰ã¨ã„ã£ã¦ã€ãã®å¤šããŒã‚ªãƒ©ã‚¯ãƒ«ã‚’ç„¡åœæ¢é‹ç”¨ã™ã‚‹ã“ã¨ã«è‡´å‘½çš„ãªã‚¨ãƒ©ãƒ¼ã§ã¯ãªã„ã®ã§ææ€–ã™ã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã›ã‚“ã€‚ Oracle ã‚’ä½¿ã†ãƒ‡ãƒ™ãƒãƒƒãƒ‘ã®ç«‹å ´ã§ã‚µãƒãƒ¼ãƒˆæƒ…å ±ãªã—ã«ã€ã“ã®ã‚¨ãƒ©ãƒ¼ã«ç›´æŽ¥å¯¾å‡¦ã™ã‚‹æ–¹æ³•ã¯ã»ã¨ã‚“ã©ãªã„ã€‚ ãã‚Œã¯ã€ã“ã®ã‚¨ãƒ©ãƒ¼ãŒ PL/SQL ã«ãŠã‘ã‚‹ OTHERS ä¾‹å¤–ã®ã‚ˆã†ãªã‚‚ã®ã§ã‚ã‚‹ã¨è€ƒãˆã‚‹ã¨ã‚ã‹ã‚Šã‚„ã™ã„ã€‚ ä¾‹å¤–å‡¦ç†ã§ãƒãƒ³ãƒ‰ãƒªãƒ³ã‚°ã•ã‚Œã¦ã„ã‚‹ã‚¨ãƒ©ãƒ¼ã¯ã€å›ºæœ‰ã®ã‚¨ãƒ©ãƒ¼ã‚³ãƒ¼ãƒ‰ã‚’ã‚‚ã£ã¦ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ãŒ OR
tgk 2009/10/26
ä¾‹å¤–å‡¦ç†ã§ãƒãƒ³ãƒ‰ãƒªãƒ³ã‚°ã•ã‚Œã¦ã„ã‚‹ã‚¨ãƒ©ãƒ¼ã¯ã€å›ºæœ‰ã®ã‚¨ãƒ©ãƒ¼ã‚³ãƒ¼ãƒ‰ã‚’ã‚‚ã£ã¦ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ãŒ ORA-00600 ã¯ã€ãã“ã§ã‚ãƒ£ãƒƒãƒã§ããªã‹ã£ãŸä¾‹å¤–ã®ç·ç§°ã¨ã—ã¦ç™ºç”Ÿã™ã‚‹ã‚‚ã®ã§ã‚ã‚‹

oracle
ãƒªãƒ³ã‚¯
ãªã«ã‚å¼åˆå¿ƒè€…ã§ã‚‚ã§ãã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
tgk 2009/10/24
tuning

oracle

é‹ç”¨
ãƒªãƒ³ã‚¯
Oracle
2025å¹´2æœˆ13æ—¥ã«æ±äº¬ã§é–‹å‚¬ã•ã‚Œã‚‹ã€ã‚ªãƒ©ã‚¯ãƒ«ã®ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ãŠã‚ˆã³ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚ãƒ³ã‚°ã‚¤ãƒ™ãƒ³ãƒˆã€ŒCloudWorld Tourã€ã«ãœã²ã”å‚åŠ ãã ã•ã„ã€‚ã‚ªãƒ©ã‚¯ãƒ«ã®ã‚¨ã‚°ã‚¼ã‚¯ãƒ†ã‚£ãƒ–ã‚„å°‚é–€å®¶ã€ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã€åŒæ¥ä»–ç¤¾ã¨äº¤æµã—ã€ã‚¯ãƒ©ã‚¦ãƒ‰ã‚„AIãªã©ã«ã¤ã„ã¦æ„è¦‹ã‚’äº¤ã‚ã—ã¾ã—ã‚‡ã†ã€‚
tgk 2009/10/21
GUIã§9æ¡ä»¥ä¸Šã®ã‚µãƒ¼ãƒ“ã‚¹åã‚’è¨å®šã§ããªã„ã‚‰ã—ã„

oracle
ãƒªãƒ³ã‚¯
ï¼ ITï¼šDatabaseãƒ•ã‚©ãƒ¼ãƒ©ãƒ å…¨è¨˜äº‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€€ã‚ªãƒ©ã‚¯ãƒ«ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°
Databaseãƒ•ã‚©ãƒ¼ãƒ©ãƒ ã«æŽ²è¼‰ã•ã‚Œã¦ã„ã‚‹å…¨è¨˜äº‹ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§ã™ã€‚ã¾ãŸã€ï¼ ITã®å„ãƒ•ã‚©ãƒ¼ãƒ©ãƒ ã«ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–¢é€£è¨˜äº‹ã‚‚æŽ²è¼‰ã—ã¦ã„ã¾ã™ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯è¨˜äº‹ã®è¿½åŠ ã¨ã¨ã‚‚ã«æ‹¡å……ã—ã¦ã„ãã¾ã™ã€‚
tgk 2009/10/19
oracle
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸