Oracle 参数 TIMED_OS_STATISTICS 官方解释，作用，如何配置最优化建议
本站中文解释
TIMED_OS_STATISTICS参数用于控制Oracle在记录每条SQL语句的执行时间时，是使用统计数据库层的时间还是使用操作系统层的时间。
默认值是FALSE，即使用数据库层的时间。
如果设置为TRUE，则使用系统层的时间，它不仅能够把执行SQL语句消耗的时间记录到数据库层，还可以把系统层消耗的时间记录下来。
如果要正确设置TIMED_OS_STATISTICS，首先要确定该参数是否在当前数据库参数中。
如果该参数存在，则需要设置该参数，如果不存在，则可以添加该参数，在新增参数时要注意设置类型是Boolean，并且设置的值是TRUE。
最后，在设置TIMED_OS_STATISTICS参数完成后，可以利用其他检测手段，来验证该参数是否正常工作，如果出现问题，可以及时调整参数值。
官方英文解释
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.
| Property | Description |
|---|---|
|
Parameter type |
Integer |
|
Default value |
If If |
|
Modifiable |
|
|
Modifiable in a PDB |
Yes |
|
Range of values |
Unlimited |
|
Basic |
No |
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 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.
See Also:
Oracle Database
Performance Tuning Guide for more information about this parameter
