[B! lob] dannã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

dann id:dann

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

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ‹¡å¼µæ©Ÿèƒ½
23 ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ‹¡å¼µæ©Ÿèƒ½ ã“ã®ç« ã§ã¯ã€Java Database Connectivity(JDBC)æ¨™æº–ã«å¯¾ã™ã‚‹Oracleãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ‹¡å¼µæ©Ÿèƒ½ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ã“ã®ç« ã®å†…å®¹ã¯æ¬¡ã®ã¨ãŠã‚Šã§ã™ã€‚ ãƒãƒƒãƒæ›´æ–° ãã®ä»–ã®Oracleãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ‹¡å¼µæ©Ÿèƒ½ ãƒãƒƒãƒæ›´æ–° è¤‡æ•°ã®UPDATEæ–‡ã€DELETEæ–‡ã¾ãŸã¯INSERTæ–‡ã‚’å˜ä¸€ã®ãƒãƒƒãƒã«ã‚°ãƒ«ãƒ¼ãƒ—åŒ–ã—ã¦ã€ãƒãƒƒãƒå…¨ä½“ã‚’ä¸€åº¦ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é€ä¿¡ã—ã¦å‡¦ç†ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ãƒ©ã‚¦ãƒ³ãƒ‰ãƒˆãƒªãƒƒãƒ—ã®å›žæ•°ã‚’æ¸›ã‚‰ã—ã€ãã‚Œã«ã‚ˆã£ã¦ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã“ã‚Œã¯ã€ãƒãƒƒãƒæ›´æ–°(update batching)ã¨å‘¼ã°ã‚Œã¾ã™ã€‚
dann 2012/01/14
setLobPrefetchSize

oracle

lob
ãƒªãƒ³ã‚¯
Storage Faster Safer LOB 11g | PDF | Oracle Database | Databases
dann 2011/03/01
oracle

securefile

lob
ãƒªãƒ³ã‚¯
Oracle Secure File (securefile) tips
dann 2011/03/01
oracle

securefile

lob
ãƒªãƒ³ã‚¯
Oracle Advanced Compression with Oracle Database 12c
dann 2011/03/01
oracle

securefile

lob

cool
ãƒªãƒ³ã‚¯
Using SecureFiles on a Sun Storage 6780 Array
dann 2011/02/28
oracle

securefile

lob

performance
ãƒªãƒ³ã‚¯
Oracle |ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ»ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ»ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ
æ—¥æœ¬ã®ã‚ªãƒ©ã‚¯ãƒ«ãƒ»ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãŒä¸€å ‚ã«ä¼šã™ã‚‹ãƒ—ãƒ¬ãƒŸã‚¢ãƒ»ã‚¤ãƒ™ãƒ³ãƒˆã«ãœã²ã”å‚åŠ ãã ã•ã„ã€‚æ–°ã—ã„ã‚¹ã‚ãƒ«ã‚’èº«ã«ä»˜ã‘ã€æ¥ç•Œã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã¨äº¤æµã—ã€è¤‡é›‘ãªãƒ“ã‚¸ãƒã‚¹èª²é¡Œã‚’è§£æ±ºã™ã‚‹ãŸã‚ã®ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç™ºè¦‹ã—ã¾ã—ã‚‡ã†ã€‚
dann 2011/02/28
sdu, tdu

oracle

lob
ãƒªãƒ³ã‚¯
Securefile Logging Confusion
dann 2011/02/28
oracle

securefile

