Re: table usage

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Mon, 3 Dec 2001 19:38:16 +1100
Message-ID: <3c0b39e8$0$27196$afc38c87@news.optusnet.com.au>

Analyze table blah compute statistics;

Followed by

select * from dba_tables where table_name='BLAH';

Check out the columns for average row length, number of rows and so on.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Antony Mak" <cheong_at_broadway-ps.com> wrote in message
news:3c0b34bb_at_newsgate.imsbiz.com...


> Hi all,

>

> Can any tell me how can I know a table whether have been used and it's

> usage?

>

> Thanks in advance

>

> Antony

>

>

>

Received on Mon Dec 03 2001 - 02:38:16 CST