.
1) Check that your statistics are up to date.

2) Install the STATSPACK package (?/rdbms/admin/spcreate).

3) Also, the number of transactions per table could be monitored by setting "MONITORING" on such tables.