brm2015 Absent Member.
Absent Member.
272 views

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

0 Likes
2 Replies
Micro Focus Expert
Micro Focus 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.

 

 

0 Likes
brm2015 Absent Member.
Absent Member.

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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.