Auto Extend Off - System Impact and procedure

[Former Member]

Hi Team,

We have done the DB Reorg and noticed that continuos freespace was not enough because of the auto allocation settings..

Could you pls let us know the system impact if we turn off the auto extend in Production system..

We are using SAPDBA , Oracle 8i ,SAP 4.6c..

Pls provide ur valuable suggestions..

If possible pls let us know the procedure to turn off the auto extend..

Regds,

Satyanarayana N.

[Former Member · Accepted solution]

Hi

For turning OFF the autoextend, you can use following query:

alter database datafile 'file_name' autoextend off;

file_name is full path for the data file including file name.

Regards

Rahul

Edited by: Rahul Deo on May 19, 2008 2:02 PM

[JPReyes]

The impact will be that you'll need to constant monitor the tablespaces on DB02 and extend manually when required. You'll also have do preventive extention when a large bulk of data is expected.

Regards

Juan

[Former Member]

Hello Satya,

In addition to what Juan has said well you can set up CCMS alerts in RZ20 to warn you about tablespace limit.

SAP CCMS Admin Workplace>Database><sid>><dbtype>>Space Management-->Tablespace.

Regards.

Ruchit.