Re: Will Oracle ever follow its own advice?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 13 Feb 2009 11:48:18 +0000 (UTC)
Message-ID: <gn3mm2$kap$6_at_solani.org>
On Thu, 12 Feb 2009 09:32:29 -0800, Steve Howard wrote:
Date: Fri, 13 Feb 2009 11:48:18 +0000 (UTC)
Message-ID: <gn3mm2$kap$6_at_solani.org>
On Thu, 12 Feb 2009 09:32:29 -0800, Steve Howard wrote:
> SQL> select count(*),owner from dba_tab_columns where data_type = 'LONG'
> and owner like 'SYS%' group by owner;
>
> COUNT(*) OWNER
> ---------- ------------------------------
> 12 SYSTEM
> 228 SYS
The problem with CLOB columns is that they waste huge amounts of space.
Should Oracle use LOB segments indiscriminately, data dictionary could
grow to the gigantic proportions. Data dictionary already is growing
enormously quickly and now has 2 tablespaces, instead of one. Does anybody
want to place a bet on when will we get the 3rd one?
-- http://mgogala.freehostia.comReceived on Fri Feb 13 2009 - 05:48:18 CST