on 06-17-2008 10:19 AM
Hi friends,
I want to create a statistics for MSEG table in production server, because its not up to date.
Total no. of entries available in table is 2,30,000.
My O/S windows2003 (cluster)/oracle9.2/ ECC 5.
I need a step by step procedure to build or create statistics using DB20.
Regards,
s.senthil kumar
Hello Senthil,
just call transaction DB20 -> fill the field table with MSEG -> Statistics -> Create statistics
After that you can check the statistic via DB14 -> BRConnect
If you do this via DB20 the following command is executed in the background:
brconnect -u / -c -f stats -o SAPSR3 -t MSEG -f allsel,collect,keep
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi stefan,
Thanks 4 ur reply.
I need some more clarification on db20.
Wt are the values I have to give on following fields.
New method and new sample size.
anyfields or chek box I need to fill before create new statistics?
My current screen values on following fields.
new method = 'C'. new sample size = ' '.
old method = 'C'. old sample size = ' '.
Old Number 5,965 Deviation Old -> New 3,669
New Number 24,834 Deviation New -> Old 97-
Inserted Rows 0 Percentage Too Old 0
Changed Rows 0 Percentage Too Old 0
Deleted Rows 0 Percentage Too New 0
Use A
Active Flag A
Analysis Method C
and history check box is marked.
Can I run DB20 while server is running or at peak time?
Regards,
s.senthil kumar
Hello,
> anyfields or chek box I need to fill before create new statistics?
No, just enter the table name press enter and then go to "Statistics -> Create statistics".
SAP has its own logic how the statistics are gathered:
http://help.sap.com/saphelp_nw70/helpdata/en/f4/81e93a637bfd70e10000000a11402f/content.htm
> Can I run DB20 while server is running or at peak time?
Yes you can run it while the server is running..
But think about it.. the new statistics are valid for new parsed statements only.. you can invalidate the old references in the shared pool or you can just wait until they are aged out and reparsed.
Regards
Stefan
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.