Re: Weirdness with dba_tab_modifications

From: Neil Chandler <neil_chandler_at_hotmail.com>
Date: Wed, 7 Oct 2015 17:31:49 +0100
Message-ID: <DUB404-EAS1577D38424AEEA3ED3B003185360_at_phx.gbl>

Were stats gathered on that scheme between selects, thus wiping out the modifications counter?

Are you doing a flush_database_monitoring_info before the select to ensure stats are in the table?

Neil.
sent from my phone

> On 7 Oct 2015, at 17:28, Matt Adams <MAdams_at_TroverSolutions.com> wrote:
>
> No, all queries were run by me in same session, logged in as SYS.
>
> Oracle 11.2.0.4 on Solaris 10
>
> From: Ram Raman [mailto:veeeraman_at_gmail.com]
> Sent: Wednesday, October 07, 2015 11:19 AM
> To: Matt Adams
> Cc: ORACLE-L
> Subject: Re: Weirdness with dba_tab_modifications
>
> Could you be logged in as two different users/databases for those two queries?
>
> On Wed, Oct 7, 2015 at 9:56 AM, Matt Adams <MAdams_at_troversolutions.com> wrote:
> I’m investigating several foreign keys that do not appear to have corresponding indexes on them. During the course of the investigation, I started querying DBA_TAB_MODIFICATIONS.
>
>

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

Received on Wed Oct 07 2015 - 18:31:49 CEST