Home | Previous Page | Next Page   Tuning Configuration for Resource Usage >

Tuning Background-Process Parameters

Background I/O activities are those database server tasks that do not service SQL requests directly. Many of these tasks are essential for database consistency and other aspects of database server operation. However, they take up I/O bandwidth and might also require significant CPU virtual processor time, which takes time away from queries and transactions. As you configure background I/O activities, try to reduce their overhead.

Tip:
The USEOSTIME parameter specifies whether the database server uses subsecond precision when it gets the time for SQL statements. If database applications do not require subsecond precision, set USEOSTIME to 0 to avoid unnecessary calls to the operating-system clock. This parameter is rarely set to 1 because most applications do not require split-second time stamps and the overhead degrades performance. The USEOSTIME parameter can be modified by the onutil SET command with the server on-line.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]