Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Statistics Calculation Service information

Highlighted
brm2015
Regular Collector

Oracle Statistics Calculation Service information

Hello All,

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.

Thanks,
BRM

2 REPLIES
Etienne_Canaud
HPE Expert

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.

Thanks,

Etienne.

 

 

brm2015
Regular Collector

Re: Oracle Statistics Calculation Service information

Hello Etienne,

Thanks for your information. But didn't get information on where these logs will be stored in PPM. Can you please let me know if you have any idea on this.

If this service is not useful then this can be removed from PPM newer versions by HP right. 

Thanks,

BRM

//Add this to "OnDomLoad" event