That is what I want.. On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky <[email protected]> wrote:
> 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" > -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
