Update stats in 4.6c with 10.2.0.2

[Former Member]

Hi All,

We have SAP R/3 on 4.6c and DB on Oracle 10.2.0.2, we have scheduled Update stats in DB13 for every day , the job is sucessfully completing with the below command.

brconnect -u / -c -f stats -t all -f nocheck

There are 31 tablespaces in our R/3 production, the update stats log are not showing the update stats of all 31 tablespaces only 8 or 9 i am able in see in the log.

Please clarify how brconnect works, it will collect stats only on the tablespaces which have changes in data or all the Tablespaces .

How to check the tables when the stats have been updated means the date when stats collected on the table.

Thanks,

Subhash.G

[Former Member · Accepted solution]

Hi,

Can you try by below command.

brconnect -u / -c -f stats -t all -f collect -p 4 . This will collect stats for all tables. To schedule stats job daily run brconnect -u / -c -f stats -t ALL.

Also check below link & sap notes.

http://help.sap.com/erp2005_ehp_04/helpdata/DE/11/53e43a744ebe14e10000000a11402f/frameset.htm

588668 FAQ: Database statistics

651812 FAQ: BR*TOOLS and SAPDBA

Hope this helps.

Thanks

Sushil

[Former Member]

thanks

[Former Member]

you can see in db24 tcode and also in job log also.

regards,

nagaraju