oracle datafile autoextend on

[Former Member]

Hii,

I add a new datafile below this command.

alter tablespace PSAPSR3 add datafile '/oracle/ORP/sapdata7/sr3_28/sr3.data28' size 10000M autoextend on next 2000M maxsize 30000M

can any one tell me now its file size is app. 14 GB.

how much size it increse after full.

and if the datafile size is large it arise perfomance issue.

Regrds,

Vivek

[former_member188883]

Hi,

It can increase upto any size until you have space in /oracle/ORP/sapdata7 Or

There is a restriction on the OS side about maximum file size it can create viz 32GB, 64 GB etc etc.

Related to performance there won't be much issues. But I feel there could be issues during backing up datafiles and restoring the same. Many of the tape devices won't be able to backup such large files and restore the same.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

thanks all.

[Former Member]

> how much size it increse after full.
> and if the datafile size is large it arise perfomance issue.

Hello,

When goes full, increment will be by 2 GB (as suggested by 'next 2000M').

No performance issues will arise.

Thanks