lob
ãƒªãƒ³ã‚¯
Oracle SecureFiles LOBã®ä½¿ç”¨
4 Oracle SecureFiles LOBã®ä½¿ç”¨ ã“ã®ç« ã§ã¯ã€å…ƒã®BasicFiles LOBå®Ÿè£…ã‚’æ‹¡å¼µã™ã‚‹ã‚‚ã®ã¨ã—ã¦å°Žå…¥ã•ã‚ŒãŸSecureFiles LOBã®ä½¿ç”¨æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ã“ã®ç« ã®å†…å®¹ã¯æ¬¡ã®ã¨ãŠã‚Šã§ã™ã€‚ SecureFiles LOBã«ã¤ã„ã¦ SecureFiles LOBã‚’å«ã‚“ã CREATE TABLEã®ä½¿ç”¨ SecureFiles LOBã‚’å«ã‚“ã ALTER TABLEã®ä½¿ç”¨ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ãƒ»ãƒªãƒ³ã‚¯ SecureFiles LOBã®åˆæœŸåŒ–ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿db_securefile äº’æ›æ€§ãŠã‚ˆã³ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ BasicFiles LOBã‹ã‚‰SecureFiles LOBã¸ã®åˆ—ã®ç§»è¡Œ SecureFiles LOBãŠã‚ˆã³DBFSç”¨ã®PL/SQLãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ SecureFiles LOBã«ã¤ã„ã¦ Oracle Database 11gãƒªãƒªãƒ¼ã‚¹1ä»¥é™ã€æ–°ã—ã„L
dann 2011/02/28
"FILESYSTEM_LIKE_LOGGINGè¨å®šã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ“ä½œä¸ã«ãƒ‡ãƒ¼ã‚¿ãŒãƒ‡ã‚£ã‚¹ã‚¯ã§å¤‰æ›´ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã€èªå–ã‚Šéžä¸€è²«æ€§ãŒç™ºç”Ÿã—ã¾ã™ã€‚"

oracle

lob
ãƒªãƒ³ã‚¯
Oracle |ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ»ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ»ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ
æ—¥æœ¬ã®ã‚ªãƒ©ã‚¯ãƒ«ãƒ»ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãŒä¸€å ‚ã«ä¼šã™ã‚‹ãƒ—ãƒ¬ãƒŸã‚¢ãƒ»ã‚¤ãƒ™ãƒ³ãƒˆã«ãœã²ã”å‚åŠ ãã ã•ã„ã€‚æ–°ã—ã„ã‚¹ã‚ãƒ«ã‚’èº«ã«ä»˜ã‘ã€æ¥ç•Œã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã¨äº¤æµã—ã€è¤‡é›‘ãªãƒ“ã‚¸ãƒã‚¹èª²é¡Œã‚’è§£æ±ºã™ã‚‹ãŸã‚ã®ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç™ºè¦‹ã—ã¾ã—ã‚‡ã†ã€‚
dann 2011/02/28
oracle

securefile

lob
ãƒªãƒ³ã‚¯
Using Oracle SecureFiles
dann 2011/02/28
FILESYSTEM_LIKE_LOGGING

oracle

lob
ãƒªãƒ³ã‚¯
https://www.oracle.com/technetwork/jp/database/securefiles-1-131703-ja.pdf
dann 2011/02/28
secure file

oracle

lob

cool
ãƒªãƒ³ã‚¯
11g and the new SecureFILE LOB data type (simple quick test)
dann 2011/02/28
securefile,11g

oracle

lob

securefile
ãƒªãƒ³ã‚¯
Slide 1
<Insert Picture Here> Oracle Direct Seminar ç”»åƒãƒ»ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚‚DBã§ç®¡ç†ã™ã‚‹ ï½ž LOBå–ã‚Šæ‰±ã„èª¬æ˜Žæ›¸ ï½ž æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«æ ªå¼ä¼šç¤¾ CopyrightÂ© 2010, Oracle. All rights reserved. 2 Agenda â€¢ LOBæ¦‚è¦ â€¢ Oracle Database ã®LOB â€¢ LOBã®ç®¡ç† â€¢ LOBã®æ“ä½œ â€¢ LOBã‚’æ‰±ã†ä¸Šã§ã®ç•™æ„ç‚¹ â€¢ äº‹ä¾‹ ãƒ»SQL Serverã‹ã‚‰ã®ç§»è¡Œã‚¢ã‚»ã‚¹ãƒ¡ãƒ³ãƒˆ ãƒ»MySQLã‹ã‚‰ã®ç§»è¡Œç›¸è«‡ ãƒ»PostgreSQLã‹ã‚‰ã®ç§»è¡Œç›¸è«‡ ãƒ»Accessã‹ã‚‰ã®ç§»è¡Œã‚¢ã‚»ã‚¹ãƒ¡ãƒ³ãƒˆ ãƒ»Oracle Database ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—æ”¯æ´ ãƒ»Oracle Developer/2000 Webã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ç›¸è«‡ ãƒ»ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ã‚¯ãƒªãƒ‹ãƒƒã‚¯ ãƒ»Oracle Database æ§‹æˆç›¸è«‡ ãƒ»Oracle Data
dann 2011/02/28
oracle

lob
ãƒªãƒ³ã‚¯
Why CLOB segment size is growing
dann 2011/02/28
oracle

