I look at the statistic "redo size" for the session, which is the
amount of redo generated in bytes. This can be found at the
instance-level in V$SYSSTAT, at the session-level in V$SESSSTAT, and
for the present session in V$MYSTAT. For at least the latter two
views, the information won't be visible until a COMMIT occurs, and I
would bet the same with V$SYSSTAT as well... Hope this helps.... Andrew Kerber wrote: If you know which tables are affected by which parts of the application, dba_tab_modifcations can give insert/update/delete activity on the tables. I believe monitoring has to be turned on for that though (its on by default).-- //www.freelists.org/webpage/oracle-l |