no rows selected: so it worked.. Ya know.. I believe All I did was timeout.. I killed the sqplus, went to another sqlplus session, did it again.. and in 15 min it returned.. ran what you sent below .. working.. so I really do not know how long it too..
I am doing 1 more test on this.. it should give me some real numbers.. On Tue, Mar 13, 2012 at 1:57 PM, Axton <axton.gr...@gmail.com> wrote: > 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" > -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
