Skip to Content
0
Jul 06, 2006 at 08:47 PM

New performance settings in SPRO (2004s)

35 Views

Hello,

Does anyone know how we should set the parameters in SPRO for maximum performance? NOTE: We are running on Oracle 10g.

According to note 938040, these parameters should replace the DB_STATISTICS entry we used to have in RSADMIN. Is this true?

There are actually 2 sections in SPRO:

1. A global section in SPRO/SAP NetWeaver/Business Intelligence/Performance settings/Settings for Database Interfaces.

The way I understand this section is that if your DBMS is able to handle histograms, you don't have to tick the check box. Assuming we run the stats in Oracle on a daily basis, is it okay to leave the checkbox unchecked?

2. In the Oracle specific section in SPRO/SAP NetWeaver/Business Intelligence/Performance settings/Settings for Database Interfaces (Oracle).

From what I read through the help, we can speed up the index rebuild by unchecking the "Logging while index" check box. We've done some testing in C&B and so far so good for this one (we are about to test it in PROD). However, with the "Degree" field, wether we put 0 or 8 in it and we launch a massive aggregate, we haven't seen any difference. Does anyone has any experience with that field?

Thanks in advance,

D.