/* TABLE_OWNER TABLE_NAME INSERTS UPDATES DELETES ---------------- ------------------------- ---------- ---------- ---------- CVMOGDEFAULT TAUDMASCOTAS_ACUM 1062392 0 0 CVMOGVENDING TCONTIENDAS_FOR 1031884 209 266711 CVMOGCOMMON AUD_TMENSAJES_CLI 1604693 0 0 CVMOGVENDING TPOSICIONES_TOTAL 1696489 21 11 CVMOGVENDING TAUDELEMENTOS_SALIDAS 2258796 0 0 CVMOGVENDING TAUDTRANSACTIONES 5372518 0 0 */
<!–more–>
<br data-mce-bogus="1"> COL TOTAL_OPERATIONS NOPRINT SELECT TABLE_OWNER, TABLE_NAME, INSERTS, UPDATES, DELETES,TIMESTAMP, INSERTS+UPDATES+DELETES TOTAL_OPERATIONS FROM DBA_TAB_MODIFICATIONS WHERE TABLE_OWNER LIKE '%&schema_owner%' AND TABLE_OWNER NOT IN ('SYS','SYSTEM') ORDER BY TOTAL_OPERATIONS;