Re: table usage

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 3 Dec 2001 22:48:42 -0000
Message-ID: <9ugvl6$752$1@news8.svr.pol.co.uk>

and alter table ... monitoring can be useful as well...

Cheers
Connor

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:3c0b39e8$0$27196$afc38c87_at_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 - 16:48:42 CST