Re: Data Dict out of Date?

From: Uli Harder <nomail_at_nomail>
Date: Wed, 24 Nov 1999 14:48:40 -0000
Message-ID: <943454970.8306.0.nnrp-10.d4f08801@news.demon.co.uk>

HI,
You need to run the ANALYZE command to update the statistics info in dba_tables.
Beware that this can take ages to run and take up lots of resource. If you want
to know the size of your tables in bytes/blocks look in dab_segments.

Bye Uli

--

---

Uli Harder
www: http://www.metron.co.uk/
Metron Technology Ltd.

---

Stephen Mulcahy <smulcahy_at_ebola.ilo.dec.com> wrote in message news:81gk4g$8br$1_at_mailint03.im.hou.compaq.com...
> Hi,
>
> I've been using the data dictionaries, particularly dba_tables
> to examine the size of our database (row counts etc.) but I came
> across a problem this morning basically,
>
> select num_rows from dba_tables where table_name='FOO';
>
> Gives me NULL.
>
> Now, select count(*) from FOO;
>
> Gives me 1234.
>
> Should this inconsistency exist? I thought the data dictionaries always
> contained current information, or is this an invalid assumption?
>
> Anyways comments appreciated,
>
> -stephen
>
> --
> Stephen Mulcahy, Compaq Customer Services, smulcahy_at_smsat.ilo.dec.com
> #define disclaimer "The views expressed are the author's and do not
> necessarily reflect the official position of Compaq Computer Corporation"
Received on Wed Nov 24 1999 - 08:48:40 CST