Table access count?

Hi:

Is there any way to see how many times table has been accessed?
Also, how much memeory is require to load full table in the memeory?

Thanks

Assuming you're on 9i, use the MONITORING option from ALTER TABLE (http://download-west.oracle.com/docs...htm#SQLRF01001).

Sorry..I should have mentioned Oracle Version..

I am on Oracle 8i (8.1.7)...
any suggestion?

Thanks.

There are lots of ways to "kinda" get the information you are looking for. However, none are reliable.