|
|
|
|
| Re: Split 30GB DBF File into 6 - 5GB Files [message #537287 is a reply to message #537285] |
Tue, 27 December 2011 09:23   |
bscholl
Messages: 9
Registered: May 2008
|
Junior Member |
|
|
|
We performed this task in the Oracle Admin 1 class, I don't have the lab material with me. I guess there really is no problem with the 30GB file, my boss was wondering if it would give us more performance with more smaller DBF files instead of one large one.
|
|
|
|
|
|
| Re: Split 30GB DBF File into 6 - 5GB Files [message #537290 is a reply to message #537287] |
Tue, 27 December 2011 09:33 |
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
I've just checked the Admin 1 course material, there is no exercise like that - you must be thinking of somethinmg different. The problem is that you can only resize a datafile downwards if space beyond the point to which you wish to resize it is not being used. This is highly unlikely: the only time it could be guaranteed to work is if you create the tablespace with one datafile, and then do this exercise before creating any segments in the rablespace and using a significant proportion of the space.
But don't worry about it: tell your boss that there is no performance impact of any kind.
You might want to be aware of the fact that the maximum filesize you can use will be limited by your blocksize. For example, if using 8K blocks, you cannot go above 32G.
[Updated on: Tue, 27 December 2011 09:37] Report message to a moderator |
|
|
|
|
|
| Re: Split 30GB DBF File into 6 - 5GB Files [message #537294 is a reply to message #537291] |
Tue, 27 December 2011 10:10 |
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Yes, I've taken to using 16K nowadays too, so that files can go up to 64G. In the old days people used to believe that different block sizes were better or worse depending on the nature of the daa and the application, but that is now known to be rubbish.
To para-phrase another Black Swan classic: "please cut my pizza into twelve slices, not eight. I'm very hungry, so eight slices wouldn't be enough".
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
