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@xxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxx]
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@xxxxxxxxxxxxxxxxxxx> 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.
