Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Conversion from LONG -> CLOB -> BLOB for 1 TB Table?

Re: Conversion from LONG -> CLOB -> BLOB for 1 TB Table?

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Thu, 18 Jan 2007 20:10:48 +0700
Message-ID: <3edcb66e0701180510v6b87bda1v3699837b53a756b9@mail.gmail.com>


On 1/17/07, Nuno Souto <dbvision_at_iinet.net.au> wrote:
>
> You might need to consider a smaller block size, IF a
> large percentage of your LOBs is slightly over the 4K
> "jump to offline" boundary and nowhere near the 8K block
> size. By this of course I mean: test the smaller block
> size with real data. Start at 2K?
>

let say i have LOB data average 100K
how if I set blocksize for LOB tablespace is 32K? but my database wide blocksize is 8K, how about performance?

another things are:
some LOB size per row will be vary 100MB, 500MB or even 1.2GB how we set the blocksize in related to performance.

regards
ujang

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 18 2007 - 07:10:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US