RE: Increase tablespace, which way is better?

From: David Wagoner <dwagoner_at_arsenaldigital.com>
Date: Fri, 18 Jul 2003 16:20:23 -0400
Message-Id: <25956.338524@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C34D6A.0489FCD0
Content-Type: text/plain;

charset="iso-8859-1"

My first question is: Why are you adding a data file named "users" to your SYSTEM tablespace? Do you mean to add this to your USERS tablespace?

Next, if you have an idea about the data growth or size of objects that you will place in the new datafile then you can better plan the initial size. It's better to create it with an initial size close to your target value so that it doesn't have to dynamically extend. At least that's what I would do with a data file that small (100 MB). For small DBs, I usually set my data file max size to 2 GB. Anything over that will mean adding another data file.

David B. Wagoner
Oracle DBA

------_=_NextPart_001_01C34D6A.0489FCD0
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o =

"urn:schemas-microsoft-com:office:office"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>

<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=323541520-18072003>My
first question is: Why are you adding a data file named "users" to your SYSTEM tablespace?  Do you mean to add this to your USERS tablespace?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=323541520-18072003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=323541520-18072003>Next,
if you have an idea about the data growth or size of objects that you will place in the new datafile then you can better plan the initial size.  It's better to create it with an initial size close to your target value so that it doesn't have to dynamically extend.  At least that's what I would do with a data file that small (100 MB).  For small DBs, I usually set my data file max size to 2 GB.  Anything over that will mean adding another data file.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=323541520-18072003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=323541520-18072003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=323541520-18072003>David
B. Wagoner</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=323541520-18072003>Oracle
DBA</SPAN></FONT></DIV></BODY></HTML> Received on Fri Jul 18 2003 - 15:20:23 CDT