Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: setting timed_statistics = true

Re: setting timed_statistics = true

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Mon, 1 Mar 2004 16:29:21 GMT
Message-ID: <404364E1.BB27F33E@remove_spam.peasland.com>


> My experience ...
> timed_statistics=true takes approx. 10% of the performance.

10%?!?!? That seems pretty high.... I'd say less than 1% in my experience. As part of the "standards" I have for my databases, I set TIMED_STATISTICS=TRUE in all instances! And I haven't seen any noticable affects.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Mon Mar 01 2004 - 10:29:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US