| tablespace efficiency [message #124419] |
Sat, 18 June 2005 05:05  |
epaloid
Messages: 1
Registered: June 2005
Location: manila
|
Junior Member |
|
|
hi all,
i just wanted to know w/c is more efficient: more datafiles in a tablespace or a bigger, single datafile on a tablespace?
running oracle 9.2 on win 2000 server
thanks
|
|
|
|
| Re: tablespace efficiency [message #124442 is a reply to message #124419] |
Sat, 18 June 2005 09:53  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
It depends on your underlying disk I/O system. How many hard drives you have, and the configuration of those drives. And the size, complexity, and use of your database plays a role in how much time you are going to have to administer it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
