Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Deleting obsolete datafiles
Howard J. Rogers wrote:
>
> "Dennis Bieling" <dennis.bieling_at_epigenomics.com> wrote in message
> news:bp2n5o$8q8$3_at_broglie.epigenomics.epi...
> >
> > To me this is much more easy, as there is no extent in
> > the datafile already, so I set it to the smallest possible
> > size, which was 16K in this example. So there is not enough
> > space for oracle to create an extent in it and therefore it is kind of
> > unusable.
> >
>
> Still gets checkpointed, though.
>
> Regards
> HJR
The solution in this case is to add more and more datafiles, thus the
overhead of checkpointing the obsolete one becomes a smaller and smaller
percentage of that overhead :-)
Received on Mon Nov 17 2003 - 07:02:54 CST