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

Kiske id:Kiske

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

${{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 ã® B*Tree ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®å†…éƒ¨æ§‹é€ ã«ã¤ã„ã¦ãŠå‹‰å¼·ä¸ï¼ˆãã®ï¼‘ï¼‰
ãŠä»•äº‹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸€å¼ã®ãƒªãƒ¼ã‚¹åˆ‡ã‚Œé–“è¿‘ã¨ã„ã†ã“ã¨ã§ã€ãƒªãƒ¼ã‚¹å»¶é•·ã§è€ãˆã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã‹ã€ãã‚Œã¨ã‚‚ã‚·ã‚¹ãƒ†ãƒ æ›´æ”¹ãŒå¿…è¦ãªã®ã‹ã‚’è¦‹æ¥µã‚ã‚‹ãŸã‚ã€æœ€è¿‘ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‘¨ã‚Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã°ã‹ã‚Šã‚„ã£ã¦ã¾ã™ã€‚ å½“åˆè¨è¨ˆæ™‚ã«ã€ï¼•å¹´é–“æŒã¤è¨è¨ˆã‚’ã—ãŸã®ã§ã™ãŒã€æµçŸ³ã«ï¼•å¹´ç›®ã«ã‚‚ãªã‚‹ã¨äºˆå®šã¨ã¯ãã‚Œãªã‚Šã«ä¹–é›¢ãŒç™ºç”Ÿã™ã‚‹ã‚‚ã®ã§ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ï¼†ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¨è¨ˆã‚’ãƒ¦ãƒ¼ã‚¶å‘ã‘ã®å‡¦ç†ã‚’ã¨ã«ã‹ãé«˜é€Ÿã«å‡¦ç†ã§ãã‚‹ã‚ˆã†ã«è¨è¨ˆã—ãŸã®ã§ã€ãƒ¦ãƒ¼ã‚¶å‘ã‘ã®å‡¦ç†ã¯é€Ÿåº¦çš„ã«å…¨ç„¶å¤§ä¸ˆå¤«ãªã®ã§ã™ãŒã€ãƒ‡ãƒ¼ã‚¿ã®è‚¥å¤§åŒ–ã«ã‚ˆã‚‹ãƒãƒƒãƒå‡¦ç†ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹åŠ£åŒ–ãŒé¡•è‘—ã§ã™ã€‚å˜ç´”ã«ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¨ CPU ãƒ‘ãƒ¯ãƒ¼ãŒè¶³ã‚Šã¦ã„ãªã„ã®ã§ã—ã‚‡ã†ã€‚ ã—ã‹ã—ãªãŒã‚‰ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ä½™åœ°ã¯ã¾ã ã¾ã ååˆ†ã«ã‚ã‚Šãã†ã§ã™ã€‚ãƒãƒƒãƒå‘ã‘ã®æœ€é©åŒ–ã‚’å›³ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ã†ã¾ãã„ã‘ã°æ¥å¹´åº¦ã©ã“ã‚ã‹ã€å¾Œæ•°å¹´ã¯ãƒªãƒ¼ã‚¹å»¶é•·ã§å»¶å‘½ã§ãã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ä»Šå›žå®Ÿæ–½ã—ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ï¼‘ã¤ã®ãƒã‚¤ãƒ³ãƒˆã¨ã—ã¦ã€ãƒãƒƒãƒå‡¦ç†å‘
Kiske 2009/11/10
oracle
ãƒªãƒ³ã‚¯
Oracle Technology Network: Recent Articles
All Blogs Corporate Site CRM On Demand Discussion Forums Documentation Education Java.com JavaOne and Oracle Develop MySQL Oracle OpenWorld PartnerNetwork Sun Defects Techno logy Network Video and Multimedia
Kiske 2008/07/14
php

symfony

oracle
ãƒªãƒ³ã‚¯
ã‚¹ãƒ†ãƒƒãƒ—ã‚¢ãƒƒãƒ— Oracle
Oracleã¯SQLã‚’ç™ºè¡Œã™ã‚‹ã¨ãã«ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’åˆ©ç”¨ã—ã¦åŠ¹çŽ‡ã‚’é«˜ã‚ã‚ˆã†ã¨ã—ã¾ã™ãŒã€SQLæ–‡ãŒåŒã˜æ„å‘³ã§ã‚‚ã€ã‚¹ãƒšãƒ¼ã‚¹ã®ä½ç½®ã‚„å¤§æ–‡å—å°æ–‡å—ãŒé•ã£ãŸã ã‘ã§ã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ’ãƒƒãƒˆã—ã¾ã›ã‚“ã€‚SQLã‚’è¨˜è¿°ã™ã‚‹ã¨ãã¯ãƒ«ãƒ¼ãƒ«ã‚’å¾¹åº•ã—ã¦ã€åŒã˜SQLæ–‡ã§ã‚ã‚Œã°ä¸€æ–‡å—ã‚‚é•ã‚ãªã„ã‚ˆã†ã«ãªã‚‹ã‚ˆã†ã«ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ä»¥ä¸‹ã®SQLã¯ã™ã¹ã¦é•ã†SQLã¨ã—ã¦æ‰±ã‚ã‚Œã€ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’åˆ©ç”¨ã§ãã¾ã›ã‚“ã€‚ select id from emp; SELECT ID FROM EMP; SELECT ID FROM EMP ; SELECT ID FROM EMP; ãƒ«ãƒ¼ãƒ«2ï¼šã€€SELECT * ã¯åˆ©ç”¨ã—ãªã„ã€‚åˆ—åã‚’ãã¡ã‚“ã¨è¨˜è¿°ã™ã‚‹ã€‚ SELECT * ã¯ä¸è¦ãªåˆ—ã¾ã§å‡¦ç†ã—ã¦ã—ã¾ã„ã¾ã™ã€‚ãã¡ã‚“ã¨åˆ—åã‚’è¨˜è¿°ã—ãŸã»ã†ãŒã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯è‰¯ããªã‚Šã¾ã™ã€‚ Ã—SELECT * FROM EMP; â—‹SELECT ID, NAME FROM EMP;
Kiske 2007/07/25
oracle
ãƒªãƒ³ã‚¯
Oracleã§ã¯Limitå¥ãŒä½¿ãˆãªã„
ãƒšãƒ¼ã‚¸ãƒ³ã‚°ã§Selectçµæžœã®ä¸€éƒ¨ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã—ãŸã„ã¨ãã€PostgreSQLã‚„MySQLã§ä½¿ç”¨ã§ãã‚‹Limitå¥ã¯ã¨ã¦ã‚‚ä¾¿åˆ©ã€‚ãŸã¨ãˆã°Selectçµæžœã®10ã‹ã‚‰14ç•ªç›®ã¾ã§ã‚’å–å¾—ã™ã‚‹ã«ã¯select * from emp where Limit 10,5ã§ã‚‚Oracleã§ã¯Limitå¥ã¯ä½¿ãˆãªã„... ã¨ã„ã†ã“ã¨ã§Oracleã§ã¯ROWNUMã‚’ä½¿ç”¨ã—ã¦ã‚„ã£ã¦ã¿ã‚‹ã€‚(Oracle10g Windowsç‰ˆã§æ¤œè¨¼) ã¨ã“ã‚ãŒã“ã®ROWNUMã¯ä¸€ç‹ç¸„ã§ã¯ã„ã‹ãªã„ã®ã§ã‚ã£ãŸã€‚ Order By å¥ã‚’ä½¿ã£ã¦ä¸¦ã¹æ›¿ãˆã‚’ã™ã‚‹ã¨ã€ROWNUMãŒ...select rownum rn ,t.ä½æ‰€ã‚³ãƒ¼ãƒ‰ ,t.å¸‚åŒºç”ºæ‘å ,t.ä½æ‰€1 ,t.ä½æ‰€2 from tb_ä½æ‰€ãƒžã‚¹ã‚¿ t order by ä½æ‰€2;çµæžœ RNä½æ‰€ã‚³ãƒ¼ãƒ‰å¸‚åŒºç”ºæ‘åä½æ‰€1ä½æ‰€2
Kiske 2007/04/17
oracle

sql
ãƒªãƒ³ã‚¯
Absolute Playingï¼ - PHP+Oracleã®æŠ½è±¡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ¬ã‚¤ãƒ¤
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ©ãƒƒãƒ‘ãƒ¼ä½œã£ã¦ã€ã¨è¨€ã‚ã‚ŒãŸã®ã§ã¡ã‚‡ã£ã¨èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ ç’°å¢ƒã¯PHP5.2.0+Oracle XEã§ã™ã€‚ çµè«–ã‹ã‚‰è¨€ã†ã¨ADOdbãŒãƒ™ã‚¹ãƒˆã¨æ€ã„ã¾ã™ã€‚ ä»¥ä¸‹ã€ç†ç”±ã§ã™ã€‚ ï¼ˆãã“ãã“ï¼‰æ—©ã„ è‡ªåˆ†ã§æ¤œè¨¼ã—ã¦ã„ãªã„ã§ã™ãŒã€ã‚¯ã‚¨ãƒªã¯æ—©ã„ãã†ã§ã™ã€‚ ï¼‘äººã§ç¨¼ãæ—¥è¨˜ | PHPï¼šADODBã‚’ä½¿ãŠã†ã€€ãã®ï¼‘ï¼šé€Ÿåº¦æ¤œè¨¼ ã“ã£ã¡ã®è¨˜äº‹ã ã¨é…ã„ã‚“ã§ã™ãŒã©ã£ã¡ãŒæ£ã—ã„ã®ã‚„ã‚‰ã€‚ zuzara : PHP5.1.0RC1ã§PDOã¨ADODBã€PEAR::DBã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ï¼ˆPostgreSQL&MySQLï¼‰ Oracleã¸ã®å¯¾å¿œåº¦ãŒè‰¯ã„ Oracleãƒ‰ãƒ©ã‚¤ãƒã‚ˆã‚Šã‚‚å¤šãã®æ©Ÿèƒ½ã‚’ã‚‚ã£ã¦ã„ã‚‹ãã†ã§ã™ï¼ˆä¾‹ãˆã°Affected_Rowsï¼‰ã€‚ REF CURSORã‚„ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚‚å•é¡Œç„¡ãä½¿ãˆã‚‹ã®ãŒãƒ‡ã‚«ã„ã€‚ PDOã‚„Propelã¯ãã‚ŒãŒå‡ºæ¥ãªã‹ã£ãŸã‹ã‚‰è«¦ã‚ã¾ã—ãŸã€‚ æ©Ÿèƒ½ãŒè±Šå¯Œ Debugã—ãŸã‚Šã€C
Kiske 2007/04/12
php

oracle

database

adodb
ãƒªãƒ³ã‚¯
OCI8æ‹¡å¼µãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ãƒ†ã‚¹ãƒˆæ–¹æ³• - Do You PHP ã¯ã¦ãƒ–ãƒ
ã‚ã¾ã‚Šãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆåŒ–ã•ã‚Œã¦ã„ãªã„æ°—ãŒã—ã¾ã™ãŒã€Christopher Jonesæ°ã®ã‚µã‚¤ãƒˆã§ã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ The PHP source code includes tests for all the core functionality and extensions. You should run the tests after building PHP. ï¼š You should also strongly consider contributing tests to the PHP community. Adding tests that are relevant to your application minimizes the risks of PHP developers breaking PHP features important to you. OracleXEã‚’ä½¿
Kiske 2007/04/11
oracle

php
ãƒªãƒ³ã‚¯
http://oldblog.xenophy.com/comments.php?y=06&m=12&entry=entry061204-044101
Kiske 2007/04/09
oracle

tips
ãƒªãƒ³ã‚¯
PL/SQLã‚’ä½¿ã„ã“ãªã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†
ORACLE MASTERè³‡æ ¼ã®ä¸ç´šã«ä½ç½®ä»˜ã‘ã‚‰ã‚Œã€å–å¾—ã™ã‚Œã°Oracle æŠ€è¡“è€…ã¨ã—ã¦ã‚°ãƒãƒ¼ãƒãƒ«ã«èªå®šã•ã‚Œã‚‹ã€ŒORACLE MASTER Silver Oracle Database 10gã€ã€‚ä¾‹é¡Œã‚’åˆ©ç”¨ã—ã¦ãƒã‚¤ãƒ³ãƒˆã‚’æŠ¼ã•ãˆã€ç¢ºå®Ÿãªåˆæ ¼ã‚’ç›®æŒ‡ãã†ï¼ æœ¬é€£è¼‰ç¬¬9å›žã€ŒSQLã§ã®ãƒ‡ãƒ¼ã‚¿æ“ä½œæ–¹æ³•ã‚’è¦šãˆã‚ˆã†ã€ã€ç¬¬10å›žã€ŒData Pumpã¨SQL*Loaderã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ã®ãƒãƒ¼ãƒ‰ã€ã§ã€ãƒ‡ãƒ¼ã‚¿ã®ç®¡ç†æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ä»Šå›žã¯PL/SQLã«ã¤ã„ã¦å¦ã³ã¾ã™ã€‚ PL/SQL ãƒã‚¤ãƒ³ãƒˆ PL/SQLã‚’ä½¿ç”¨ã—ãŸãƒ—ãƒã‚°ãƒ©ãƒ æ§‹é€ ä½“ï¼ˆãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã€ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ã€ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã€ãƒˆãƒªã‚¬ãƒ¼ï¼‰ãŒå¯¾è±¡ã§ã™ã€‚è©³ç´°ãªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãŒå¯¾è±¡ã¨ãªã‚‹ã‚ã‘ã§ã¯ãªãã€ãƒ—ãƒã‚°ãƒ©ãƒ æ§‹é€ ä½“ã®ä½¿ã„åˆ†ã‘æ–¹ã‚„ã€é–¢é€£ã™ã‚‹è¨å®šã«ã¤ã„ã¦ãŒå¯¾è±¡ã¨ãªã£ã¦ã„ã¾ã™ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒ æ§‹é€ ä½“ PL/SQLï¼ˆProcedure Language/Structured Query
Kiske 2007/04/04
[pl/sql]

oracle

database

tips

sql
ãƒªãƒ³ã‚¯
Do You PHP ã¯ã¦ãª - oci_pconnectã®ç¬¬4å¼•æ•°ã‚’æŒ‡å®šã™ã‚‹ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å‘ä¸Š
Oracle9.2ä»¥é™ã‚’ä½¿ã£ã¦ã„ã‚‹å ´åˆã€oci_pconnectã®ç¬¬4å¼•æ•°ã«ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã‚’æŒ‡å®šã§ãã¾ã™ï¼ˆ9.2ä»¥å‰ã®å ´åˆã€ç’°å¢ƒå¤‰æ•°NLS_LANGãŒä½¿ã‚ã‚Œã‚‹ï¼‰ãŒã€ã“ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’æŒ‡å®šã™ã‚‹ã¨ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒå‘ä¸Šã™ã‚‹ã¨ã®ã“ã¨ã€‚ I used AL32UTF8 which is the character set of the Oracle XE "Universal" database I have. Testing with the database and PHP both on my little old machine I was getting figures like 0.6 vs 2.7 seconds for 50,000 pconnect calls in the one script. I saw some other results that showed only
Kiske 2007/03/30
oracle

php
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
Kiske 2007/03/28
ã‹ãªã‚Šç´°ã‹ã„æ‰€ã¾ã§èª¬æ˜ŽãŒã—ã¦ã‚ã£ã¦ã‚ã‹ã‚Šã‚„ã™ã„

oracle

tips
ãƒªãƒ³ã‚¯
Oracleï¼Œç„¡å„Ÿã®Webã‚¢ãƒ—ãƒªæ§‹ç¯‰ãƒ„ãƒ¼ãƒ«ã®æ–°ç‰ˆã€ŒApplication Express Release 3.0ã€ã‚’å…¬é–‹
Oracleï¼Œç„¡å„Ÿã®Webã‚¢ãƒ—ãƒªæ§‹ç¯‰ãƒ„ãƒ¼ãƒ«ã®æ–°ç‰ˆã€ŒApplication Express Release 3.0ã€ã‚’å…¬é–‹ ç±³Oracleã¯ç±³å›½æ™‚é–“3æœˆ26æ—¥ï¼Œç„¡å„Ÿã®Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹ç¯‰ãƒ„ãƒ¼ãƒ«ã®æ–°ç‰ˆã€ŒOracle Application Express Release 3.0ã€ã‚’å…¬é–‹ã—ãŸã€‚æ–°ç‰ˆã¯ï¼ŒPDFå½¢å¼ã®å°åˆ·ãªã©ã„ãã¤ã‹ã®æ–°æ©Ÿèƒ½ã‚’è¿½åŠ ã™ã‚‹ã¨ã¨ã‚‚ã«ï¼Œã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ»ãƒ‡ã‚¶ã‚¤ãƒ³ï¼Œã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ï¼ŒWebã‚µãƒ¼ãƒ“ã‚¹æ©Ÿèƒ½ãªã©ã‚’å¼·åŒ–ã—ãŸã€‚ Application Expressã¯ï¼ŒWebãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºãƒ„ãƒ¼ãƒ«ã€‚ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°çµŒé¨“ã®æµ…ã„ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ã‚‚ï¼Œãƒ–ãƒ©ã‚¦ã‚¶ã‚’ä½¿ã£ã¦ç°¡å˜ã«å®‰å…¨ã§æ‹¡å¼µå¯èƒ½ãªWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ§‹ç¯‰ã‚„ç®¡ç†ãŒã§ãã‚‹ã¨ã„ã†ã€‚ æ–°ç‰ˆã§ã¯ï¼ŒPDFå½¢å¼ã®ãƒ¬ãƒãƒ¼ãƒˆãŒå°åˆ·ã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ãã®ã»ã‹ï¼ŒWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã‚¤ãƒ³ã‚¿ãƒ©ã‚¯ãƒ†ã‚£ãƒ–ãªFlashãƒãƒ£ãƒ¼ãƒˆã‚’çµ„ã¿è¾¼ã‚ã‚‹ã‚ˆã†ã«ã—ï¼ŒMi
Kiske 2007/03/28
ãã®ã†ã¡ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ã‚ã£ã¦è¨€ã‚ã‚Œãã†ãªäºˆæ„Ÿ

oracle

tool
ãƒªãƒ³ã‚¯
Oracle 10.2.0.1 Instant Client ã®è‡´å‘½çš„ãƒã‚° â†’ 248æ—¥ç›®ã« hang ã—ã¾ã™
ã„ããªã‚Šçµè«–ã€‚ã‚¿ã‚¤ãƒˆãƒ«é€šã‚Š Oracle 10.2.0.1 Instant Client ã¯ OS èµ·å‹•å¾Œ 248 æ—¥ã§ãƒãƒ³ã‚°ã—ã¾ã™ã€‚64 bit ç’°å¢ƒãªã‚‰ 198 æ—¥ã§ãƒãƒ³ã‚°ã—ã¾ã™ã€‚ã—ãŸãŒã£ã¦ã€Instant Client ã‚’ä½¿ã†ã‚µãƒ¼ãƒ“ã‚¹ã¯å…¨ã¦ãƒãƒ³ã‚°ã—ã¾ã™ã€‚ã“ã‚Œã«ã‚ˆã‚Šã€RAC ã‚’åˆ¶å¾¡ã™ã‚‹ ons ã¨ã„ã†ã‚µãƒ¼ãƒ“ã‚¹ã‚‚ãƒãƒ³ã‚°ã—ã¦ Oracle 10g RAC ã«ä¸å…·åˆãŒç™ºç”Ÿã—ã¾ã™ã€‚ ä»¥ä¸‹è©³ç´°ã€‚ ã¤ã„æœ€è¿‘ã®ã“ã¨ã§ã™ãŒä»•äº‹ã®æœ¬ç•ª DB ã§éšœå®³ãŒç™ºç”Ÿã—ã¾ã—ãŸã€‚Oracle 10g R2 ã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€10g R2 ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸç›´å¾Œã«ã„ã‚ŒãŸ Oracle 10g RAC ã‚·ã‚¹ãƒ†ãƒ ã§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 10.2.0.1 ã¨ãªã£ã¦ã„ã¾ã—ãŸã€‚ã‚ã‚‹æ—¥å‡ºç¤¾ã—ã¦ã¿ã‚‹ã¨Oracle 10g ã®ç›£è¦–ã«ä½¿ã£ã¦ã„ã‚‹ Insight Techno logy ç¤¾ã®Performance Insight ã‹ã‚‰å±±ã®ã‚ˆã†ãª w
Kiske 2007/03/27
ã“ã‚Œã¯ã²ã©ã„ï½—

oracle

database
ãƒªãƒ³ã‚¯
Road to Oracle Master ï½žã‚ªãƒ©ã‚¯ãƒ«ãƒ»ãƒžã‚¹ã‚¿ãƒ¼ã¸ã®é“
ã“ã®ãƒšãƒ¼ã‚¸ã¯ãƒ•ãƒ¬ãƒ¼ãƒ ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ã€‚<BR> ãƒ•ãƒ¬ãƒ¼ãƒ æœªå¯¾å¿œã®ãƒ–ãƒ©ã‚¦ã‚¶ã‚’ãŠä½¿ã„ã®æ–¹ã¯ <A HREF="index.html">ã“ã¡ã‚‰ã¸</A>ã©ã†ãžã€‚<BR>
Kiske 2007/03/23
oracle
ãƒªãƒ³ã‚¯
Oracleã§AutoIncrement - (ãƒ»âˆ€ãƒ»)ã‚¤ã‚¤!!Memo
Oracleã§MySQLã®auto_incrementã‚’å®Ÿç¾ã™ã‚‹æ–¹æ³•ã€‚å›žã‚Šãã©ã„ã€‚ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¯DBã¨ã‚¢ãƒ—ãƒªã¨ã®ãƒ¬ã‚¤ãƒ¤ãƒ¼ã®å¢ƒç›®ãŒã‚ã‹ã‚Šã«ãããªã‚‹ã‹ã‚‰ å€‹äººçš„ã«å«Œã„ãƒ½(`Ð”Â´)ï¾‰ create table test (id number, testdata varchar2(255)); create sequence test_seq start with 1 increment by 1 nomaxvalue; create trigger test_trigger before insert on test for each row begin select test_seq.nextval into :new.id from dual; end; / :Category/Oracle
Kiske 2007/03/09
oracle

sql

tips
ãƒªãƒ³ã‚¯
Welcome to jurapun.com
Kiske 2007/03/02
oracle

tips
ãƒªãƒ³ã‚¯
PHPï¼‹Oracle Instant Clientã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - Do You PHP?
PHPï¼‹Oracle Instant Clientã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« å…ˆæ—¥ä½•æ°—ãªãPHPãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã®OCI8ãƒšãƒ¼ã‚¸ã‚’è¦‹ã¦ã„ã‚‹ã¨ã€ä½•ã‚„ã‚‰è¦‹æ…£ã‚Œãªã„ã€Œ--with-oci8-instant-clientã€ã®æ–‡å—ãŒã€‚ã€‚ã€‚ã‚ˆãè¦‹ã¦ã¿ã‚‹ã¨ã€ã€ŒOracle Instant Clientã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹å ´åˆã¯--with-oci8-instant-clientã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ä½¿ã„ã¾ã—ã‚‡ã†ã€ã ã¨ã€‚ã†ãƒ¼ã‚“ã€‚ã€‚ã€‚Oracle10gãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã—ã°ã‚‰ãçµŒã¡ã¾ã™ãŒã€ã„ã¤ã®é–“ã«ã‹ç„¡å„Ÿã§Oracle Instant Clientãªã‚‹ã‚‚ã®ã‚’é…å¸ƒã—ã¦ã„ãŸã‚ˆã†ã§ã™ã€‚Oracleã‚‚å¤‰ã‚ã‚Šã¾ã—ãŸãã€‚ã€‚ã€‚ã¾ãŸã€PHP4.3.11/5.0.4ã‹ã‚‰æ£å¼ã«ã‚µãƒãƒ¼ãƒˆã•ã‚Œã‚‹ã‚ˆã†ã§ã™ã€‚ PHP5.0.4-devã§ã‚‚åŒæ§˜ã«å‹•ä½œç¢ºèªãŒã§ãã¾ã—ãŸã€‚configureã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¯åŒã˜ã§ã™ã€‚ PHP5.1.2ã‹ã‚‰ã€Œ--with-oci8=instantc
Kiske 2007/02/23
php

oracle
ãƒªãƒ³ã‚¯
Oracle10gã§ã®SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - Do You PHP ã¯ã¦ãƒ–ãƒ
ä»Šä½³å¢ƒã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«çªã£è¾¼ã¾ã‚Œã¦ã„ã¦ã€å¤–éƒ¨ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã•ã‚“ãŒä½œã£ãŸSQLã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã„ã‚‹ã®ã§ã™ãŒã€ä»Šå›žã€Œãˆï¼Ÿãã†ãªã®ï¼Ÿã€ã¨æ€ã£ãŸã“ã¨ãŒã‚ã£ãŸã®ã§ãƒ¡ãƒ¢ã€‚ã©ã†ã›æ¬¡ã«ã‚„ã‚‹ã¨ãã«ã¯ã€ã¾ãŸå¿˜ã‚Œã¦ã‚‹ã‚“ã§ã€‚ã€‚ã€‚(^^; ç’°å¢ƒã¯ Oracle 10g Release2 Standard Edition ã‚³ã‚¹ãƒˆãƒ™ãƒ¼ã‚¹ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ ANALYZE TABLE ... SAMPLE 30 PERCENT ãªæ„Ÿã˜ã§ã™ã€‚ ORæ¡ä»¶ã‚’REGEXP_LIKEé–¢æ•°ã«å¤‰æ›´ã™ã‚‹ å½“ç„¶indexã®çŠ¶æ…‹ã‚„å¼ãªã©ãƒ¢ãƒŽã«ã‚ˆã£ã¦ã‚‚å¤‰ã‚ã‚Šã¾ã™ãŒã€ä»Šå›žã€Œè¤‡æ•°ã‚«ãƒ©ãƒ ã®å€¤ã«å¯¾ã™ã‚‹è¤‡æ•°ã®ORæ¡ä»¶ã€ã‚’REGEXP_LIKEé–¢æ•°ã«å¤‰æ›´ã™ã‚‹ã¨ã‹ãªã‚Šã‚³ã‚¹ãƒˆãŒå¤‰ã‚ã‚Šã¾ã—ãŸã€‚ä»¥ä¸‹ã§ã€valAã€valBã€valCã¯åŒã˜SQLå†…ã®åˆ¥ã‚¹ãƒˆã‚¢ãƒ‰é–¢æ•°ã§ç®—å‡ºã•ã‚ŒãŸå€¤ã§1ã€œ5ã§ã™ã€‚ â– ä½¿ç”¨å‰ WHERE (valA != '1' OR valB != '3' O
Kiske 2007/01/15
php

oracle

sql

tips

programming
ãƒªãƒ³ã‚¯
http://www.powerdee.com/it/database/oracle.html
Kiske 2006/10/31
oracle

database
ãƒªãƒ³ã‚¯
Oracle Instant Client ã‚’ä½¿ã£ã¦ PHP ã‚’ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«
PHP ã¯ --with-oci8 ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ã¦ configure ã™ã‚‹ã“ã¨ã§ã€Oracle ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šé–¢æ•°ã‚’ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ã¨ã“ã‚ãŒã€--with-oci8 ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ã¦ãƒ“ãƒ«ãƒ‰ã™ã‚‹ãŸã‚ã«ã¯ã€Oracle Client ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚Linux ã« Oracle Client ã‚’å…¥ã‚Œã‚Œã°è‰¯ã„ã®ã§ã™ãŒã€OracleInstaller ãŒ X Window å¿…é ˆã§ã™ã—ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ç”¨ãƒ¦ãƒ¼ã‚¶ã‚’ä½œã£ãŸã‚Šãªã©ã€çµæ§‹æ‰‹é–“ãŒã‹ã‹ã‚Šã¾ã™ã€‚ å‰å›žã€Oracle Instant Client ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹è¨˜äº‹ã‚’æ›¸ãã¾ã—ãŸãŒã€PHP ã‹ã‚‰ã“ã‚Œã‚’åˆ©ç”¨ã—ã¦ã¿ã¾ã™ã€‚ä»Šå›žä½¿ç”¨ã—ãŸã®ã‚‚ RHEL äº’æ›ã® WhiteBox Linux 3 ã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã¯ Windows 2000 Server + Oracle 8i (8.1.7.4) ã§ã™ã€‚ PH
Kiske 2006/09/19
php

oracle
ãƒªãƒ³ã‚¯
http://www.oracle.com/technology/pub/articles/php_experts/otn_pdo_oracle5.html
Kiske 2006/09/14
PDOã§ã¯REF-CURSORä½¿ãˆãªã„ã¿ãŸã„

pdo

php

oracle
ãƒªãƒ³ã‚¯
1