Home -> Mailing Lists -> Oracle-L -> Re: DML Monitoring not working for table.

Re: DML Monitoring not working for table.

From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Wed, 31 Jul 2019 10:16:39 -0500
Message-ID: <35723f19795991436aed1ff9917c7821_at_society.servebeer.com> 








On 2019/07/31 07:20, Rakesh Ra wrote:



> For couple of tables in one of 11.1.0.7 database, DML monitoring is not working.as expected. The stats got last gathered for the table on 4th Mar and that shows no records for the table. However, the table is having 355446 records for now.. The table stats is not locked as shown below below and neither it appears to be STALE in dba_tab_statistics. I am not sure what is causing this or even if I am doing something wrong. Can we have someone to provide some insights on this please?





The first thing that comes to mind is to check for any termination of
the instance, other than SHUTDOWN NORMAL.  I believe that SHUTDOWN ABORT
can cause loss of DML update counts, and I'm not sure about SHUTDOWN
IMMEDIATE, although I suspect it flushes the DML update counts to disk
before shutdown like NORMAL does.  And of course a server crash or other
instance crash would cause a similar loss. 



Something to check on anyway... 



Rich

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


Received on Wed Jul 31 2019 - 17:16:39 CEST












Original text of this message