Re: Will Oracle ever follow its own advice?

From: Mladen Gogala <>
Date: Fri, 13 Feb 2009 11:48:18 +0000 (UTC)
Message-ID: <gn3mm2$kap$>

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;
> ---------- ------------------------------
> 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?

Received on Fri Feb 13 2009 - 05:48:18 CST

Original text of this message