Hi,
You should see a significant size reduction as well as performance
improvement on inserts/updates :-)
The size was reduced to less than half in the system I was working on, and
the bulk of the data left was actually attachments.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> I think I have around 120 Gig of LOB, that is going from out to in..
> I need to put in row, it is getting out of control..
>
> On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky <[email protected]> wrote:
>
>> Hi,
>>
>> I have done that a couple of times without any real problems. It did
>> take
>> a lot less than 24 hours though, so these systems were probably much
>> smaller. About 10-15GB if I remember right, and much bigger with out-row
>> storage.
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>> logs.
>> Find these products, and many free tools and utilities, at
>> http://rrr.se.
>>
>> > Hey all ,
>> > Odd question, from a person who is not normal.. which is normal.. lol
>> >
>> > If you have a production system and you are taking an existing system
>> that
>> > is up and running online
>> > and you do the modify all the lob's from out-row to in-row
>> > is there any issues with doing this while everyone is using it ?
>> >
>> > I see nothing obviously stated that you should not run this while
>> doing
>> > audits, or anything..
>> > Does Oracle take care of that scenario, while moving from one way to
>> the
>> > other..
>> >
>> > I did one system that took almost 24 hours.. This is why I am
>> asking...
>> >
>> > thanks..
>> >
>> > --
>> > Patrick Zandi
>> >
>> >
>> _______________________________________________________________________________
>> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>> >
>>
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>>
>
>
>
> --
> Patrick Zandi
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
