About DATABASE

In this Document

SymptomsCauseSolution


Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms

- Freshly installed Oracle 10.2.0.1.0. and newly created database instance. 
- After approximately 4-5 hours of normal database operation, trace files start populating about once every minute.
- The significance of the messages at this time are unclear except that they indicate that no OS
statistics for CPU are being collected.

ERROR:
ksugetosstat failed: op = slsgetkstat, location = slsupdatesta (physmem)

Cause

The O/S statistics are not getting collected for some reason which is causing the file to be produced.

There has not been much information on this problem except that it is usually related to enabling and disabling CPUs on the box while the database is up and running. 

Once this has occurred that the database will stop collecting OS statistics at all.

Solution

To implement the solution, please execute the following steps:

1.Set the 'statistics_level=basic' database parameter
2. Bounce the database
3. Monitor for production of any new trace files after setting the 'statistics_level=basic' parameter.
4. If the problem persists, open a service request with Oracle Support Services to further investigate the issue.