| Oracle 10 tablespaces .dbf max file size [message #172986] |
Thu, 18 May 2006 16:59  |
shoman100
Messages: 1
Registered: May 2006
Location: Roseville
|
Junior Member |
|
|
Hola,
I am a Oracle novice, and have a question or two I was hoping you can help me with.
I have done many Oracle 9i setups and help maintain our users. We are migrating from Oracle 9i to 10g. So I am performing some test installs and documenting the new processes.
I noticed that the default table spaces (sysaux,system,undotbs1, and users) defaults to a max file size of 32767mb.
This was a red flag to me. Some of my customers are small and don't have much drive capacity. With a 32767mb file limit per dbf file. Theoretically, they could run out of physical drive space if those files grew large enough.
I was curious what others doing about the max file size value. Do you leave it as default? Or lower the max file size value for each .dbf file? Do I want to make sure that the total of the values does not exceed the maximum free disk space?
I appreciate any help on this matter.
Mark
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
