Re: Weirdness with dba_tab_modifications

From: Kenny Payton <k3nnyp_at_gmail.com>
Date: Wed, 7 Oct 2015 12:34:20 -0400
Message-Id: <F9148B0E-D302-4258-8B69-77FDDE5B4283_at_gmail.com>

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_at_hotmail.com> 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_at_TroverSolutions.com <mailto: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 <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 <mailto: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:34:20 CEST