If you ran and you want to confirm, take a look in the oracle data dictionary to see the state of the lob storage parameter for each column.
select table_name || '.' || column_name as "column" from user_lobs where in_row = 'NO' / The integrity of the data will be fine, but if the alter table statement takes 10 minutes to complete for a given column and some other sql (from the arserver) tries to perform and update on that column while the alter table is running, arserver only waits so long for the database to response (5 minutes I think). If you hit that threshold, arserverd will throw and error that the database is not responding. It is not unreasonable to assume that some of the alter table statements will take a long time (more than 5 minutes) to run if the total time of the alterations is 24 hours. Other things can/will slow down your conversion as well, such as backups. Also, the redo space required for the conversion will need to be rather large. The script you are using may not be as efficient as it could be. These hints/changes can make a big difference in the execution time: - parallel hint - nologging (don't generate redo logs) - direct-path INSERT (bypass the buffer cache) I don't know how you are doing the conversion, but each of the things above are worth looking into. Axton Grams On Tue, Mar 13, 2012 at 11:30 AM, patrick zandi <remedy...@gmail.com> wrote: > ** I know some of the Alter commands are Implicit commits.. so I think the > data is ok.. > > On Tue, Mar 13, 2012 at 12:26 PM, patrick zandi <remedy...@gmail.com> wrote: >> >> Actually,, this is what I was wondering... >> so do I run the whole job again, or is there some way to run this somehow >> that I know it will finish.. >> >> I thought about running this from an escalation, then I thought better.. >> an escalation thread running for 3 days.. this is probably a bad idea... >> ROFL.. >> >> >> >> On Tue, Mar 13, 2012 at 11:35 AM, Axton <axton.gr...@gmail.com> wrote: >>> >>> You may run into timeouts if a table is locked for a long enough >>> period of time and workflow, or a user, try to update a record in that >>> table. The same problems that apply to oracle errors in general apply >>> to this scenario. >>> >>> Axton Grams >>> >>> On Tue, Mar 13, 2012 at 10:34 AM, patrick zandi <remedy...@gmail.com> >>> wrote: >>> > ** That is what I want.. >>> > >>> > On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky <m...@rrr.se> 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 <m...@rrr.se> >>> >> > 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 >>> > _attend WWRUG12 www.wwrug.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 > > > > > -- > Patrick Zandi > _attend WWRUG12 www.wwrug.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"
