sql - Defining size of CLOB in Oracle -


i making table in storing xml. store xml using clob data type. max size of xml 5kb. size of clob column should define while creating table?

you don't define size when setting clob (unlike varchar). clob.

the max size of lob 4gb.

storage wise use space follows:

  1. if lob defined in-row, , lob less ~ 4kb , take amount of space document is. (eg store xml of 512 bytes in-row , use 512 bytes.
  2. if lob defined out of row (or exceeded 4kb) use multiple of "chunk" size defined when creating table.

when creating lob column, can specify storage clause control in-row , out-of-row options this:

lob (c) store lobseg (disable storage in row chunk 16384)

i.e. specify lob can never stored inline regular table data, , allocate storage in multiples of 16kb per chunk, if document 1kb, take 16kb of storage.

if xml documents 5kb, may want consider in-row storage, , put small chunk size (the min chunk size 1 block, if have tablespace 4kb extents, minumum chunk size 4kb; if specify less, ignored). disadvantage of allowing in-row lobs, table larger, large range scans may suffer bit (but lob retrieval faster).

also in 11g have option compress lob segments may want consider (if licence covers it). though such small documents may not benefit greatly.

read more here : http://docs.oracle.com/cd/b28359_01/appdev.111/b28393/adlob_tables.htm


Comments

Post a Comment

Popular posts from this blog

ios - iPhone/iPad different view orientations in different views , and apple approval process -

i force app's home screen portrait , other views landscape. apple rejects app if this? if not , how force first screen launch in portrait mode? , force other screens launch in landscape. this not duplicate question search every possible answer in website. i force app's home screen portrait , other views landscape. apple rejects app if this? no apple not reject app this. have lot of apps doesn't support orientation. forcing on 1 screen won't cause app reject. if not , how force first screen launch in portrait mode? , force other screens launch in landscape. can on write : -(nsuinteger)supportedinterfaceorientations; function.
Read more

java Extracting Zip file -

i'm looking way extract zip file. far have tried java.util.zip , org.apache.commons.compress, both gave corrupted output. basically, input zip file contain 1 single .doc file. java.util.zip: output corrupted. org.apache.commons.compress: output blank file, 2 mb size. so far commercial software winrar work perfectly. there java library make use of this? this method using java.util library: public void extractzipnative(file filezip) { zipinputstream zis; stringbuilder sb; try { zis = new zipinputstream(new fileinputstream(filezip)); zipentry ze = zis.getnextentry(); byte[] buffer = new byte[(int) ze.getsize()]; fileoutputstream fos = new fileoutputstream(this.tempfolderpath+ze.getname()); int len; while ((len=zis.read(buffer))>0) { fos.write(buffer); } fos.flush(); fos.close(); } catch (filenotfoundexception e) { // todo auto-generated catch block ...
Read more

C# WinForm - loading screen -

i ask how make loading screen (just picture or something) appears while program being loaded, , disappears when program has finished loading. in fancier versions, have seen process bar (%) displayed. how can have that, , how calculate % show on it? i know there form_load() event, not see form_loaded() event, or % property / attribute anywhere. all need create 1 form splash screen , show before main start showing landing page , close splash once landing page loaded. class splashform { //delegate cross thread call close private delegate void closedelegate(); //the type of form displayed splash screen. private static splashform splashform; static public void showsplashscreen() { // make sure launched once. if (splashform != null) return; thread thread = new thread(new threadstart(splashform.showform)); thread.isbackground = true; thread.setapartmentstate(apartmentstate.sta); thread....
Read more