Re: dba_tab_mod view

From: Mladen Gogala <>
Date: Tue, 12 May 2015 21:37:47 -0400
Message-ID: <>

Also, that will only work for tables that have MONITORING attribute set.

On 05/12/2015 10:48 AM, Deas, Scott wrote:
> Ram,
> After you issue DML, but before you run statistics, you can run
> dbms_stats.flush_database_monitoring_info to update the views.
> Thanks
> Scott
> *From:*
> [] *On Behalf Of *Ram Raman
> *Sent:* Monday, May 11, 2015 7:13 PM
> *To:* ORACLE-L
> *Subject:* dba_tab_mod view
> List,
> After seeing lots of global services enqueue deadlock errors in our
> rac, I was looking up the trace files. I was able to see the sql; the
> trace files are huge (in GBs) . The sql was simple and was updating
> one table only repeatedly. I wanted to know how many updates had
> happened in the table, but the dba_tab_mod view is empty for that
> table. The table was last analyzed last night. Does this mean that the
> updates did not happen at all due the deadlock errors?
> To my knowledge, the DTM view is emptied out after a stats collection.
> Is there anything else that would cause the no rows selected for a
> table from that view. v11.2
> Ram.
> Notice of Confidentiality: **This E-mail and any of its attachments
> may contain
> Lincoln National Corporation proprietary information, which is
> privileged, confidential,
> or subject to copyright belonging to the Lincoln National Corporation
> family of
> companies. This E-mail is intended solely for the use of the
> individual or entity to
> which it is addressed. If you are not the intended recipient of this
> E-mail, you are
> hereby notified that any dissemination, distribution, copying, or
> action taken in
> relation to the contents of and attachments to this E-mail is strictly
> prohibited
> and may be unlawful. If you have received this E-mail in error, please
> notify the
> sender immediately and permanently delete the original and any copy of
> this E-mail
> and any printout. Thank You.**

Mladen Gogala
Oracle DBA

Received on Wed May 13 2015 - 03:37:47 CEST

Original text of this message