Hi!
Also, there is (or was?) a tradeoff between size
and number of datafiles.
Before 8i, ifI recall correctly, all datafile
headers had to be physicallyvisited (header SCN changes were written)
before a checkpoint could finish. If you got thousands of files, this adds
significant
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
prefer to add files.
Raj
-Original Message-From: Stephane Paquette
[mailto:[EMAIL PROTECTED]Sent: Friday, July 18,
2003 5:15 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Increase tablespace, which way is
better?
Why
not just resizing the file ?
alter database
Title: Message
what are u gaining in #1 .
-ak
- Original Message -
From:
Liu, Jack
To: Multiple recipients of list ORACLE-L
Sent: Friday, July 18, 2003 1:29 PM
Subject: Increase tablespace, which way
is better?
Hi, I want to increase
tablespace, just
Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of AKSent: Friday,
July 18, 2003 4:59 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: Increase tablespace, which way is
better?
what are u gaining in #1 .
-ak
- Original Message -
From
Title: Message
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
ORACLE-LSubject: RE: Increase tablespace, which way is
better?
Why
not just resizing the file ?
alter database datafile . resize 500M;
Stephane
Paquette
Administrateur
de bases de donnees
Database
Administrator
Standard
Life
www.standardlife.ca
Tel