Oracle Update stats for all tables once in a month - help required

[former_member190251]

Hello All,

Please let us know if we can run the below command once in a month for ECC and BW system

brconnect -u / -c -f stats -t all -f collect -p 4

Will it impact the performance of Oracle database 11.2.0.4.

Regards

S.subramani

[Former Member]

Hi Subbu,

Running update stats in fact will improve performance at some extent.

This will update the table statistics and will provide best possible path to excess records present in the tables.

If production system, than better have this schedule after business hours or best on weekends.

Regards,

Prithviraj.

[former_member182921]

It will not impact ,

Regards ,

Abhi

[Reagan]

>>Will it impact the performance of Oracle database 11.2.0.4.<<

My answer is a NO

[Former Member]

Hello Subbu,

Please check following SAP note :-

132861 - CBO: Statistics creation with SAPDBA or BRCONNECT

I hope this gives you lot of inputs

Regards

Anand

[Sriram2009]

Hi Subu.

You can run the DB statistics during off peak time, Refer the SAP Note FAQ 13

588668 - FAQ: Database statistics

Regards

SS