lob
ãƒªãƒ³ã‚¯
LOB Internals and Performance Tuning
dann 2011/02/28
lob

oracle
ãƒªãƒ³ã‚¯
lob_performance_guidelines
dann 2011/02/28
oracle

lob

perforance
ãƒªãƒ³ã‚¯
è¨˜æ†¶é ˜åŸŸæ§‹é€ ã¨UNDOãƒ‡ãƒ¼ã‚¿ã®ç®¡ç†
ã“ã‚Œã¾ã§é€£è¼‰ã—ã¦ããŸã€ŒORACLE MASTER Goldãƒã‚¤ãƒ³ãƒˆè§£èª¬ã€ã§ã¯ç¬¬4å›žã¾ã§ã¯ã€ŒPL/SQLã€ã‚’è§£èª¬ã—ã€ç¬¬5å›žä»¥é™ã«DBAã®è§£èª¬ã‚’è¡Œã£ã¦ã„ã‚‹ã€‚ã—ã‹ã—ã€2003å¹´10æœˆã®è³‡æ ¼åˆ¶åº¦ã®å¤‰æ›´ã«åˆã‚ã›ã€é€£è¼‰ã‚¿ã‚¤ãƒˆãƒ«ã‚’ã€Œæ–°ORACLE MASTER Silver DBAãƒã‚¤ãƒ³ãƒˆè§£èª¬ã€ã«å¤‰æ›´ã™ã‚‹ã€‚ãã®ãŸã‚ã€æœ¬é€£è¼‰ã¯ã€ŒORACLE MASTER Goldãƒã‚¤ãƒ³ãƒˆè§£èª¬ã€ã§ç´¹ä»‹ã—ãŸå†…å®¹ã‚’ç¢ºèªã—ãŸã†ãˆã§ãŠèªã¿ã„ãŸã ããŸã„ã€‚ ä»Šå›žã¯ã€å‰å›žï¼ˆã€Œç¬¬4å›žã€€Oracleã®è¡¨é ˜åŸŸã®ç®¡ç†ã€ï¼‰è§£èª¬ã—ãŸè¡¨é ˜åŸŸã®å†…éƒ¨æ§‹é€ ã§ã‚ã‚‹ã‚»ã‚°ãƒ¡ãƒ³ãƒˆã€ã‚¨ã‚¯ã‚¹ãƒ†ãƒ³ãƒˆã€ãƒ‡ãƒ¼ã‚¿ãƒ»ãƒ–ãƒãƒƒã‚¯ã«ã¤ã„ã¦è§£èª¬ã„ãŸã—ã¾ã™ã€‚ä»Šå›žã®å†…å®¹ã¯ã€å‰å›žè§£èª¬ã—ãŸè¡¨é ˜åŸŸã®æ§‹é€ ã‚’é ã«å…¥ã‚Œã¦ã„ã‚‹ã¨ã€ç†è§£ã™ã‚‹ã®ãŒæ—©ã„ã¨æ€ã„ã¾ã™ã€‚ã¾ãŸã€Oracle9iã‹ã‚‰ã®æ–°æ©Ÿèƒ½ã¨ã—ã¦ã€UNDOãƒ‡ãƒ¼ã‚¿ã®ç®¡ç†ã‚’è§£èª¬ã„ãŸã—ã¾ã™ã€‚ è¨˜æ†¶é ˜åŸŸæ§‹é€ è¨˜æ†¶é ˜åŸŸæ§‹é€ ã«ã¤ã„ã¦ã¯å‰å›žã®è¡¨é ˜åŸŸã¨åŒã˜ãã€è«–ç†çš„æ§‹
dann 2011/02/28
oracle

