Re: LOCALLY MANAGED EXTENT PERFORMANCE

  • From: Tanel Põder <tanel.poder.003@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 25 Apr 2005 03:53:21 +0100

Hi,

I haven't read the whole thread - but I'd just like to contribute the fact, 
that nowadays I save my time and create all tablespaces as autoallocate - 
and haven't seen any performance nor other problems so far. And I don't 
worry about the number or size of extents at all.

Tanel.

----- Original Message ----- 
From: "Tim Gorman" <tim@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Sunday, April 24, 2005 8:44 PM
Subject: Re: LOCALLY MANAGED EXTENT PERFORMANCE


> Exactly why might a large number of extents be a bad thing?  In other 
> words,
> are you sure you are attaching the proper level of importance to the 
> issue?
>
> To help figure out if this is true, can you describe exactly what 
> operations
> might be affected by the number of extents, and how?  Queries?
> Inserts/updates/deletes?  Truncates?  Drops?  Monitoring queries?
>
> And, are you certain that autoLMT resolves the problem of "too many
> extents"?  Isn't there an upper limit on extent size even with autoLMT? 
> If
> so, then how is this different from intelligently sized uniform LMTs?
>
> My apologies for the Socratic questioning, but this thread contained too
> many assertions that need a little more examination...

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

Other related posts: