Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Initialization Parameters, 181 of 188


TIMED_OS_STATISTICS

Parameter type: 

Integer 

Parameter class: 

Dynamic. Scope = ALTER SYSTEM. 

Default value: 

0  

Range of values: 

Unlimited 

TIMED_OS_STATISTICS specifies the interval (in seconds) at which Oracle collects operating system (OS) statistics when a request is made from the client to the server or a request completes.  

  • On dedicated servers, Oracle collects OS statistics at user logon and after each subsequent client invocation through the OCI into the Oracle server as a remote procedure call message.

  • On multi-threaded servers, Oracle collects statistics when client calls to Oracle are processed.

A value of zero specifies that OS statistics are not gathered. To collect statistics, set a value meaningful for your application and site needs. 

Note: Gathering OS 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. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index