lob
ãƒªãƒ³ã‚¯
LOBè¨˜æ†¶åŸŸ
5 LOBè¨˜æ†¶åŸŸ ã“ã®ç« ã§ã¯ã€SECUREFILEãŠã‚ˆã³BASICFILEãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®ä¸¡æ–¹ã‚’æŒã¤LOBåˆ—ã‚’å«ã‚€è¡¨ã«ç‰¹å®šã®å•é¡Œã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚æ©Ÿèƒ½ãŒã€2ç¨®é¡žã®LOBã®ã„ãšã‚Œã‹1ã¤ã®ã¿ã«é©ç”¨ã•ã‚Œã‚‹å ´åˆã¯ã€ãã®ã‚ˆã†ã«ç¤ºã•ã‚Œã¾ã™ã€‚ ã“ã®ç« ã®å†…å®¹ã¯æ¬¡ã®ã¨ãŠã‚Šã§ã™ã€‚ LOBã‚’å«ã‚€è¡¨ã®ä½œæˆ LOBåˆ—ã®ãƒ‡ãƒ¼ã‚¿åž‹ã®é¸æŠž LOBè¨˜æ†¶åŸŸãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ LOBåˆ—ã«å¯¾ã™ã‚‹ç´¢å¼•ä»˜ã‘ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³è¡¨å†…ã®LOBã®æ“ä½œ ç´¢å¼•æ§‹æˆè¡¨å†…ã®LOB ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³åŒ–ã•ã‚ŒãŸç´¢å¼•æ§‹æˆè¡¨å†…ã®LOBã«å¯¾ã™ã‚‹åˆ¶é™ ãƒã‚¹ãƒˆã—ãŸè¡¨å†…ã®LOBã®æ›´æ–° æ°¸ç¶šLOBã‚’NULLã¾ãŸã¯ç©ºã¨ã—ã¦åˆæœŸåŒ– æ°¸ç¶šLOBï¼ˆè¡¨å†…ã®LOBåˆ—ã€ã¾ãŸã¯ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒå®šç¾©ã—ãŸã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆåž‹ã®LOBå±žæ€§ï¼‰ã‚’ã€NULLã¾ãŸã¯ç©ºã«è¨å®šã§ãã¾ã™ã€‚ æ°¸ç¶šLOBã‚’NULLã«è¨å®š: NULLã«è¨å®šã•ã‚ŒãŸLOBã«ãƒã‚±ãƒ¼ã‚¿ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚NULLå€¤ã¯ãƒã‚±ãƒ¼ã‚¿ã§ã¯ãªãã€è¡¨å†…ã®è¡Œã«æ ¼ç´ã•ã‚Œã¾ã™ã€‚ã“ã‚Œã¯
dann 2011/02/28
oracle

lob
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®å°ã•ãªãƒ–ãƒãƒƒã‚¯ ã‚µã‚¤ã‚ºã§ã¯ã€å¤§ããªã‚ãƒ¼é•·ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®å ´åˆã« ORA-01450 ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚å¤§ããªã‚ãƒ¼é•·ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã™ã‚‹ä»–ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã®é–“ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å…±æœ‰ã—ã¦ã„ã‚‹å ´åˆã€ãã®å¤§ããªã‚ãƒ¼é•·ã«å¯¾å¿œã§ãã‚‹å¤§ãã•ã®ãƒ–ãƒãƒƒã‚¯ ã‚µã‚¤ã‚ºã‚’æŒã¤ã€è¤‡æ•°ã®ãƒ–ãƒãƒƒã‚¯ ã‚µã‚¤ã‚ºã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ç§»å‹•ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ DB_CACHE_SIZE ã“ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã§ã¯ã€Oracle ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒãƒƒãƒ•ã‚¡ ãƒ—ãƒ¼ãƒ«ã®ã‚µã‚¤ã‚ºã‚’è¨å®šã—ã¾ã™ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒãƒƒãƒ•ã‚¡ ãƒ—ãƒ¼ãƒ«ã¯ã€ä½¿ç”¨çŽ‡ã®é«˜ã„ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¡ãƒ¢ãƒªã«ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦ã€ã™ã°ã‚„ãã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ãŸã‚ã«ä½¿ç”¨ã•ã‚Œã¾ã™ã€‚ã“ã®é ˜åŸŸã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‹ã‚‰ã®æƒ…å ±ã®å–å¾—è¦æ±‚å…¨ä½“ã®ç´„ 90% ã‚’åŽå®¹ã§ãã‚‹ã‚ˆã†ã«è¨å®šã—ã¾ã™ã€‚ã“ã®æ•°å—ã¯ã€Statspack ã®ãƒãƒƒãƒ•ã‚¡ ãƒ’ãƒƒãƒˆçŽ‡ã®å‰²åˆã§æ¸¬å®šã•ã‚Œã¾ã™ã€‚Statsp
dann 2010/12/22
oracle

lob
ãƒªãƒ³ã‚¯
DBAã®ãŸã‚ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ãƒ’ãƒ³ãƒˆ
dann 2010/12/22
oracle

clob

lob

performance
ãƒªãƒ³ã‚¯
1