Re: Blobs vs Bfile in 10g. Pros and Cons?

From: BChase <bsc7080xxmqc_at_myoracleportal.com>
Date: Sun, 08 Nov 2009 10:54:07 -0500
Message-ID: <d9qdf5d18vgmqrct31dnhia2hs6b2q84fp_at_4ax.com>

Don't quote me on this but I think prior to 11g, BFile pointers have traditionally been faster than pulling LOBs from the database. However, there were some improvements around LOBs in 11g that provided greater efficiences.

Is there a DBA here that can confirm ?

On Sat, 7 Nov 2009 11:08:04 -0800 (PST), Rich <richmarin_at_earthlink.net> wrote:

>
>Our department is uses 10g.
>
>We will be loading PDF files and/or pictures into our database.
>
>What are the pros and cons verses Bfile and Blobs. What has been your
>experience?
>
>Regards
Received on Sun Nov 08 2009 - 09:54:07 CST