Re: Autoextend situation with multiple datafiles

On Jan 11, 7:34 am, alainde..._at_skynet.be wrote:
> I'm running Oracle 9 on Solaris system and one of the partition
> containing a datafile become full.
> I have 2 solutions to resolve my problem : first extend the metadevice
> (extend the volume in disksuite) so that the datafile may autoextend,
> or add a new datafile.
> Does anyone can tell me which solution is the better one ? What impact
> do these solutions have to the perfomance ?
>
> If I add a new datafile, how will the datafile(s) extend ? At present
> time the datafile is in autoextend on. If I add a second one with
> autoextend on, will the first still extend too ? Do I need to alter the
> first datafile to autoextend off ?
>
> Regards

The "best" choice depends on several factors such as the maximum OS file size for your platform, the maximum Oracle file size which depends on the tablespace block size in use, your backup plan and storage medium.

The objects stored in the tablespace and their usage patterns may also be a consideration.

If you are using raw partitions your administrator may also want to define all partitions in specific sizes such as 512M, 1024M, 2048M, 4096M or similar.

Only you can determine how you would like to manage your file system.

HTH -- Mark D Powell -- Received on Thu Jan 11 2007 - 11:14:15 CST