Re: Calculating table size without using user_tables or dba_tables views

> I would like to calculate the size of a given table without using
> dba_tables or user_tables.

Have a look at the DBMS_SPACE package.

>Also, is there a way to retrieve the
> information of how often a table is accessed?

You could set up auditing, or if you are using 9i, then have a look at the V$SEGMENT_STATUS view.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"