Skip to Content
avatar image
Former Member

Change SAPINST settings for SAP ERP on Oracle

Hi!

I successfully installed SAP ERP (Win X86, 64 Bit) with Oracle 10.2.0.4 via system copy.

So I installed the SAP system with SAPINST and with their typical recommended settings.

As result some tablespaces have up to 27 directories (SR3_01.. SR_27) and the maximum growth of all the tablespaces is 2GB.

Question:

1) Can I change this Tablespaces settings in order to have less ammount of tablespaces with tablespaces growth of 1o GB?

2) The autoextend of Tablespaces is "on". Should I change this?

3) What are other recommended settings for Oracle that should be changed after SAPINST?

Thank you very much!

regards

Jürgen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 29, 2009 at 05:30 PM

    1) yes, and you should

    2) leave it at ON

    3) it all depends on your company's choices.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You can generate the sql for the resize with this sql:

      select 'alter database datafile '''||file_name||''' resize 10g;'
      from dba_data_files;

      Do not forget about the tempfile, just substitute data with temp everywhere. You might want to disable autoextend afterwards. Taken from here:

      Best regards, Michael

  • Apr 29, 2009 at 05:31 PM

    Hello J├╝rgen,

    1) Can I change this Tablespaces settings in order to have less ammount of tablespaces with tablespaces growth of 1o GB?

    You can not change the "amount" of tablespaces. But i think you mean if you can change the amount of data files within a tablespace - and here the answer is "yes you can". We also have all data files with auto extend to a max size of 10 GB.

    2) The autoextend of Tablespaces is "on". Should I change this?

    Why should you do that (beside of sizing it manually). Just let it auto extend.

    3) What are other recommended settings for Oracle that should be changed after SAPINST?

    SAPnote #830576 - Parameter recommendations for Oracle 10g

    SAPnote #974781 - Oracle database 10g: Internal maintenance jobs

    SAPnote #838725 - Oracle Database 10g: New database statistics

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 30, 2009 at 12:12 PM

    with SAPINST, go in advanced DB configuration and change settings to whatever you want.

    Add comment
    10|10000 characters needed characters exceeded