| Should I add a fourth datafile or autoextend [message #181736] |
Tue, 11 July 2006 05:43  |
aidi-h
Messages: 45
Registered: November 2005
|
Member |
|
|
Can anyone help me! I am will be running out of space in one of my tablespaces shortly. The question is, is there any criteria for deciding whether to add a fourth datafile to the tablespace or whether to autoextend the last, currently used datafile.
Disc space is not really an issue for me.
Are there potential performance issues or considerations to bear in mind, if I alter the last datafile so that autoextend is switched on and it grows and grows.
Any help would be appreciated.
|
|
|
|
|
|
| Re: Should I add a fourth datafile or autoextend [message #181856 is a reply to message #181736] |
Tue, 11 July 2006 23:23  |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
Its a good stadard to follow fixed size for datafiles,lets say 2GB each file and autoextend OFF .Also you can set a job to alert you when file reach threshold ,and keep on adding files.
as aidi-h said,you should have a proper maxdatafiles value .
|
|
|
|
| Re: Should I add a fourth datafile or autoextend [message #182452 is a reply to message #181856] |
Sat, 15 July 2006 00:32 |
satheeshb
Messages: 5
Registered: July 2006
|
Junior Member |
|
|
Hi,
You can use autoextend with maxsize or even add a datafile. There won't be any different. Having too many datafile will have small impact during checkpoint. Too many is really toooo many. You don't have to worry much abt it.
Regards,
Satheesh Babu.S
Bangalore.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
