Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Storing blobs in database vs filesystem
Mark, Folks
We are also facing a similar issue with our "Banking" Application product where approx 1/3rd of the Database size is taken up by 1 Table which stores the Customer Signatures in one of its LONG/LOB fields.
Database Sizes are in the range of a few Tera Bytes.
The Banking Product is a primarily Pro C Application, with java functions too.
Qs When accessing the Signature, in case compression techniques are used, is there a certain performance impact?
SOME ADDITIONAL QUESTIONS ARE EMBEDDED BELOW IN CAPITALS. Thanks indeed
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark Strickland
Sent: Friday, September 29, 2006 3:33 AM
To: oracledba.williams_at_gmail.com
Cc: dubey.sandeep_at_gmail.com; ORACLE-L
Subject: Re: Storing blobs in database vs filesystem
We're seriously considering doing the same thing. Out of 1.6-Tb, we
have 1.3-Tb in LONGs, LONG RAWs and CLOBs that we're probably going to
move out of Oracle. We're reaching a tipping point where we'll soon
have to buy more SAN storage, multiplied by three (physical standby
and full copy for Staging environment). I'm very interested in seeing
other replies, ie, horror stories, gotchas, etc.
We're also testing compressing the LONGs and CLOBs before they're
inserted into the database and engineering the application to
compress/uncompress in flight.
Mark Strickland
Seattle, WA
![]() |
![]() |