How to know when table was modified

Being a DBA.....many times we get a question. Can you please tell when this table was last updated. Or may be if any DML operations happened.

Here is the answer for your question.

select * from dba_tab_modifications
select * from all_tab_modifications


Example:


select TABLE_OWNER,TABLE_NAME,INSERTS,UPDATES,DELETES,TIMESTAMP from dba_tab_modifications where rownum<10 and table_owner='SYSMAN';

Sheet Name :- Sheet1

---

TABLE_OWNER	TABLE_NAME	INSERTS	UPDATES	DELETES	TIMESTAMP
SYSMAN	AQ$_EM_EVENT_BUS_TABLE_L	176	0	175	7-Apr-16
SYSMAN	BIN$LKnxq0szBVrgU7QDAwoS5A==$0	1	1	0	26-Feb-16
SYSMAN	DB_GI_OH_TARGET_DETAILS	0	1	0	7-Apr-16
SYSMAN	DB_INSTANCE_CAGING_ECM	11	17	12	7-Apr-16
SYSMAN	EM_AVAILABILITY	16	0	0	7-Apr-16
SYSMAN	EM_COMPOSITE_KEYS	32	0	0	15-Mar-16
SYSMAN	EM_CONSOLE_PERF_STATS_LOG	0	0	2	7-Apr-16
SYSMAN	EM_CPUACT_STATS	0	0	0	7-Apr-16
SYSMAN	EM_CREDENTIAL_SET_TYPES	8	0	0	29-Feb-16

---

Sheet Name :- Sheet2

---

---

Sheet Name :- Sheet3

---

---