Re: Determining table usage with query??

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 11 May 1999 12:30:48 -0400
Message-ID: <7h9lqd$96t$1@autumn.news.rcn.net>

Hi Peter,

As a user to see your own resources:

DESC USER_TABLES As a DBA

DESC DBA_TABLES Before querying the tables you should run an ANALYZE COMPUTE STATISTICS -- preferably during off-hours since ANALYZE can have a noticeable impact on performance.

regards

Jerry Gitomer

Peter Heiden wrote in message <3738314e.343023736_at_news.earthlink.net>...
> Can someone tell me if there is a table that I can do a SQL
>query on that holds individual table space usage. Information like
>what you would find by looking at an individual table in schema
>manager, and then clicking on the storage tab. I would like to be able
>to create a report that listed all the tables, or a subset of them.
>Any help would be much appreciated.
>
Received on Tue May 11 1999 - 11:30:48 CDT