Re: 0 Records Tables

From: Timo Haatainen <Timo.Haatainen_at_tietogroup.com>
Date: 1997/11/21
Message-ID: <34756963.4BA3@tietogroup.com>#1/1

qutub_at_hotmail.com wrote:
>
> Hi all,
>
> Can someboby tell me about the overheads of tables with 0 records in the
> database.
>
> Thanks.
>
> ABD
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

They need some space from tablespace, at least 2 data blocks. If you refer to those tables with SQL the commands are stored in shared pool in SGA.
Furthermore the row counts in data dictionary (tables defining tables, columns etc.) increases.
Maybe there is some more issues ...
I'm curious to hear the reason of such tables.

-- 

Timo Haatainen
Carelcomp Forest Oy

Received on Fri Nov 21 1997 - 00:00:00 CST