RE: Q about autoextent tablespaces and performance

<span

style='font-size:10.0pt;font-family:Arial;color:navy'>Accidently<font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial; color:navy'> hit send before I finished my response...

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>
Anyway, one thing I used to do is give them a CRETAB/CREIDX script and have <span class=GramE>them run it.

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>This will allow you to build the table and indexes ahead of time, and of the size you desire.  You can also have the script
create an initial setting of the size of the existing table.<span style='mso-spacerun:yes'>  Take a look at the <span class=SpellE>cretab.sql script on my site which is what I used to use when I had to do such things.

<span style='font-size:

10.0pt;font-family:Arial;color:navy'> 

<span style='font-size:12.0pt;

color:navy;mso-no-proof:yes'>"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

<span style='font-size:18.0pt;

font-family:"Comic Sans MS";color:navy;mso-no-proof:yes'>Christopher R. Spence<font color=navy>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Oracle DBA<span style='color:navy;
mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Phone: (978) 322-5744<span
style='color:navy;mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Fax:    (707) 885-2275<span
style='color:navy;mso-no-proof:yes'>

<span style='font-size:10.0pt;

font-family:"Comic Sans MS";color:navy;mso-no-proof:yes'>Fuelspot<font color=navy>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>73 Princeton Street<span style='color:navy; mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>North, Chelmsford 01863<span
style='color:navy;mso-no-proof:yes'>
 

<span

style='font-size:10.0pt;font-family:Tahoma'>-----Original Message----- From: Schoen Volker
[mailto:v.schoen_at_inplan.de]
Sent<span
style='font-weight:bold'>: Friday, October 05, 2001 1:10 PM To: Multiple recipients of list
ORACLE-L
Subject: Q about autoextent
tablespaces and performance

<span

style='font-size:12.0pt'> 

<span style='font-size:

12.0pt;font-family:Arial'>Hi list,

<span style='font-size:

12.0pt;font-family:Arial'>I need some opinions about following question.

<span style='font-size:

12.0pt;font-family:Arial'>I have a developer box with about 20 schemas. Sometimes our customers send us a export of there data which I had to import into our develop instance. My problem is that I don't now how much space I need for those imports. My solution is to create tablespaces with about 50 MB and set autoextent on (localy managed). I import the customers data first time and tablespace may use 200 mb. After some weeks I get the next export. After import, tablespace growth to 300 mb.

<span style='font-size:

12.0pt;font-family:Arial'>So now my question, is it better to create a large tablespace, because of continouges db and hdd blocks, or does this have no influence or small influence on performance. I prefer to build small tablespaces with limited autoextent option. Reason is, that my cold backups were quicker, cause I do not have to reserve a lot of unused space for my tablespaces.

<span style='font-size:

12.0pt;font-family:Arial'>I have databases on Suse Linux, NT4 and W2K. This question is for all platform. If there are some platform specific issues, please let me know.

<span style='font-size:

12.0pt;font-family:Arial'>Hope you understand my question.

<span style='font-size:

12.0pt;font-family:Arial'>TIA

<span

style='font-size:12.0pt;font-family:Arial;color:black'>Volker Schoen

E-Mail:
<span

style='font-family:Arial'>mailto:v.schoen_at_inplan.de http://www.inplan.de

<span

style='font-size:12.0pt'>  Received on Fri Oct 05 2001 - 12:34:10 CDT