The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 |
Newsgroups: comp.databases.oracle.server
From: Robert Klemme <shortcut...@googlemail.com>
Date: Thu, 31 Jan 2008 00:09:56 -0800 (PST)
Local: Thurs, Jan 31 2008 3:09 am
Subject: Re: long running select min(timestamp) query
On Jan 30, 6:26 pm, "bobdu...@gmail.com" <bobdu...@gmail.com> wrote:
> On Jan 30, 5:02 am, Robert Klemme <shortcut...@googlemail.com> wrote: Then please do yourself a favor ask whoever is responsible for the > > I doubt it makes a difference for the min/max types of queries but do > > you update statistics on a regular basis, or at least after such mass > > deletes? There *may* be an impact if concurrently running queries are > > less efficient because of stale statistics and your IO becomes slower > > just because of increased concurrent IO load. > I don't do anything regularily, which is bad yes, but ianaodba, database to set up statistics gathering. > so i Oracle is getting better with manageability IMHO but you cannot let a > don't even know what to do, i try to let this intelligent system > handle itself :) DB left unattended. > How do i know if i have system statistics set? From an earlier posting in this group: select pname, pval1, sname Btw, http://tahiti.oracle.com is your friend. It's even searchable. Kind regards robert You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||