Re: storing blobs in database
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: Gsais@xxxxxxxxxxxxxxxxxxxx
- Date: Tue, 17 Jan 2012 15:30:50 -0500
I happen to think databases are a nice place to store documents. With 11.2
I'd definitely recommend using SecureFiles over BLOBS. As for backup times,
you'll have to decide the impact or if there are other ways to speed up the
rman times. Static pdf files can be placed in a readonly tablespace, add
more parallel to your backups, or doing incrementals with block change
tracking (to name a few). By adding a new EE database you've added more
license fees.
But definitely look into securefiles.
Andy
We are working on an application that will store images, well actualy pdf's
> in our database. We are debating on storing the blobs in our main
> production database or creating a separate database just for these images.
> We have applications running on our main production database that will
> need to pull these across to display. I am thinking a second database is
> the best idea since this database will get rather large very quickly and I
> don't want to slow down the backup of my main production database. Does
> anybody else do something similar to this and can provide your experiences.
> We are running 11.2.0.2 Enterprise Edition on Windows Server 20003 R2,
> soon to be 2008.
> Thanks.
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
