Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: LMT advice
I've just had a little time to experiment using 9.2.0.3 and autoallocate.
If you do parallel CTAS, or parallel
insert of parallel select (enable parallel DML)
then the last extents for each slave can be
trimmed back. I only did fairly small experiments,
ca. 12,000 blocks, so I only saw extents of the
1M size coming out, but these could be trimmed
back to any multiple of 64K.
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html ____Iceland__November (tbc) ____Belgium__November (EOUG event) ____UK_______December (UKOUG conference) Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html ____USA__October ____UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html "Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3F7365E5.5960973C_at_remove_spam.peasland.com...Received on Tue Sep 30 2003 - 16:50:18 CDT
> Never seen an "odd" sized LMT with the tablespace in AUTOALLOCATE?
Check
> out the following from one of my production instances:
>
> GASP SQL> select blocks,bytes,count(*) as num
> 2 from dba_extents
> 3 where owner='WEBMAP' and segment_name='SDE_BLK_1071'
> 4 group by blocks,bytes order by blocks;
>
> BLOCKS BYTES NUM
> ---------- ---------------- ----------
> 8 65,536 16
> 128 1,048,576 65
> 1024 8,388,608 120
> 4864 39,845,888 1
> 5888 48,234,496 3
> 6016 49,283,072 3
> 8064 66,060,288 2
> 8192 67,108,864 2596
>
> 8 rows selected.
>