Hi, this is a following up of the post: "Tricky Question"
Is there any tool that can give the statistics of DML of a specific table, i.e., how many insert, delete, update transactions during the last xxx seconds on table xxx.
I know that /rdbms/admin/catio.sql can create a sample_io procedure can give IO statistics, but no DML information.
What about other tools like STATSPACK, tkprof, OEM Perf Manager or third party software?
If not, how to create a stored procedure to achieve this?
Click Here to Expand Forum to Full Width