Parameter type
|
Integer
|
Default value
|
If STATISTICS_LEVEL is set to ALL , then 5
If STATISTICS_LEVEL is set to BASIC or TYPICAL , then 0
|
Parameter class
|
Dynamic: ALTER SESSION , ALTER SYSTEM
|
Range of values
|
Unlimited
|
TIMED_OS_STATISTICS
specifies the interval (in seconds) at which Oracle collects operating system statistics when a request is made from the client to the server or when a request completes.
- On dedicated servers, Oracle collects operating system statistics at user logon and after each subsequent client invocation through the OCI into the Oracle server as a remote procedure call message.
- On shared servers, Oracle collects statistics when client calls to Oracle are processed.
A value of zero specifies that operating system statistics are not gathered. To collect statistics, set a value meaningful for your application and site needs.
Note:
Gathering operating system statistics is very expensive. Oracle Corporation recommends that you set this parameter in an ALTER SYSTEM statement rather than in the initialization parameter file, and that you reset the value to zero as soon as the needed statistics have been gathered.
|