changing "stats_change_threshold paramater"

[Former Member]

I am trying to change this parameter's value using BRCONNECT.

In SAP library this is what i found but there is no full command to run this.

http://help.sap.com/saphelp_bw30b/helpdata/en/cb/f1e33a5bd8e934e10000000a114084/content.htm

The other way would be to make a change in INIT.sap and i am not sure if a restart is require after making the change.

Any help!!

Thanks.

Shawn

[fidel_vales · Accepted solution]

Hi,

You cannot change (permanently) that parameter via BRCONNECT

1) if you want to set it (permanently) to 25 (for example) you have to edit the file ini<sid>.sap and set it there (or modify the line already exisintg)

> stats_change_threshold = 25

Finally (forgot), no oracle/sap restart is required. Next execution of BRCONNECT will read the parameter file

2) the link you show is to change the parameter for the "current" execution of BRCONNECT (dimissing the value on the init<sid>.ora). For example, to change it to 90:

BRCONNECT -u / -c -f stats -t all -c 90

Edited by: Fidel Vales on Apr 9, 2009 5:50 PM

[Former Member · Accepted solution]

Thanks Fidel.

I did change the value in INIT<SID>.sap but i am not sure if it was already commented out. Unless that is how all the parameters are listed in the init.sap.

Do i need to take out the # sign?

1. default: 50%

2. stats_change_threshold = 40

3. number of parallel threads for updating statistics

4. default: 1

[stefan_koehler · Accepted solution]

Hello Shawn,

> Do i need to take out the # sign?

Yes, you have to remove this.

Regards

Stefan