Re: Increase tablespace, which way is better?

[Jos]

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" <[EMAIL PROTECTED]> 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.