DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=eLm37YfOQ9g4FNilFh2L2+39qk7gIzCFG/wsQIGAxM0eSeLmfjNSWSVAhP/KmP/GA3zi7tDGuNkttr9Kf3fPwJ2otqR5H3uofbe6OJ8wt2GVZycKjUEqjz9cVIOF/cfIhFYET27E+2fFhEtDsU8EKnJo5Cz+M0LWEDOz1NjHF/s=
Message-ID: <49d668000706061319j1274e5f2h1d09427f39934d4a@mail.gmail.com>
Date: Wed, 6 Jun 2007 16:19:04 -0400
From: "Alexander Fatkulin" <afatkulin@gmail.com>
To: post.ethan@gmail.com
Subject: Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS
Cc: oracle-l@freelists.org
In-Reply-To: <357b48a90706061257q3fa3cf3dyaf777fde971a9329@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Disposition: inline
References: <357b48a90706060939h26b72de4reb34ba34d37ff599@mail.gmail.com>
	 <4666F36B.2020505@evdbt.com>
	 <357b48a90706061257q3fa3cf3dyaf777fde971a9329@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: afatkulin@gmail.com

The SGA monitoring counters are not fully serialized (imagine an
overhead otherwise).

The numbers are "about" and not 100% correct. You can insert and later
rollback - the counters will add up.

> I saw some
> INSERTS into a table I know was not being inserted into. I broke the query
> down a bit and sure enough the SQL in gv$sql was not related to the table
> which was being returned by the object name in the query below. This is a
> 10.2.0.3 database, perhaps there are some changes in the way things need to
> be joined in 10G with this query. If anyone sees an obvious problem let me
> know.
>
> Thanks,
> Ethan

-- 
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l