Lob \ub370\uc774\ud0c0\u00a0\ud0c0\uc785\uc740\u00a0\ub300\uc6a9\ub7c9\u00a0\ud06c\uae30\ub97c\u00a0\uc9c0\uc6d0\ud574\uc57c\u00a0\ud558\uae30\u00a0\ub54c\ubb38\uc5d0\u00a0\uc5b4\ub5a4\u00a0\ub370\uc774\ud0c0\u00a0\ud0c0\uc785 \ubcf4\ub2e4\ub3c4\u00a0storage \ud2b9\uc131\uc744\u00a0\uc798\u00a0\uc774\ud574\ud574\uc57c\u00a0\ud560\u00a0\ud544\uc694\uc131\uc774\u00a0\uc788\ub2e4.<\/p>\n
\uac01\uc885\u00a0parameter\uc5d0\u00a0\ub300\ud55c\u00a0\uc801\uc808\ud55c\u00a0\uc124\uc815\uc740\u00a0\uc88b\uc740\u00a0performance\ub97c\u00a0\ub0b4\ub294\u00a0\ub370\u00a0\uc911\uc694\ud55c\u00a0\uc694\uc778\uc774\u00a0\ub41c\ub2e4.<\/p>\n
<\/p>\n
\ub2e4\uc74c\uc740\u00a0LOB \uceec\ub7fc\uc744\u00a0\uac16\ub294\u00a0table\uc744\u00a0\uc0dd\uc131\ud558\ub294\u00a0SQL\ubb38\uc774\ub2e4.<\/p>\n
\ub2e4\uc591\ud55c\u00a0option\uc744\u00a0\uc0ac\uc6a9\ud558\uc600\ub294\ub370, \uc774\ub4e4\u00a0parameter\uc5d0\u00a0\ub300\ud55c\u00a0\uc790\uc138\ud55c\u00a0\uc774\ud574\ub97c\u00a0\ud1b5\ud574\u00a0\ud6a8\uacfc\uc801\uc778\u00a0lob segment\ub97c\u00a0\uc0dd\uc131\ud560\u00a0\uc218\u00a0\uc788\ub2e4.<\/p>\n
\ucc38\uace0\ub85c\u00a0lob\uc5d0\u00a0\ub300\ud55c\u00a0\uc790\uc138\ud55c\u00a0\uc815\ubcf4\ub97c\u00a0\ubcf4\ub824\uba74\u00a0 dba\/all\/user_lobs\ub97c\u00a0\uc870\ud68c\ud558\uba74\u00a0\uc54c\u00a0\uc218\u00a0\uc788\ub2e4.<\/p>\n
<\/p>\n
CREATE TABLE demolob ( A NUMBER, B CLOB )\r\n STORAGE (INITIAL 256 NEXT 256) \r\n TABLESPACE user_data \r\n LOB(b) STORE AS demolob_seg ( \r\n TABLESPACE lob_tb\r\n STORAGE (INITIAL 6144 NEXT 6144) \r\n CHUNK 4\r\n PCTVERSION 20\r\n NOCACHE LOGGING\r\n ENABLE STORAGE IN ROW \r\n INDEX demolob_idx (\r\n TABLESPACE lob_tb\r\n STORAGE ( INITIAL 256 NEXT 256 ) \r\n ) \r\n);<\/pre>\n<\/p>\n
1) TABLESPACE \uc640\u00a0\u00a0storage parameter<\/p>\n
<\/p>\n
– lob, lob index\uc5d0\u00a0\ub300\ud55c\u00a0tablespace\ub97c\u00a0\uc9c0\uc815\ud558\uc9c0\u00a0\uc54a\ub294\u00a0\uacbd\uc6b0, \ud574\ub2f9\u00a0 table\uc774\u00a0\uc800\uc7a5\ub418\ub294\u00a0tablespace \uc5d0\u00a0\uac19\uc774\u00a0\uc800\uc7a5\ub418\uac8c\u00a0\ub41c\ub2e4.<\/p>\n
lob \uceec\ub7fc,\u00a0lob index, table \uc5d0\u00a0\ub300\ud574\u00a0tablespace\ub97c\u00a0\uac01\uae30\u00a0\uc9c0\uc815\ud558\ub294\u00a0\uac83\uc774\u00a0contention\uc744\u00a0\uc904\uc77c\u00a0\uc218\u00a0\uc788\uc5b4\u00a0\ubcf4\ub2e4\u00a0\ud6a8\uacfc\uc801\uc774\ub2e4.\u00a0 ( \ucd5c\uc18c\ud55c\u00a0lob \uceec\ub7fc\uacfc\u00a0\ub2e4\ub978\u00a0\uceec\ub7fc\ub4e4\uc744\u00a0\uad6c\ubd84\ud558\uc5ec\u00a0\ubcc4 \uac1c\uc758\u00a0tablespace \uc5d0\u00a0\uc800\uc7a5\ud558\ub3c4\ub85d\u00a0\uc9c0\uc815\ud558\ub294\u00a0\uac83\uc774\u00a0\ubc14\ub78c\uc9c1\ud558\ub2e4.\u00a0<\/strong><\/span>)<\/p>\n
<\/p>\n
– lob index\ub294\u00a0lob \uceec\ub7fc\uc758\u00a0\ub0b4\ubd80\uc801\u00a0\uc800\uc7a5\u00a0\uc704\uce58\ub97c\u00a0\uc5f0\uacb0\uc2dc\ucf1c\uc8fc\ub294\u00a0indicator\ub97c\u00a0\uc800\uc7a5\ud55c\u00a0index\uc774\ub2e4. default\ub85c\u00a0\uc81c\uacf5\ubc1b\ub294\u00a0index\uba85\uc740\u00a0\uc774\ud574\ud558\uae30\u00a0\uc5b4\ub835\uae30\u00a0\ub54c\ubb38\uc5d0\u00a0lob index\uba85\uc744\u00a0\uc9c0\uc815\ud558\uc5ec\u00a0\uc0ac\uc6a9\ud558\ub294\u00a0\uac83\uc774\u00a0 \ud3b8\ud558\ub2e4.<\/p>\n
<\/p>\n
– lob index\uc5d0\u00a0\ub300\ud55c\u00a0parameter \ubcc0\uacbd\uc740\u00a0alter index\ubb38\uc744\u00a0\uc774\uc6a9\ud558\uc9c0\u00a0 \uc54a\uace0, alter table\ubb38\uc744\u00a0\uc774\uc6a9\ud558\uc5ec\uc57c\u00a0\ud55c\ub2e4. \ub2e8, index\uba85\uc744\u00a0\ubc14\uafc0\u00a0\uc218\ub294\u00a0\uc5c6\ub2e4.<\/p>\n
<\/p>\n
<\/p>\n
2) PCTVERSION<\/p>\n
<\/p>\n
– \ub370\uc774\ud0c0\ub97c\u00a0\ubcc0\uacbd\ud560\ub54c\ub294\u00a0read consistency\ub97c\u00a0\uc704\ud574\u00a0undo \uc815\ubcf4\ub97c\u00a0\uc800\uc7a5\ud560\u00a0\ud544\uc694\uac00\u00a0\uc788\ub2e4. \uadf8\ub7ec\ub098\u00a0LOB \ub370\uc774\ud0c0\uc778\u00a0\uacbd\uc6b0, \uadf8\u00a0\ud06c\uae30\uac00\u00a0\ud06c\uae30\ub54c\ubb38\uc5d0\u00a0undo \uc815\ubcf4\u00a0\uc720\uc9c0\ud558\uae30\uc5d0\ub294\u00a0\ub9ce\uc740\u00a0\uc5b4\ub824\uc6c0\uc774\u00a0\ub530\ub974\uae30\u00a0\ub54c\ubb38\uc5d0, \ub300\uc2e0\uc5d0\u00a0old version \ub370\uc774\ud0c0\ub97c\u00a0\uc720\uc9c0\ud558\ub294\u00a0\ubc29\ubc95\uc73c\ub85c\u00a0read consistency\ub97c\u00a0\uc81c\uacf5\ud558\uace0\u00a0\uc788\ub2e4.<\/p>\n
pctversion\uc740\u00a0old version lob data\uac00\u00a0\ucc28\uc9c0\ud558\ub294\u00a0percentage\ub97c\u00a0\uc758\ubbf8\ud55c\ub2e4.<\/p>\n
\uc608\ub97c\ub4e4\uc5b4\u00a0default value\uac00(10) \uc801\uc6a9\ub418\uc5c8\ub2e4\uba74, \uc0c8\ub85c\uc6b4\u00a0lob\u00a0data\uac00\u00a0old version\uc758\u00a010%\uac00\u00a0\uc800\uc7a5\ub420\ub54c\u00a0\uae4c\uc9c0\ub294\u00a0old version\uc744\u00a0\u00a0\uac04\uc9c1\ud558\uace0\u00a0\uc788\ub2e4\uac00, \uc774\u00a0\uc774\uc0c1\u00a0\ud06c\uae30\uac00\u00a0\ub418\uba74\u00a0\ubc14\ub85c\u00a0old version data\ub97c\u00a0reclaim\ud558\uace0,\u00a0\uc774\u00a0space\ub97c\u00a0\uc7ac\uc0ac\uc6a9\u00a0\uc989, overwrite \ud558\uac8c\u00a0\ub41c\ub2e4.<\/p>\n
<\/p>\n
– pctversion\uc744\u00a0\ud070\u00a0\uac12\uc744\u00a0\uc9c0\uc815\ud55c\u00a0\uacbd\uc6b0, old version\uc744\u00a0\uc800\uc7a5\ud558\uae30\u00a0\uc704\ud574\u00a0\ubcf4\ub2e4\u00a0\ub9ce\uc740\u00a0space\uac00\u00a0\ud544\uc694\ud558\uac8c\u00a0\ub41c\ub2e4. \ud558\uc9c0\ub9cc\u00a0update\uac00\u00a0\ub9ce\uc740\u00a0\uc791\uc5c5\uc778\u00a0\uacbd\uc6b0\uc5d0\ub294\u00a0\uc774\u00a0\uac12\uc744\u00a0\ub192\uac8c\u00a0\uc7a1\uc544\u00a0\ub2e4\uc74c\uacfc\u00a0\uac19\uc740\u00a0\uc5d0\ub7ec\ub97c\u00a0\ud53c\ud560\u00a0\uc218\u00a0\uc788\uc744\u00a0\uac83\uc774\ub2e4.<\/p>\n
<\/p>\n
\u00a0\u00a0\u00a0\u00a0ORA-01555: snapshot too old: rollback segment number\u00a0 \u00a0with name “” too small<\/strong><\/p>\n
\u00a0\u00a0\u00a0\u00a0ORA-22924: snapshot too old<\/strong><\/p>\n
<\/p>\n
– \ub9cc\uc57d\u00a0lob data\uac00\u00a0read-only\uc778\u00a0\uacbd\uc6b0\ub77c\uba74, pctversion\uc740\u00a00\uc73c\ub85c\u00a0 \uc124\uc815\ud560\u00a0\uc218\u00a0\uc788\ub2e4.<\/p>\n
<\/p>\n
– pctversion \ubcc0\uacbd<\/p>\n
<\/p>\n
SQL> ALTER TABLE demolob MODIFY LOB(b) (PCTVERSION 10);<\/p>\n
<\/p>\n
3) CACHE\/NOCACHE<\/p>\n
<\/p>\n
– \uc790\uc8fc\u00a0access\ub418\ub294\u00a0\uacbd\uc6b0\ub77c\uba74, cache\ub97c\u00a0\uc120\ud0dd\ud558\uc5ec\u00a0\uc0ac\uc6a9\ud55c\ub2e4.\u00a0 default\ub294\u00a0nocache\uc774\ub2e4.<\/p>\n
<\/p>\n
– in-line lob\uc740\u00a0\uc601\ud5a5\uc744\u00a0\ubc1b\uc9c0\u00a0\uc54a\ub294\ub2e4. \uc989, in-line lob\uc740\u00a0\ub2e4\ub978\u00a0\ub370\uc774\ud0c0 \uc640\u00a0 \ub9c8\ucc2c\uac00\uc9c0\ub85c\u00a0buffer cache\uc5d0\uc11c\u00a0\ubc14\ub85c\u00a0\uc77d\ud600\uc9c0\uae30\u00a0\ub54c\ubb38\uc774\ub2e4.<\/p>\n
<\/p>\n
– CACHE_SIZE_THRESHOLD limit\uc774\u00a0\uc801\uc6a9\ub418\uc9c0\u00a0\uc54a\uae30\u00a0\ub54c\ubb38\uc5d0\u00a0cache\ud560\u00a0\ub54c\ub294\u00a0 \uc8fc\uc758\ud574\uc57c\u00a0\ud55c\ub2e4.<\/p>\n
<\/p>\n
– cache\/nocache \ubcc0\uacbd<\/p>\n
<\/p>\n
SQL> ALTER TABLE demolob MODIFY LOB (b) ( CACHE\/NOCACHE ) ;<\/p>\n
<\/p>\n
4) CHUNK<\/p>\n
<\/p>\n
– lob data\ub97c\u00a0access\ud558\ub294\u00a0\ub2e8\uc704\ub85c\uc368, db_block_size\uc758\u00a0\ubc30\uc218\ub85c\u00a0\uc124\uc815\ud55c\ub2e4.\u00a0\u00a0 lob \ub370\uc774\ud0c0\uac00\u00a0\uc800\uc7a5\ub420\u00a0initial extent, next extent\ub294\u00a0chunk\uc758\u00a0\ubc30\uc218\ub85c\u00a0\uc124\uc815\ud558\ub294\u00a0\uac83\uc774\u00a0\uc88b\ub2e4. \ub9cc\uc57d\u00a0db_block_buffer\uac00\u00a02K\uc774\uace0, chunk\ub97c\u00a03K\ub85c\u00a0\uc124\uc815\ud588\ub2e4\uba74\u00a0chunk\ub294\u00a04K\ub85c\u00a0\uc870\uc815\u00a0\ub418\uc5b4\u00a0\uc801\uc6a9\ub41c\ub2e4.<\/p>\n
<\/p>\n
– chunk\ub294\u00a0in-line lob\uc5d0\ub294\u00a0\uc601\ud5a5\uc744\u00a0\uc8fc\uc9c0\u00a0\uc54a\uace0, out-line lob\uc5d0\ub9cc\u00a0\uc601\ud5a5\uc744\u00a0 \uc900\ub2e4. \uc608\ub97c\ub4e4\uc5b4\u00a0chuk\ub97c\u00a032K\ub85c\u00a0\uc124\uc815\ud558\uace0, disable storage in row\ub97c\u00a0\uc124\uc815\ud588\ub2e4\uba74\u00a01K\uc758\u00a0\ub370\uc774\ud0c0\ub97c\u00a0\uc800\uc7a5\ud560\ub54c\ub3c4\u00a032K\uac00\u00a0lob segment\uc5d0\u00a0\ud560\ub2f9\ub41c\ub2e4.<\/p>\n
<\/p>\n
– lob table\uc774\u00a0\uc0dd\uc131\ub41c\u00a0\uc774\ud6c4\uc5d0\ub294\u00a0\ubcc0\uacbd\ud560\u00a0\uc218\u00a0\uc5c6\ub2e4.<\/p>\n
<\/p>\n
5) LOGGING\/NO LOGGING<\/p>\n
<\/p>\n
– redo \uc815\ubcf4\ub97c\u00a0\uc0dd\uc131\ud560\u00a0\uac83\uc778\uc9c0\u00a0\uc5ec\ubd80\ub97c\u00a0\uacb0\uc815\ud558\ub294\u00a0parameter\uc774\ub2e4.<\/p>\n
<\/p>\n
– cache option\uc744\u00a0\uc0ac\uc6a9\ud558\ub294\u00a0\uacbd\uc6b0\ub294\u00a0\ubb34\uc870\uac74\u00a0logging\uc744\u00a0\uc758\ubbf8\ud55c\ub2e4.<\/p>\n
<\/p>\n
– logging, nologging\uc5d0\u00a0\uc0c1\uad00\u00a0\uc5c6\uc774\u00a0undo \uc815\ubcf4\ub294\u00a0lob index\uc5d0\u00a0\ub300\ud574\uc11c\ub9cc\u00a0 \uc0dd\uc131\ub418\uace0, lob \ub370\uc774\ud0c0\uc5d0\u00a0\ub300\ud574\uc11c\ub294\u00a0\uc0dd\uc131\ud558\uc9c0\u00a0\uc54a\ub294\ub2e4.<\/p>\n
<\/p>\n
– logging\uc778\u00a0\uacbd\uc6b0\ub294\u00a0redo \uc815\ubcf4\ub97c\u00a0\uc0dd\uc131\ud558\uace0, bulk load\ub098\u00a0\ub300\ub7c9\uc758\u00a0\u00a0insert\ub97c\u00a0\ud558\ub294\u00a0\uacbd\uc6b0\u00a0nologging\uc744\u00a0\uc124\uc815\ud558\uc5ec\u00a0redo \uc815\ubcf4\ub97c\u00a0\uc0dd\uc131\ud558\uc9c0\u00a0\u00a0\u00a0\u00a0\uc54a\ub3c4\ub85d\u00a0\ud560\u00a0\uc218\u00a0\uc788\ub2e4.<\/p>\n
<\/p>\n
– logging\/no logging \ubcc0\uacbd<\/p>\n
<\/p>\n
SQL> ALTER TABLE demolob MODIFY LOB(b) (NOCACHE NOLOGGING);<\/p>\n
<\/p>\n
<\/p>\n
6) ENABLE\/DISABLE STORAGE IN ROW<\/p>\n
<\/p>\n
– 4k \uc774\ud558\uc758\u00a0data\ub97c\u00a0in-line\uc5d0\u00a0\uc800\uc7a5\ud560\u00a0\uc9c0\u00a0\uc5ec\ubd80\ub97c\u00a0\uacb0\uc815\ud55c\ub2e4.<\/p>\n
<\/p>\n
– enable\uc778\u00a0\uacbd\uc6b0\u00a0(default)<\/p>\n
4k \uc774\ud558\uc758\u00a0lob\uc740\u00a0in-line\uc73c\ub85c, \uc989\u00a0\ud14c\uc774\ube14\uc5d0\u00a0\uc800\uc7a5\ud558\uace0, 4k \ubcf4\ub2e4\u00a0\ud070\u00a0\uacbd\uc6b0\uc5d0\ub294\u00a0out-line \uc989, lob segment\uc5d0\u00a0\uc800\uc7a5\ub41c\ub2e4. \uc774\ub54c\u00a04K\ub294\u00a0control \uc815\ubcf4\ub97c\u00a0\ud3ec\ud568\ud55c\u00a0\ud06c\uae30\ub85c\uc368, \uc2e4\uc81c\u00a0in-line\uc73c\ub85c\u00a0\uc800\uc7a5\ud560\u00a0\uc218\u00a0 \uc788\ub294\u00a0\ucd5c\ub300\u00a0\ud06c\uae30\ub294\u00a03964 byte\uc774\ub2e4.<\/p>\n
4K \uc774\uc0c1\uc758\u00a0\ub370\uc774\ud0c0\ub294\u00a0lob\u00a0 segment\uc5d0\u00a0\uc800\uc7a5\ub418\uc9c0\ub9cc, 36 – 84 bytes\uc758\u00a0information \uc815\ubcf4\ub294\u00a0in-line\uc5d0\u00a0\ub0a8\uac8c\u00a0\ub41c\ub2e4.<\/p>\n
<\/p>\n
– disable\uc778\u00a0\uacbd\uc6b0<\/p>\n
\ubaa8\ub4e0\u00a0data \ub294\u00a0out-line\uc73c\ub85c\u00a0\uc800\uc7a5\ub41c\ub2e4. 20 byte lob locator \ub9cc\u00a0in-line\uc73c\ub85c\u00a0\uc800\uc7a5\ub418\uc5b4\u00a0lob index\uc5d0\uc11c\u00a0\ud574\ub2f9\u00a0lob block\uc744\u00a0\ucc3e\uc744\u00a0\uc218\u00a0\uc788\ub3c4\ub85d\u00a0\ud574\uc900\ub2e4.<\/p>\n
<\/p>\n
– in-line lob\uc778\u00a0\uacbd\uc6b0\uc5d0\ub294\u00a0\ub2e4\ub978\u00a0\ub370\uc774\ud0c0\u00a0\ud0c0\uc785\ucc98\ub7fc\u00a0REDO, UNDO \uc815\ubcf4\uac00\u00a0\uae30\ub85d\ub41c\ub2e4. \uadf8\ub7ec\ub098\u00a0out-line\uc778\u00a0\uacbd\uc6b0\uc5d0\ub294\u00a0column locator\uc640\u00a0LOB INDEX\uac00\u00a0\ubcc0\uacbd\ub418\ub294\u00a0\uacbd\uc6b0\uc5d0\ub9cc\u00a0UNDO \uc815\ubcf4\ub97c\u00a0\uae30\ub85d\ud55c\ub2e4. \uc989, lob segment\uc5d0\u00a0\ub300\ud574\uc11c\ub294\u00a0 undo \uc815\ubcf4\ub97c\u00a0\ub9cc\ub4e4\uc9c0\u00a0\uc54a\ub294\ub2e4.<\/p>\n
<\/p>\n
– lob \uceec\ub7fc\uc5d0\u00a0\ub300\ud55c\u00a0access\uac00\u00a0\u00a0\ub9ce\uc9c0\u00a0\uc54a\uc740\u00a0\uacbd\uc6b0\ub294\u00a0disable\uc744\u00a0\uc124\uc815\ud558\ub294\u00a0\uac83\uc774\u00a0\ubc14\ub78c\uc9c1\ud558\ub2e4. High Water Mark\ub97c\u00a0\uc791\uac8c\u00a0\uc720\uc9c0\ub420\u00a0\uc218\u00a0\uc788\uae30\u00a0\ub54c\ubb38\uc5d0\u00a0\ud2b9\ud788,\u00a0 full \u00a0table scan\uc744\u00a0\uc790\uc8fc\u00a0\ud558\ub294\u00a0table\uc778\u00a0\uacbd\uc6b0\u00a0\uc720\uc6a9\ud558\ub2e4.<\/p>\n
<\/p>\n
– lob table\uc774\u00a0\uc0dd\uc131\ub41c\u00a0\uc774\ud6c4\uc5d0\ub294\u00a0\ubcc0\uacbd\ud560\u00a0\uc218\u00a0\uc5c6\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
Lob \ub370\uc774\ud0c0\u00a0\ud0c0\uc785\uc740\u00a0\ub300\uc6a9\ub7c9\u00a0\ud06c\uae30\ub97c\u00a0\uc9c0\uc6d0\ud574\uc57c\u00a0\ud558\uae30\u00a0\ub54c\ubb38\uc5d0\u00a0\uc5b4\ub5a4\u00a0\ub370\uc774\ud0c0\u00a0\ud0c0\uc785 \ubcf4\ub2e4\ub3c4\u00a0storage \ud2b9\uc131\uc744\u00a0\uc798\u00a0\uc774\ud574\ud574\uc57c\u00a0\ud560\u00a0\ud544\uc694\uc131\uc774\u00a0\uc788\ub2e4. \uac01\uc885\u00a0parameter\uc5d0\u00a0\ub300\ud55c\u00a0\uc801\uc808\ud55c\u00a0\uc124\uc815\uc740\u00a0\uc88b\uc740\u00a0performance\ub97c\u00a0\ub0b4\ub294\u00a0\ub370\u00a0\uc911\uc694\ud55c\u00a0\uc694\uc778\uc774\u00a0\ub41c\ub2e4. \ub2e4\uc74c\uc740\u00a0LOB \uceec\ub7fc\uc744\u00a0\uac16\ub294\u00a0table\uc744\u00a0\uc0dd\uc131\ud558\ub294\u00a0SQL\ubb38\uc774\ub2e4. \ub2e4\uc591\ud55c\u00a0option\uc744\u00a0\uc0ac\uc6a9\ud558\uc600\ub294\ub370, \uc774\ub4e4\u00a0parameter\uc5d0\u00a0\ub300\ud55c\u00a0\uc790\uc138\ud55c\u00a0\uc774\ud574\ub97c\u00a0\ud1b5\ud574\u00a0\ud6a8\uacfc\uc801\uc778\u00a0lob segment\ub97c\u00a0\uc0dd\uc131\ud560\u00a0\uc218\u00a0\uc788\ub2e4. \ucc38\uace0\ub85c\u00a0lob\uc5d0\u00a0\ub300\ud55c\u00a0\uc790\uc138\ud55c\u00a0\uc815\ubcf4\ub97c\u00a0\ubcf4\ub824\uba74\u00a0 dba\/all\/user_lobs\ub97c\u00a0\uc870\ud68c\ud558\uba74\u00a0\uc54c\u00a0\uc218\u00a0\uc788\ub2e4. CREATE TABLE demolob ( A NUMBER, B CLOB ) STORAGE (INITIAL 256 NEXT 256) TABLESPACE user_data LOB(b) STORE AS demolob_seg ( TABLESPACE lob_tb STORAGE (INITIAL 6144 NEXT 6144) CHUNK 4 PCTVERSION 20 NOCACHE LOGGING ENABLE STORAGE IN ROW INDEX demolob_idx ( […]<\/p>\n","protected":false},"author":1,"featured_media":2877,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[3],"tags":[1004,836,834,837],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/how_do_i1.png?fit=936%2C756","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3551"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3551"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3551\/revisions"}],"predecessor-version":[{"id":3552,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3551\/revisions\/3552"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2877"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3551"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}