Re: automatic extent allocation

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <roger_xu@xxxxxxxxxxx>, "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 7 Jan 2005 08:32:33 -0000

In the first place, I would consider moving the
object out of the current tablespace (or move
everything else out of the tablespace) because
it sounds like nothing else should be sharing that
tablespace.  (Consider the problem of recovering
the entire tablespace because one of the other tables
gets a corrupt block - if you can't take advantage
of rman block level recovery).

Secondly, at 3GB per month, I would consider
partitioning the table at something like one partition
per month - thus making your question moot.

It sounds like your object is still using 64MB
extents - it would be interesting to see if there
is another step size when you hit a total of 64GB,
or whether you keep going at 50 extents per month.

I suspect the problems you __might__ get from having
2,000 extents are much less significant than the problems
you __might__ get if you have a 100GB segment by the end
of next year.


Jonathan Lewis
The Co-operative Oracle Users' FAQ
Public Appearances - schedule updated Dec 23rd 2004

----- Original Message ----- 
From: "Roger Xu" <roger_xu@xxxxxxxxxxx>
To: "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, January 06, 2005 11:54 PM
Subject: automatic extent allocation

Hi list,

We are on Solaris 9/Oracle 9i with locally managed tablespace.
There is a huge tablespace in our database with many huge tables.
The biggest table has a size of 60 GB. (Indexes are in a different 
And it has 1030 extents now, because we use automatic extent allocation.

Right now we do not have any issues. Do you recommend me to move it to its
own tablespace with uniform extent allocation? At what point are we going to
have issue? over 2000 extents? The table is growing at a rate of 3 GB / 


This e-mail is intended solely for the person or entity to which it is 
addressed and may contain confidential and/or privileged information. Any 
review, dissemination, copying, printing or other use of this e-mail by 
persons or entities other than the addressee is prohibited. If you have 
received this e-mail in error, please contact the sender immediately and 
delete the material.
This email has been scanned for all viruses by the MessageLabs Email 
Security System. Any questions please call 972-721-8257 or email your 
request to tech_support@xxxxxxxxxxxx


Other related posts: