Re: Tablespace, Please help

From: Erwin Dondorp <erwin_at_dondorp.com>
Date: Wed, 30 Aug 2000 17:51:23 +0200
Message-ID: <39AD2D7B.42E2D6D1@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 Wed Aug 30 2000 - 10:51:23 CDT