| Data File Size ? [message #62847] |
Thu, 19 August 2004 01:58  |
ora
Messages: 47
Registered: June 2002
|
Member |
|
|
Hi All,
I have a query regarding oracle datafiles. I have to port around 30GB of data into a single schema. Now my question are :
1) Should i port all the 30G data into a single tablespace having single datafile of 30G or go for multiple datafiles?
2) Should i use multiple tablespaces with multiple datafiles to port that data?
Basically i want to know the implications of using large files vs small multiple files. Which one is better approach.
I am using oracle 9i RAC with SAN on Linux AS 3.0
|
|
|
|
| Re: Data File Size ? [message #62886 is a reply to message #62847] |
Sun, 22 August 2004 11:03  |
Thomas
Messages: 67
Registered: September 1999
|
Member |
|
|
Oracle tablespaces are logical structures, which combine one or more datafiles. The grouping is based on the data relation. If all the data is related then you can have it one tablespace. Examples:
SALES_DATA
HR_DATA
MANIFACTURING_DATA
etc...
It's better to have many datafiles, than a single datafile, bacuse if you queries access historical data, then the chance to hit a single datafile is less than is everything is in one datafile. You can spread the datafiles to separate drives, or stripe them in RAID. Also single datafile growing to 30 Gb is hard to manage: move, backup, restore.
Hope that helps,
clio_usa - OCP DBA 8/8i/9i
Oracle DBA Resources
Oracle DBA Forums
USENET Oracle newsgroups
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
