Xref: alice comp.databases.oracle.misc:17251
Path: alice!news-feed.fnsi.net!news.idt.net!howland.erols.net!ix.netcom.com!news
From: "Winnie Liu" <poohland@hotmail.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Parameters in INIT<SID>.ora file
Date: Tue, 7 Jul 1998 19:57:58 -0700
Organization: ICGNetcom
Lines: 22
Message-ID: <6numvs$aqn@sjx-ixn6.ix.netcom.com>
References: <35A2C201.DAD0DA3A@pacific.net.sg>
X-NETCOM-Date: Tue Jul 07  7:53:48 PM PDT 1998
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

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@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
>