| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Timed_statistics, True or False
--=====================_690252130==_.ALTContent-Type: text/plain; charset="us-ascii"; format=flowed
I believe if you want to set timed_statistics on for everyone, you have to do that through the initialization parameters. But you can set it for your session.
ALTER SESSION SET TIMED_STATISTICS=FALSE; should do the trick.
Good luck,
Lyall Barbour
At 03:07 AM 8/22/00 -0800, you wrote:
>Hi,
>
>I just did a :
>
>alter system set timed_statistics = false ;
>
>and got the following error :
>
>alter system set timed_statistics = false
> *
>ERROR at line 1:
>ORA-02065: illegal option for ALTER SYSTEM
>
>Running Oracle 7.2.3 on HP-UX 10.20
>Is this not a dynamic option ???
>
>Greets,
>
>Kirsten
>
> > -----Original Message-----
> > From: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
> > Sent: Tuesday, August 22, 2000 11:08 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Timed_statistics, True or False
> >
> > You lose some statistical information, useful in finding performance and
> > other problems. So.... if you turn it off (and you should on HP-UX), and
> > you
> > have a problem, you would turn it on, wait for the problem to re-occur
> > (and
> > do bstat/estat and investigation) and turn it off.
> >
> > So in effect, if you have problems, it will take you somewhat longer
> > (possibly) to resolve them
> >
> > In your case, I would turn it off.
> >
> >
> > Rachel
> >
> >
> > >From: "Weerd Kirsten, E.C. de" <Kirsten.deWeerd_at_Oranjewoud.nl>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: RE: Timed_statistics, True or False
> > >Date: Mon, 21 Aug 2000 23:36:38 -0800
> > >
> > >I'm running Oracle 7.2.3 on HP-UX 10.20 and frankly don't like the idea
> > of
> > >a
> > >possible performance degradation of 12% because of one parameter set
> > TRUE.
> > >
> > >But, new as I still am, can anyone tell me : What exqctly do I loose when
> > >turning this timed_statistics to FALSE ???
> > >
> > >Thanx for the info.
> > >
> > >Greets,
> > >
> > >
> > >Kirsten
> > >
> > > > -----Original Message-----
> > > >
> > > > Winnie,
> > > >
> > > > With one notable exception you are right. For some reason, on HP-UX
> > > > systems,
> > > >
> > > > turning on timed_statistics can cause a performance degradation that
> > is
> > > > noticeable (I've heard up to 12%)
> > > >
> > > > Rachel
> > > >
> > >--
> > >Author: Weerd Kirsten, E.C. de
> > > INET: Kirsten.deWeerd_at_Oranjewoud.nl
> > >
> > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > >San Diego, California -- Public Internet access / Mailing Lists
> > >--------------------------------------------------------------------
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from). You may
> > >also send the HELP command for other information (like subscribing).
> >
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>--
>Author: Weerd Kirsten, E.C. de
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
--=====================_690252130==_.ALTContent-Type: text/html; charset="us-ascii"
<html>
I believe if you want to set timed_statistics on for everyone, you have
to do that through the initialization parameters. But you can set
it for your session.<br>
<br>
ALTER <b>SESSION </b>SET TIMED_STATISTICS=FALSE;<br>
<br>
should do the trick.<br>
<br>
Good luck,<br>
Lyall Barbour<br>
<br>
At 03:07 AM 8/22/00 -0800, you wrote:<br>
<blockquote type=cite cite>Hi,<br>
<br>
I just did a :<br>
<br>
alter system set timed_statistics = false ;<br>
<br>
and got the following error :<br>
<br>
alter system set timed_statistics = false<br>
*<br>
ERROR at line 1:<br>
ORA-02065: illegal option for ALTER SYSTEM<br>
<br>
Running Oracle 7.2.3 on HP-UX 10.20<br>
Is this not a dynamic option ???<br>
<br>
Greets,<br>
<br>
Kirsten<br>
<br>
> -----Original Message-----<br>
> From:<x-tab> </x-tab>Rachel Carmichael [SMTP:carmichr_at_hotmail.com]<br> > Sent:<x-tab> </x-tab>Tuesday, August 22, 2000 11:08 AM<br>> To:<x-tab> </x-tab>Multiple recipients of list ORACLE-L<br>
> (and <br> > do bstat/estat and investigation) and turn it off.<br> > <br> > So in effect, if you have problems, it will take you somewhat longer<br>
> (possibly) to resolve them<br> > <br> > In your case, I would turn it off.<br> > <br> > <br> > Rachel<br> > <br> > <br> > >From: "Weerd Kirsten, E.C. de" <Kirsten.deWeerd_at_Oranjewoud.nl><br> > >Reply-To: ORACLE-L_at_fatcity.com<br> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com><br> > >Subject: RE: Timed_statistics, True or False<br> > >Date: Mon, 21 Aug 2000 23:36:38 -0800<br> > ><br> > >I'm running Oracle 7.2.3 on HP-UX 10.20 and frankly don't likethe idea<br>
> of <br> > >a<br> > >possible performance degradation of 12% because of one parameterset<br>
> TRUE.<br> > ><br> > >But, new as I still am, can anyone tell me : What exqctly do Iloose when<br>
> >turning this timed_statistics to FALSE ???<br> > ><br> > >Thanx for the info.<br> > ><br> > >Greets,<br> > ><br> > ><br> > >Kirsten<br> > ><br> > > > -----Original Message-----<br> > > ><br> > > > Winnie,<br> > > ><br> > > > With one notable exception you are right. For some reason,on HP-UX<br>
> > > systems,<br> > > ><br> > > > turning on timed_statistics can cause a performancedegradation that<br>
> is<br> > > > noticeable (I've heard up to 12%)<br> > > ><br> > > > Rachel<br> > > ><br> > >--<br> > >Author: Weerd Kirsten, E.C. de<br> > > INET: Kirsten.deWeerd_at_Oranjewoud.nl<br> > ><br> > >Fat City Network Services -- (858)538-5051 FAX: (858) 538-5051<br>
> >--------------------------------------------------------------------<br> > >To REMOVE yourself from this mailing list, send an E-Mailmessage<br>
________________________________________________________________________<br>> Get Your Private, Free E-mail from MSN Hotmail at <a href="http://www.hotmail.com/" eudora="autourl">http://www.hotmail.com</a><br>
> <br> > -- <br> > Author: Rachel Carmichael<br> > INET: carmichr_at_hotmail.com<br> > <br> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<br>
--------------------------------------------------------------------<br>> To REMOVE yourself from this mailing list, send an E-Mail message<br>
--------------------------------------------------------------------<br>To REMOVE yourself from this mailing list, send an E-Mail message<br> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<br> Received on Tue Aug 22 2000 - 09:28:25 CDT
 |
 |