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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>
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