Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
Property | Description |
---|---|
Parameter type | Integer |
Default value | If STATISTICS_LEVEL is set to ALL , then 5
If |
Modifiable | ALTER SESSION , ALTER SYSTEM |
Range of values | Unlimited |
TIMED_OS_STATISTICS
specifies (in seconds) the interval 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 recommends that you set this parameter in anALTER 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.