Re: dba_tab_mod view

From: Ram Raman <veeeraman_at_gmail.com>
Date: Tue, 12 May 2015 10:31:32 -0500
Message-ID: <CAHSa0M1mLoMQbbnhKWiDYWnmDToTdrtoaGgxaaJFo5dv87KUmA_at_mail.gmail.com>

Thanks Scott. It is highly unlikely anyone ran the flush_database_monitoring_info since the stats collection job 2 nights ago. The instance was not bounced either.

The stats were collected again last night, and the dba_tab_mod view does not return any row for this table in qn.

On Tue, May 12, 2015 at 9:48 AM, Deas, Scott <Scott.Deas_at_lfg.com> wrote:

> Ram,
>
>
>
> After you issue DML, but before you run statistics, you can run
> dbms_stats.flush_database_monitoring_info to update the views.
>
>
>
>
> http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_stats.htm#ARPLS68568
>
>
>
> Thanks
>
> Scott
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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.**
>

-- 

You can become a doctor and then websearch for solutions; You cannot
websearch and become a doctor

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

Received on Tue May 12 2015 - 17:31:32 CEST