Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: The limit of the unlimited ?
Roye Avidor wrote:
> So, if I have a 200G filesystem and in the future it will expand > I wont have the option to use the whole filesystem ? unless i will > create more datafiles to the tablespace ? ( and this last can only > happen manualy ). ?
Correct, and it would be utter madness to want datafiles of such a large size anyway, even if you were allowed them by your filesystem and/or koert's mathematics.
Large files means large backups (it's all or nothing at backup time, so if you have 1 16Gb file, and I have 8 2Gb files, you must back up all 16Gb, whereas I can get choosey and backup 1 2Gb file each night for a week and a bit).
Large files also mean large non-availability issues. When your 16Gb file gets corrupted, the entire 16Gb is off air until you fix it. When one of my 2Gb files goes wonky, I have 14Gb of data still usable and available whilst I'm performing my (much smaller/quicker) recovery.
Oracle allows you to have 1022 datafiles per tablespace: take advantage of their generosity.
Incidentally: it doesn't have to be a manual exercise to add the other files in. Enterprise Manager has a nifty set of alerts ("Events"), one of which is 'tablespace more than x% full'... and if triggered, you can get EM to carry out a "fixit job" ...which in this case would be 'add a new datafile'. And I dare say that shell scripters anonymous would have (or be able to develop) something very similar for the command-line buff.
Regards
HJR
> > >> >> In article <tvoe9.106911$8o4.14887_at_afrodite.telenet-ops.be>, koert54 >> wrote: >>>>> max of 2^10 datablocks = 4194304 >>> should be 2^22 >>> >>> "koert54" <nospam_at_spam.com> wrote in message >>> news:xuoe9.106909$8o4.14886_at_afrodite.telenet-ops.be...
>>>>
>>>> >>>>
>>>> >>>> >>> >>>Received on Sat Sep 07 2002 - 17:36:37 CDT