cancel
Showing results for 
Search instead for 
Did you mean: 

update the stastics of tables BKPF and GLFUNCA

mohsin_m3
Participant
0 Kudos

Hello All,

update the stastics of tables BKPF and GLFUNCA not updataing

I have execute via Brtools

7 - Database statistics >> 1 = Update database statistics >> 9 ~ Tables for update (table) ......... [BKPF]

same for table GLFUNCA

7 - Database statistics >> 1 = Update database statistics >> 9 ~ Tables for update (table) ......... [GLFUNCA]

But in .sta file it is not collected

<DB20>

Table GLFUNCA

Statistics are current (|Changes| < 50 %)

New Method E

New Sample Size P1

Old Method E Date 17.08.2008

Old Sample Size P1 Time 19:52:15

It is one year old , so please help me how to update this table

Is this table causing performance problem for job RSUVM007

Regards

Mohsin M

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Before all,

Why do you wnat to calculate statistics on those tables?

Do you have performance problems and you have identified that they are caused by "bad" statistics?

or simply you "must" collect them because they are "OLD"?

If it is the latter, remember that statistics MUST be representative not current. Please read the SAP Note 825653 "Oracle: Common misconceptions" point 7

Regarding the options of BRtools, it works as designed.

BRCONNECT will check if the table needs statistics:

- if it has changed more than 50% since last time (in your case 17.08.2008) and, if so it will do, otherwise it will not do it. See the output of DB20 that you pasted:

> Statistics are current (|Changes| < 50 %)

IF you need new statistics (and I mean, need, not like) then you have to force them. On BRTOOLS you go to the next screen and choose the option:

> 7 ~ Force options (force) ............... []

In your version/patch could be located in a different place

and here input collect

I strongly recommend you to read the BR*tools documentation as ALL this information is there.

In case you do not know where to find it, it is quite easy:

=> Oracle DBA Overview => SAP Database Guide: Oracle

mohsin_m3
Participant
0 Kudos

Hello Fidal,

Thanks a lot for your help.

Yes you are right >> if it has changed more than 50% since last time (in your case 17.08.2008) and, if so it will do, otherwise it will not do it.

Issue is not related to update the stastics of tables BKPF and GLFUNCA(performance problems and you have identified that they are caused by "bad" statistics?)

It seems to be functional issue.

Thank you once again for proper solution

Regards

Mohsin M

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi mohsin,

You can use DB20.

Regards

Ashok Dalai