automatic extent allocation

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Thu, 6 Jan 2005 17:54:54 -0600
Message-ID: <A6801E8A03316A4DA597866F77A013F7059C91E3@irv2kexch01>

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 tablespace) 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 / month.

TIA, Roger
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_at_dp7uptx.com.

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

Received on Thu Jan 06 2005 - 17:50:09 CST