Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace, Please help
Hello Erwin,
Thank for your respond.
I wonder, what the Autoextend Yes will do (My Question 1), will it create
the new Datafile itself, or it will extend accordingly ? what are the
storage parameter it will extend ?
Thanks.
Erwin Dondorp <erwin_at_dondorp.com> wrote in message
news:39AD2D7B.42E2D6D1_at_dondorp.com...
> Johnson wrote:
> > - DATA tablespace - the free space only leave 0.13 percent, what should
I do
> > ? The autoextend is set to Yes
> Do nothing. The autoextend will allocate all the space that is needed.
>
> > - When we create the tablespace, the autoextend clause is refer to
datafile
> > or tablespace?
> autoextend always refers to a datafile.
>
> > - There are 3 datafiles in the DATA tablespace, all are set to
> > autoextendable YES, how the raw data are write to this datafiles.
> Oracle uses a sort of round-robin technique to allocate space in all
> the datafiles for a tablespace.
>
> > - Why 3 datafiles, can it be only 1 Datafiles
> The 3 files might reside on a different disk for example.
> This giving better performance.
> Another reason is that if one data file gets corrupted by a bad spot on
> the disk, you only need to restore and recover that (relatively) small
> file.
>
> Erwin
Received on Fri Sep 01 2000 - 03:37:16 CDT
![]() |
![]() |