Autoextend on/off

[Former Member]

Hi,

In NW2004s BI7, under windows 2003 server, oracle 10g plateform I am trying to change Autoextend On

1. login sql as system

2. SELECT * from dba_data_files where tablespace_name = 'PSAPSR3DB';

3. its shows all table name with path

4. ALTER DATABASE DATAFILE 'F:\ORACLE\PIP\SAPDATA4\SR3DB_1\SR1.DATA1' AUTOEXTEND ON;

5. ALTER DATABASE DATAFILE 'F:\ORACLE\PIP\SAPDATA4\SR3DB_2\SR1.DATA2' AUTOEXTEND ON;

6. ALTER DATABASE DATAFILE 'F:\ORACLE\PIP\SAPDATA4\SR3DB_3\SR1.DATA3' AUTOEXTEND ON;

COMMIT;

But when I check DB02 and Tablespace --> overview (still shows autoextend off)

how to I fixed that

Regards;

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[former_member204746]

go into DB02OLD

click on REFRESH

run both options.

this will update your DB02 values.

Normally, it is only updated twice a day, at 7am and 7pm.

[Former Member]

Hi,

In DB02 the status will change only when the background job "SAP_COLLECTOR_FOR_PERFMONITOR" run. This will one twice a day. This will collect the data and display it in DB02. Please check today evening or tomorrow morning so that you will get the correct status in DB02.

Thanks,

Chaitanya

[Former Member]

Hey thanks for all reply

Job is already run 2 times, even I run manual program using se38... also use DB02OLD and refresh both side, still no luck...

anyway! I will be restart database instance lets see.

Thanks again

[kishore_soma]

Hi,

Try commit and then you see, hope it will work

login to sqlplus

commit for 2 times

Then login to SAP, DB02old, then try to check.

Regards,

Kishore Soma

[Former Member]

Hi Kishore Soma,

Thanks for reply,

login sqlplus /as sysdba

I tried 10 times commit;

Restart SAP and DB instance

DB02OLD and refresh (perform database check and db check and updates)

Still PSAPSR3700 table space shows autoextend NO

any other clue... or what is the normal procedure to change autoextend YES

[anindya_bose]

iHi Angeline

Check this note https://service.sap.com/sap/support/notes/1331145

Regards

Anindya

[Former Member]

Hi there,

I follow that SAP notes,

Complete the following steps:

Go to transaction SE16

Display table PROGDIR for Name='LSDBORA3F01'.

Set field EDTX to blank.

Save

nothing happend and when I saved it asking for varient ?????????

thanks

[ImtiazKaredia]

Use SAP provided brtools to do the changes

[anindya_bose]

Angeline

When you see those datafile do you see that MAXSIZE and INCREAMENT_BY have been set for those data files?

You can use command >alter database datafile <'datafile name'> autoextend on next 200M maxsize 10000M;

Where Maxisize will be 10gb and increament will be 200mb. Or else use brtools for for changing the datafiles

Regards

Anindya

[Former Member]

Hi,

Once you stop SAP and Database and start again, it will show you the correct status...

Regards.

Rajesh Narkhede