Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Managing Large tablespaces
"Steve S" <stevens_at_coloradocustomware.com> wrote in message
news:bafba412.0207130444.407a0c4f_at_posting.google.com...
> Richard,
> So you would recommend breaking up a large tablespace into many
> smaller (2 GB)datafiles for manageability. Is there a performance hit
> in spanning a tablespace across many datafiles over having one big
> file?
>
> THanks for your help,
> Steve
>
PMFJI.
I agree with Richard, and moreover I tend towards the conservative. I like
2000M datafiles, rather than 2GB, as I'm slightly nervous of files which end
exactly on a boundary.
Just my 2c, and HTH,
Paul
Received on Sat Jul 13 2002 - 14:45:02 CDT