Re: SECUREFILES disaster
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 27 Apr 2012 11:59:53 -0700 (PDT)
Message-ID: <9250813.1273.1335553193151.JavaMail.geo-discussion-forums_at_vbmi19>
On Monday, April 23, 2012 11:16:33 PM UTC-4, Mladen Gogala wrote:
> On Mon, 23 Apr 2012 06:33:20 -0700, Mark D Powell wrote:
>
> > ust some general comments
> >
> > The LOB data type has never been known for its space efficiency.
>
> This is an understatement. That was OK while LOB columns were an
> exception but now LOB columns are found in each and every database. CTXSYS
> indexes are free, text searches are more and more common, but the space
> issues are just horrific. I hoped that "completely re-written LOB storage
> engine", to put it into Oracle's own words, might help, but no such luck.
>
>
>
> --
> http://mgogala.byethost5.com
Date: Fri, 27 Apr 2012 11:59:53 -0700 (PDT)
Message-ID: <9250813.1273.1335553193151.JavaMail.geo-discussion-forums_at_vbmi19>
On Monday, April 23, 2012 11:16:33 PM UTC-4, Mladen Gogala wrote:
> On Mon, 23 Apr 2012 06:33:20 -0700, Mark D Powell wrote:
>
> > ust some general comments
> >
> > The LOB data type has never been known for its space efficiency.
>
> This is an understatement. That was OK while LOB columns were an
> exception but now LOB columns are found in each and every database. CTXSYS
> indexes are free, text searches are more and more common, but the space
> issues are just horrific. I hoped that "completely re-written LOB storage
> engine", to put it into Oracle's own words, might help, but no such luck.
>
>
>
> --
> http://mgogala.byethost5.com
(Not intended as a series remark) Remember Oracle now sells disk. The LOB storage (mis)managment may be driven by marketing.
IMHO -- Mark D Powell -- Received on Fri Apr 27 2012 - 13:59:53 CDT