Re: LMT Autoallocate initial, tot # of extents

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: barb.baker@xxxxxxxxx
  • Date: Tue, 7 Jun 2005 22:34:05 +0100

Hi Barb
On 6/6/05, Barbara Baker <barb.baker@xxxxxxxxx> wrote:
 
> Oracle 9.2.0.4 <http://9.2.0.4> Solaris 9 Blocksize 8192
> 
> I'm attempting to move (alter table .. move tablespace) several
> tables from DMT to autoallocate LMT for a database migrated from
> 8.1.7.4 <http://8.1.7.4> to 9.2.0.4 <http://9.2.0.4>. (Agonized over 
> autoallocate vs. uniform size.=20
> Perhaps I made the wrong choice.) Anyhow . . .
> 
> I have 1 table in particular that's 2752 megs 185 extents in the DMT.=20
> After I move it to the LMT, it's 2757M, 211 extents. Why so many
> extents?? I'm not as concerned with the # of extents as I am in
> understanding what it's doing.

 If you choose autoallocate over lmt you choose to give up understanding of 
what is happening in favour of easier admin. You got 211, someone else might 
get 200 and 2800mb and so on. You don't know. if you care or not is up to 
you. Not caring is valid, but not a choice I make.

-- 
> Niall Litchfield
> Oracle DBA
> http://www.niall.litchfield.dial.pipex.com

--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2005