Re: Is it wise to create datafiles that use over 90% of the disk space?

There is not a problem with Oracle but I have had problems when attempting a DR on filesystems that were very full (20Mb left on an 9Gb filesystem). The setup was AIX 4.3 and although the filesystem size on the DR machine was identical to the production restores failed because AIX requires a certain amount of free disk space when copying/writing files. Im not an AIX expert so I can't quote the exact source of the problem but it's handy to allow yourself a little room on any filesystem (I tend to leave 100-150MB).

neil.

Stephanie Wood wrote in message ...
>Is it wise to create datafiles for Oracle on Unix (AIX) that fill the file
>systems over 90% full? Of course, I don't have autoextend on.
>
>My Unix background says never fill a file system > 90% full, but if the
>datafiles aren't growing does Oracle have a problem with this? i realize
>that you don't want ORACLE_HOME to fill up, or other
>areas.....
>
>Thanks!
>Stephanie
>
>
Received on Mon Nov 08 1999 - 05:04:18 CST