Re: Conversion from LONG -> CLOB -> BLOB for 1 TB Table?
- From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 18 Jan 2007 20:10:48 +0700
On 1/17/07, Nuno Souto <dbvision@xxxxxxxxxxxx> 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
- References:
- Conversion from LONG -> CLOB -> BLOB for 1 TB Table?
- From: VIVEK_SHARMA
- Re: Conversion from LONG -> CLOB -> BLOB for 1 TB Table?
- From: Nuno Souto
Other related posts:
- » Conversion from LONG -> CLOB -> BLOB for 1 TB Table?
- » Re: Conversion from LONG -> CLOB -> BLOB for 1 TB Table?
- » RE: Conversion from LONG -> CLOB -> BLOB for 1 TB Table?
- » RE: Conversion from LONG -> CLOB -> BLOB for 1 TB Table?
- » Re: Conversion from LONG -> CLOB -> BLOB for 1 TB Table?
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?
- Conversion from LONG -> CLOB -> BLOB for 1 TB Table?
- From: VIVEK_SHARMA
- Re: Conversion from LONG -> CLOB -> BLOB for 1 TB Table?
- From: Nuno Souto