Hi,
I would like to know is there any way i can count the
total number of transaction for a given table.
Thanks
Chan
Printable View
Hi,
I would like to know is there any way i can count the
total number of transaction for a given table.
Thanks
Chan
In 8.1.6 u can enable table monitoring option and then query dba_tab_modifications to find out the the type of transactions and calculate the total number.
Also you can query x$bh to get the idea of highest used objects.
I don't think you'll be able to get the number of transactions per table. In fact, even if you could I don't think this number would actually say a lot. A single transaction can modify milions of rows in a table or it can modify only a single row. A single transaction can modify dozens of tables or it can modify only one table. And so on and so on....
What you can find out (at least approximately) is I/O activity on specific tables, which qould be much more meaningfull information. To do this, you can use script catio.sql which you can find in your $ORACLE_HOME/rdbms/admin directory. This scripts does what gpsingh sugested - it gets the I/O activty by sampling buffer cache (x$bh).
HTH,