How to Monitor Selects

We need to determine which tables in a particular tablespace are being queried the most. I know how to determine how many physical reads there are against each datafile, and of course we have the tables and indexes in different tablespaces on different drives. All of the tables, however, are in one tablespace (and on one drive, though in a few datafiles). So, how can I check the number of reads on each table (and each index, for that matter)? Received on Wed Mar 14 2001 - 21:39:59 CET