DB13 - Missing Update Statistics option

[Former Member]

In DB13 - Schedule an Action, this option is missing "UpdateStats Check and update optimizer statistics"

But the record exists in sdbac

Trans Code: SE16

Table: sdbac

Option: dbsys=ORACLE

STATS ORACLE * E UpdateStats Check and update optimizer statistics

How do I get it to show up as an option in DB13?

[fidel_vales · Accepted solution]

Hi William,

Can you post here all fields for the record?

also, what is your SAP version?

[Former Member · Accepted solution]

Kernel: 640, Patch Level: 80

SAP Versions: 610, 620, 630, 640

SHORTCUT STATS

DBSYS ORACLE

OPSYS *

LANGUAGE E

SHORTNAM UpdateStats

LONGNAME Check and update optimizer statistics

HOST

PTYPES S

CTYPE EXT

CNAME BRCONNECT

PSTRING -u / -c -f stats -f monit -t @,[]S

DURATION

ATYPE

EXT1 J

EXT2 9100

EXT3

BEGREL 610

ENDREL

BEGDBREL 8.0.0.0.0

ENDDBREL

ACTMODE

[former_member193294 · Accepted solution]

Hi William

you can check these profile parameters in init<SID>.ora file are not set:

optimizer_mode = choose

optimizer_index_cost_adj = 10

optimizer_features_enable = 9.2.0

You can also check on Note 540021 for any other required parameter which might be missing.

Check also once again in SE16 ->SDBAC whether the line of Update Statistics is in German and maybe the English one is missing.

Rgds,

Loukas

[Former Member · Accepted solution]

I am using Oracle 10.2.0.2

[Former Member · Accepted solution]

looks like you are hitting the 'problem' documented by SAP note 918877

[Former Member · Accepted solution]

To manually change this record in sdbac, what would I need to change?

SHORTCUT STATS

DBSYS ORACLE

OPSYS *

LANGUAGE E

SHORTNAM UpdateStats

LONGNAME Check and update optimizer statistics

HOST

PTYPES S

CTYPE EXT

CNAME BRCONNECT

PSTRING -u / -c -f stats -f monit -t @,[]S

DURATION

ATYPE

EXT1 J

EXT2 9100

EXT3

BEGREL 610

ENDREL

BEGDBREL 8.0.0.0.0

ENDDBREL

ACTMODE

[madhukara_shenoy · Accepted solution]

Hello William,

You can change this from the transaction Se16--> SDBAC --> select the below mentioned row --> go to change mode --> reset the column BEGDBREL and ENDDBREL

In your case

BEGDBREL 8.0.0.0.0

ENDDBREL

So you only need to reset BEGDBREL. (that means BEGDBREL should be blank)

After this your Db13 display issue should be solved.

Regards,

Madhukar