Re: Parameters in INIT<SID>.ora file

From: Winnie Liu <poohland_at_hotmail.com>
Date: Tue, 7 Jul 1998 19:57:58 -0700
Message-ID: <6numvs$aqn@sjx-ixn6.ix.netcom.com>

when you turn the timed_statistics to TRUE, oracle will add the "time" on those statistics views like v$waitstat, v$filestat and so forth. Those views may tell you how long the transaction have to wait for the resources and so on. Of course, it will definitely add some overhead on the server.

Winnie Liu
DBA
Unihealth, CA

Teo Wee Liang wrote in message <35A2C201.DAD0DA3A_at_pacific.net.sg>...
>Hello there,
>
>Was wondering, can anyone tell me the use of setting the
>timed_statistics parameter to TRUE in a INIT<SID>.ora file??
>
>
>Thanx in advance!!
>
>Caleb TEo
>
Received on Tue Jul 07 1998 - 21:57:58 CDT