From: Michael McMullen <ganstadba@hotmail.com>
To: "oracle-l@freelists.org" <oracle-l@freelists.org>, "backseatdba@gmail.com"
 <backseatdba@gmail.com>
Subject: Re: database of blobs
Thread-Topic: database of blobs
Date: Tue, 6 Jun 2017 19:05:34 +0000
Message-ID: <SN1PR12MB046462B73A1C09BF092B0CFFA6CB0@SN1PR12MB0464.namprd12.prod.outlook.com>
References: <CAKsxbLq4FtN=4rfBungo2woweZ8hcfQA0uXf1Z3KSfphFp9hHw@mail.gmail.com>
In-Reply-To: <CAKsxbLq4FtN=4rfBungo2woweZ8hcfQA0uXf1Z3KSfphFp9hHw@mail.gmail.com>
Accept-Language: en-CA, en-US
Content-Language: en-CA
x-ms-exchange-messagesentrepresentingtype: 1
x-tmn: [6tkdwRUGtO3ALm8Q0PdJVXgyysfsQUkb7jCwAwNsUbzO0aonHgBecA==]
x-ms-publictraffictype: Email
x-microsoft-exchange-diagnostics: 1;CO1NAM03HT214;24:D0ad7qS3pzq9a1YZAuTj1YuQ2URdRbsuZan2Qep6aL80iTI6Wj2wch1XOzqStiepEc5HOHWGxG9NNZ4w5Xi+uO17/IFsRs78R5x1Wfx9LXI=;7:/EN4UuTWU2z1UFoFyQzJm2yfr1jx9zuY8wpjGx+jwf8eQa+G7tq3FRCWj8iYTgCxfbqn6rR7SQL0i79A4DcPXtr28Boj3FTymN4bndX+pwAHH+WGUDUBsd8RHZhyfbSNSNpv3Bdevk7fa5xq3LOTYhh7YA6fc+7BUs0mK+/WumWQ/UK2tpTbDeVFnMTgPQge/1xC9ojcWO207jXLQNdKVM062yeBTyafg7lmvL77y5IqZDtXjs+ViF7dMg00grNe6aJGxKX3BPg3MlnE848hYdjl9TGIUQ5MxY8T6rWFspFTvPrYd8y1jNCYuiymVk5q
x-incomingheadercount: 45
x-eopattributedmessage: 0
x-forefront-antispam-report: EFV:NLI;SFV:NSPM;SFS:(7070007)(98901004);DIR:OUT;SFP:1901;SCL:1;SRVR:CO1NAM03HT214;H:SN1PR12MB0464.namprd12.prod.outlook.com;FPR:;SPF:None;LANG:en;
x-ms-traffictypediagnostic: CO1NAM03HT214:
x-ms-office365-filtering-correlation-id: 98f6a341-ea3a-4900-3140-08d4ad0f02ce
x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001)(201702061074)(5061506573)(5061507331)(1603103135)(2017031320274)(2017031324274)(2017031323274)(2017031322274)(1603101448)(1601125374)(1701031045);SRVR:CO1NAM03HT214;
x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(100000700101)(100105000095)(100000701101)(100105300095)(100000702101)(100105100095)(444000031);SRVR:CO1NAM03HT214;BCL:0;PCL:0;RULEID:(100000800101)(100110000095)(100000801101)(100110300095)(100000802101)(100110100095)(100000803101)(100110400095)(100000804101)(100110200095)(100000805101)(100110500095);SRVR:CO1NAM03HT214;
x-forefront-prvs: 033054F29A
spamdiagnosticoutput: 1:99
spamdiagnosticmetadata: NSPM
Content-Type: multipart/alternative;
 boundary="_000_SN1PR12MB046462B73A1C09BF092B0CFFA6CB0SN1PR12MB0464namp_"
MIME-Version: 1.0
X-OriginatorOrg: hotmail.com
X-MS-Exchange-CrossTenant-originalarrivaltime: 06 Jun 2017 19:05:34.7858
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Internet
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO1NAM03HT214
X-archive-position: 68468
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: ganstadba@hotmail.com
Precedence: normal
Reply-To: ganstadba@hotmail.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:mark.bobak@proquest.com>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
--_000_SN1PR12MB046462B73A1C09BF092B0CFFA6CB0SN1PR12MB0464namp_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Are you blobs stored as securefile lobs?


