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

Home -> Community -> Usenet -> c.d.o.server -> Re: LMT advice

Re: LMT advice

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 30 Sep 2003 22:50:18 +0100
Message-ID: <blctpa$9v$1$830fa7a5@news.demon.co.uk>

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...

> 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.
>
Received on Tue Sep 30 2003 - 16:50:18 CDT

Original text of this message

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