Skip to Content
0
Former Member
Dec 02, 2011 at 05:21 AM

oracle datafile autoextend on

143 Views

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