Oracle Statistics Calculation Service is running on PPM Server, but where to find the logs related to this service. I didn't find more information on this log file in PPM Installation and Administration guide or PPM Upgrade guide. Please provide more information on this.
Re: Oracle Statistics Calculation Service information
Hi BRM, What this service is doing is basically calling the PL/SQL procedure KNTA_UTIL.BuildStats(...), which in turn will call dbms_stats.gather_schema_stats( ... ).
It was introduced a long time ago (in the Oracle 8 days) when DB Statistics had to be regularly updated for ensuring good performance for databases running in CBO mode, but later Oracle versions and competent DBAs make it that this background service is now typically useless and can be disabled most of the time.