-
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).
Jeff Hunter
-
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.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|