Re: Will Oracle ever follow its own advice?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Fri, 13 Feb 2009 06:32:08 -0800 (PST)
Message-ID: <4fe3ab7a-546e-49ab-85f2-d061dee47b43_at_r29g2000vbp.googlegroups.com>

On Feb 13, 6:48 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> 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.com

Version 11g introduced Secure Files (new internal code to handle LOBS) and now calls traditional LOB data types Basic Files. Secure Files are supposed to be more space efficient and faster than Basic Files. Perhaps this will speed the migration of the base tables to using LOB data types.

HTH -- Mark D Powell -- Received on Fri Feb 13 2009 - 08:32:08 CST