DB13 is missing option to optimize statistics

[Former Member]

How can I get DB13 to have the option to optimize statistics.

The oracle version is 10.2.0.2

[Former Member · Accepted solution]

Hi William,

Goto DB13 --> Select Date on which you want to schedule it --> Select Check and update optimizer statistics

[Former Member · Accepted solution]

The option "Check and update optimizer statistics" is missing.

That is my original question.

[former_member204746 · Accepted solution]

you are probably still using an older SAP version such as 4.0b or 4.5b.

is that the case?

[Former Member · Accepted solution]

We are using SAP ECC 6.0

(Kernel 700)

[fidel_vales · Accepted solution]

Long time I do not check some error like this.

Can you go to se16

table sdbac

dbsys=ORACLE

can you see if in the list appear the "missing" option?

something Like:

STATS ORACLE * E UpdateStats Check and update optimizer statistics

If so, double click on it and paste here all the fields.

Forgot to ask.

It is a new installation or an upgrade?

If it is an upgrade, from which version?

Thanks

Message was edited by:

Fidel Vales

[Former Member · Accepted solution]

The line was in German.

The English line was missing.

I added the English line.

It is working now!

Thanks!

[fidel_vales · Accepted solution]

Thanks for the info.

I imagined it was something in that area but didn't know what.

Goot to hear the solutionfor next time

[Former Member]

Hi William,

Jus a simple querry can you pl sy in details what are and the options those are available.

Regards

[Former Member]

Dear William

Maybe the parameter is not set in init<SID>.ora file. Check this file for optimizer enable parameter as to

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.

Hope it helps.

Regards

Lokesh Gupta

[Former Member]

can you call the transaction DB13? Which SAP Kernel do you have? From SAP Kernel 7.00 SP 12 the transaction dbacockpit replaces some transactions like DB13, DB02, ST04 etc... Old DB13 you can call by db13old. Did I understand your question maybe wrong?

[Former Member]

Can you call the transaction DB13?

Yes

Which SAP Kernel do you have?

7.00

Oracle 10.2.0.2

From SAP Kernel 7.00 SP 12 the transaction dbacockpit replaces some transactions like DB13, DB02, ST04 etc... Old DB13 you can call by db13old.

I can call DB13, DB13OLD & DBA Cockpit but the option to update statistics is no longer there to choose from.

[Former Member]

there is and must be an option in DBACOCKPIT to create new statistics. Maybe your DBA Cockpit doesn't work correct.

See please the SAP Notes:

1028624 - Overview of DBA Cockpit for Oracle

1084146 - Planning calendar: Incorrect selection in the list box