I’m seeing the same results with Linux on 10.2.0.4. Specifying table_name only
returns 0 rows whereas table_name + table_owner returns as expected.
On Oct 7, 2015, at 12:31 PM, Neil Chandler <neil_chandler@xxxxxxxxxxx> wrote:
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
<mailto: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 <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
<mailto: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.
