From: Mark D Powell <markp7832@my-deja.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Will setting timed_statistics=TRUE create much overhead?
Date: Fri, 02 Feb 2001 14:49:00 GMT
Organization: Deja.com
Lines: 23
Message-ID: <95ehco$vni$1@nnrp1.deja.com>
References: <95bml0$g0j$1@nnrp1.deja.com> <3a79ed8d.31075210@nntp.mindspring.com>
NNTP-Posting-Host: 199.228.142.8
X-Article-Creation-Date: Fri Feb 02 14:49:00 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
X-Http-Proxy: 1.0 x60.deja.com:80 (Squid/1.1.22) for client 199.228.142.8
X-MyDeja-Info: XMYDJUIDmarkp7832


In article <3a79ed8d.31075210@nntp.mindspring.com>,
  willjamu@mindspring.com (James Williams) wrote:
> Don't use timed_statistics=true to much on Oracle 8.1.5 . I would
> assume 8.0.5 has the same problems.
>
> Fixed in 8.1.6.3
>
> Can cause cursors not to be shared, high CPU, and other issues. Go to
> metalink and pull up the bug list.
>
> Its negligble after 8.1.6.3
>
There is no problem with timed_statistics = true on 8.0.5.2 as we
always run with timed statistics true and we got a good overall
performance boost moving from 7.3.4 to 8.0.5.2 in place (upgrade
existing database).
--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com
http://www.deja.com/