RE: DML Monitoring not working for table.

                11.1 was very buggy.  We never went to it.  You want to be on at least 11.2.0.4 for anyone to talk to you.

Liz

Liz Reen
CPB Database Administration

Dev Servers: Oracle | ORasS | Golden Gate | Sybase | MS-SQL | MSaaS | Neo4j | HBase - Prod Servers: Golden Gate | Neo4j | HBase

From: [External] oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of [External] Rakesh Ra Sent: Wednesday, July 31, 2019 8:20 AM
To: Oracle-L Freelists
Cc: Rakesh RA
Subject: DML Monitoring not working for table.

Hi Gurus,

For couple of tables in one of 11.1.0.7<https://urldefense.proofpoint.com/v2/url?u=http-3A__11.1.0.7&d=DwQFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=nOQCaLU8ITP4kPFoigJm0Zhwn5TXjx06m0nfC99N3R4&s=_DCzvXrhjGVgcMTrGiXZ_qQc0D-xvRywbbbojkwGaCI&e=> database, DML monitoring is not working.as<https://urldefense.proofpoint.com/v2/url?u=http-3A__working.as&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=nOQCaLU8ITP4kPFoigJm0Zhwn5TXjx06m0nfC99N3R4&s=bjtkGiGp0U3wWFUl4UvTDPd7ZZOkUClQ2MceUSEAki4&e=> 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?

NAME                                               VALUE                          DESCRIPTION


-------------------------------------------------- ------------------------------ --------------------------------------------------


_dml_monitoring_enabled                            TRUE                           enable modification monitoring

dba_tab_statistics:
OWNER                          TABLE_NAME                     PARTITION_NAME                 STATT STA LAST_ANALYZED                 NUM_ROWS


------------------------------ ------------------------------ ------------------------------ ----- --- --------------------------- ----------


DR_STORE28                     CONTENT_MIG_WORKFLOW                                                NO  04-MAR-2019 23:13:51                 0

dba_tables:
OWNER                          TABLE_NAME                     LAST_ANALYZED                 NUM_ROWS MON


------------------------------ ------------------------------ --------------------------- ---------- ---


DR_STORE28                     CONTENT_MIG_WORKFLOW           04-MAR-2019 23:13:51                 0 YES

SQL> select count(1) from DR_STORE28.CONTENT_MIG_WORKFLOW;

  COUNT(1)

    355446

i did flush of monitoring info to see if there was something there in memory that has not reflected in DBA_TAB_MODIFICATIONS, but that as well didn't help.

SQL> select object_id from dba_objects where object_name='CONTENT_MIG_WORKFLOW' and owner='DR_STORE28';

 OBJECT_ID

    302901
SQL> select * from sys.mon_mods$ where obj#=302901;

no rows selected

SQL> select * from sys.mon_mods_all$ where obj#=302901;

no rows selected

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