I wrote an article on the subject some time back. http://arswiki.org/wiki/Oracle_Performance_Tuning#LOB_Storage
Axton On Fri, Apr 24, 2009 at 6:05 AM, Misi Mladoniczky <[email protected]> wrote: > Hi, > > I am moving data from a ARS 6.3.0 server to a 7.1.0 patch 6 server. Both > are accessing an Oracle 10 database. > > In the target server, 3 LOBs are becomming very big. They are connected to > large text fields (32000 chars) and a diary field. > > For example one of these text fields has no data in the column for any of > the 44361 records. The resulting LOB is about 512 Mb in size... > > In the source 6.3 machine, the size is very small. > > Has anyone seen anything similar? > > The real problem is another form with 4 million records, where one LOB is > 13 Gb in size... > > I am moving the data with RRR|Chive, which is exactly the same as using AR > Import of an ARX-file. In other words by doing the API-calls ARGetEntry() > and ARMergeEntry(). > > Best Regards - Misi, RRR AB, http://www.rrr.se > > Products from RRR Scandinavia: > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > * RRR|Translator - Manage and automate your language translations. > Find these products, and many free tools and utilities, at http://rrr.se. > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum > Sponsor:[email protected]<sponsor%[email protected]>ARSlist: > "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
