st04 oracle table statistics missing

[Former Member]

Hi expert,

  Our oracle database upgrade from 11.2.0.3 to 11.2.0.4, then I find lots of oracle  tables statisticses missing

Then I update statistic with program rsanaora. But the system issue the same problem in st04 and I cannot see the talbe statistics. But I check the Execution Plan with ST05, then I can see the table statistics below:

But the Execution Plan is still TABLE ACCESS FULL COBRB. But the Execution Plan is executed with index COBRB~1 before the oracle database upgrade below:

SELECT STATEMENT ( Estimated Costs = 46,801 , Estimated #Rows = 479,147 )

       2 TABLE ACCESS BY INDEX ROWID COBRB
         ( Estim. Costs = 46,801 , Estim. #Rows = 479,147 )
         Estim. CPU-Costs = 861,454,494 Estim. IO-Costs = 46,777
         Filter Predicates

           1 INDEX RANGE SCAN COBRB~1
             ( Estim. Costs = 1,714 , Estim. #Rows = 479,147 )
             Search Columns: 2
             Estim. CPU-Costs = 110,024,584 Estim. IO-Costs = 1,711
             Access Predicates

Can any expert help me ? Thanks  l lot.

[Former Member · Accepted solution]

have you followed the DB upgrade guide? you should complete the post upgrade activites as mentioned in point chapter 5. go through the guides from https://service.sap.com/~form/handler?_APP=00200682500000002672&_EVENT=DISPLAY&_SCENARIO=01100035870...

[Former Member · Accepted solution]

Hi Sunil,

     Thanks for your support. Our team upgraded the oracle database as the upgrade guide. I check the brtool version below:

GVSHG501:hg5adm 51> brtools -V
BR0651I BRTOOLS 7.20 (36)

Patch   Date     Info

  1  2010-01-26  BR*Tools support for Oracle 11g (note 1430669)
  9  2010-10-27  BR*Tools support for eSourcing databases (note 1523205)
18  2011-09-07  BR*Tools support for Oracle ASM and Exadata (note 1627541)
25  2012-06-28  Corrections in BR*Tools 7.20 patch 25 (note 1735811)
26  2012-09-12  Corrections in BR*Tools 7.20 patch 26 (note 1763972)
27  2012-09-12  Support for secure storage in BR*Tools (note 1764043)
28  2012-10-25  Corrections in BR*Tools 7.20 patch 28 (note 1780057)
29  2012-12-03  Corrections in BR*Tools 7.20 patch 29 (note 1795814)
30  2013-01-31  Corrections in BR*Tools 7.20 patch 30 (note 1816874)
31  2013-03-26  Corrections in BR*Tools 7.20 patch 31 (note 1838852)
32  2013-05-28  Corrections in BR*Tools 7.20 patch 32 (note 1865897)
33  2013-07-03  Corrections in BR*Tools 7.20 patch 33 (note 1882181)
34  2013-09-05  Corrections in BR*Tools 7.20 patch 34 (note 1909451)
35  2013-11-14  Corrections in BR*Tools 7.20 patch 35 (note 1940675)
36  2014-02-24  Corrections in BR*Tools 7.20 patch 36 (note 1983045)

release note               1428529
kernel release             720
patch date                 2014-02-24
patch level                36
make platform              linuxx86_64
make codeline              721_REL
make mode                  OCI_102
make date                  Mar 29 2014

The version of the Brtools is not the latest . Should I upgrade the brtools to the latest version and update statistics again?  Thanks a lot.

[Former Member · Accepted solution]

you can upgrade the brtools to latest verion.

I hope your DB team also perfomed the post upgrade steps as per the upgrade guide. If these steps not done then you may get performance and other issues.

your system is on UNIX, please follow https://service.sap.com/~sapidb/011000358700000333942010E/GUIDE_UX_ORA_UPGR_112_400.pdf

[Former Member · Accepted solution]

Hi expert,

   We upgrade the brtools tool from 720Patch36 to 720 Patch 41 and we update the table statistics. Then I check the log with DB14, but the system issue below error:

SXPG_COMMAND_EXECUTE failed for BRTOOLS - Reason: program_start_error: For More Information, See SYS

Message no. Q2233

Diagnosis

This message includes variables. No additional information can be specified.

[former_member207186 · Accepted solution]

Hi,

Regarding this issue, firstly please check carefully the below SAP KBA for troubleshooting:
1914589 - SXPG_COMMAND_EXECUTE failed when start job from DB13/DBACOCKPIT

Please also check the backend configuration

DB13 -> Goto -> Back-End Configuration

DB13 -> Goto -> Back-End Configuration -> Administration

Regards,

Bíborka

[Former Member · Accepted solution]

Hi Sunil,

   The issue had been solved. We migrated our Oracle Database from single instance to RAC . Then the system issue the table statistics missing in st04. Then I implement one note 1382156 in our system of HG5. And the system is ok now.