Re: Increase tablespace, which way is better?

From: Jos <jos1992831_at_yahoo.com.au>
Date: Sat, 19 Jul 2003 23:51:10 +1000 (EST)
Message-Id: <25962.338563@fatcity.com>

--0-1105710617-1058622670=:90888
Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit

Please correct me if I am wrong. With option 1, the datafile will dynamically extend, 1M at a time and there is no guarantee the datafile is contiguous on disk. That will increase your I/O time when Oracle need to find data all over the disk. And also with autoextend, you may run out of space on that disk at any time (ie someone else created a big datafile on that disk), with option 2 at least you know you have 100M available for that datafile on the disk. Jos

"Liu, Jack" <jliu_at_atla.com> wrote:
Hi,
I want to increase tablespace, just want to know which way is better: 1. ALTER TABLESPACE SYSTEM
ADD DATAFILE '/u01/oradata/orcl/users02.dbf' SIZE 1M
AUTOEXTEND ON
NEXT 1M
MAXSIZE 100M; 2.alter tablespace system add datafile '/u01/oradata/orcl/users02.dbf' size 100m;

Thanks,

Jack

Yahoo! Mobile
- Check & compose your email via SMS on your Telstra or Vodafone mobile. --0-1105710617-1058622670=:90888
Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit

<DIV>Please correct me if I am wrong. With option 1, the datafile will dynamically extend, 1M at a time and there is no guarantee the datafile is contiguous on disk. That will increase your I/O time when Oracle need to find data all over the disk. And also with autoextend, you may run out of space on that disk at any time (ie someone else created a big datafile on that disk), with option 2 at least you know you have 100M available for that datafile on the disk.</DIV>
<DIV>Jos<BR><BR><B><I>"Liu, Jack" <jliu_at_atla.com></I></B> wrote:</DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid; WIDTH: 100%">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>

<DIV><FONT face="Times New Roman" color=#0000ff>Hi, <BR>I want to increase tablespace, just want to know which way is better:<BR>1. ALTER TABLESPACE SYSTEM<BR>ADD DATAFILE '/u01/oradata/orcl/users02.dbf'<BR>SIZE 1M<BR>AUTOEXTEND ON<BR>NEXT 1M<BR>MAXSIZE 100M;</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#0000ff>2.alter tablespace system add datafile '/u01/oradata/orcl/users02.dbf' size 100m;</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#0000ff>Thanks,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman"><FONT color=#0000ff>Jack<SPAN class=380473019-18072003> </SPAN></FONT></FONT></DIV>
<DIV><FONT face="Times New Roman"><FONT color=#0000ff><SPAN class=380473019-18072003></SPAN></FONT></FONT> </DIV></BLOCKQUOTE><p><br><hr size=1>
<a href="http://au.rd.yahoo.com/mail/tagline/?http://au.mobile.yahoo.com/sms/mail/index.html" target=_blank><b>Yahoo! Mobile</b></a><br>
- Check & compose your email via SMS on your Telstra or Vodafone mobile. Received on Sat Jul 19 2003 - 08:51:10 CDT