________________________________
From: oracle-l-bounce@freelists.org <oracle-l-bounce@freelists.org> on beha=
lf of Jeff Chirco <backseatdba@gmail.com>
Sent: June 5, 2017 7:22 PM
To: oracle-l@freelists.org
Subject: database of blobs

Sort of a design question here.  I have a database that is only used to sto=
re documents or images in a blob field. This is mostly scanned copies of in=
voices or employee records as pdf's or jpeg images of pictures from some of=
 our custom applications. Again all of these are stored in the same table a=
s a blob field.  These blob's are currently 840gb in size in a small file t=
ablespace that currently has 27 datafiles that are 32gb.  I potentially hav=
e the opportunity to reorganize this database and or table during an upcomi=
ng migration from 11.2.0.4 -> 12.1.0.2 and also moving Windows -> Linux.
So I don't really have a direct question here but just wondering what anybo=
dy things about this, or is there something I might want to think about as =
this table grows, or maybe a better way to organize it.  I thought about ma=
ybe partitioning it somehow but it doesn't seem like there is a logical way=
 to partition it.  Also there are no performance issues as all this databas=
e does is save and retrieve images.

Thanks,
Jeff

--_000_SN1PR12MB046462B73A1C09BF092B0CFFA6CB0SN1PR12MB0464namp_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"><!-- P {margin-top:0;margi=
n-bottom:0;} --></style>
</head>
<body dir=3D"ltr">
<div id=3D"divtagdefaultwrapper" style=3D"font-size:12pt;color:#000000;font=
-family:Calibri,Arial,Helvetica,sans-serif;" dir=3D"ltr">
<p>Are you blobs stored as securefile lobs?<br>
</p>
<br>
<br>
<div style=3D"color: rgb(0, 0, 0);">
<hr tabindex=3D"-1" style=3D"display:inline-block; width:98%">
<div id=3D"divRplyFwdMsg" dir=3D"ltr"><font style=3D"font-size:11pt" face=
=3D"Calibri, sans-serif" color=3D"#000000"><b>From:</b> oracle-l-bounce@fre=
elists.org &lt;oracle-l-bounce@freelists.org&gt; on behalf of Jeff Chirco &=
lt;backseatdba@gmail.com&gt;<br>
<b>Sent:</b> June 5, 2017 7:22 PM<br>
<b>To:</b> oracle-l@freelists.org<br>
<b>Subject:</b> database of blobs</font>
<div>&nbsp;</div>
</div>
<div>
<div dir=3D"ltr">
<div>Sort of a design question here.&nbsp; I have a database that is only u=
sed to store documents or images in a blob field. This is mostly scanned co=
pies of invoices or employee records as pdf's or jpeg images of pictures fr=
om some of our custom applications. Again
 all of these are stored in the same table as a blob field.&nbsp; These blo=
b's are currently 840gb in size in a small file tablespace that currently h=
as 27 datafiles that are 32gb.&nbsp; I potentially have the opportunity to =
reorganize this database and or table during
 an upcoming migration from 11.2.0.4 -&gt; 12.1.0.2 and also moving Windows=
 -&gt; Linux.&nbsp;
<br>
</div>
<div>So I don't really have a direct question here but just wondering what =
anybody things about this, or is there something I might want to think abou=
t as this table grows, or maybe a better way to organize it.&nbsp; I though=
t about maybe partitioning it somehow
 but it doesn't seem like there is a logical way to partition it.&nbsp; Als=
o there are no performance issues as all this database does is save and ret=
rieve images.<br>
<br>
</div>
<div>Thanks,<br>
</div>
<div>Jeff<br>
</div>
</div>
</div>
</div>
</div>
</body>
</html>

--_000_SN1PR12MB046462B73A1C09BF092B0CFFA6CB0SN1PR12MB0464namp_--
--
http://www.freelists.org/webpage/oracle-l