Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: table update crashing...

Re: table update crashing...

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Sun, 26 Jan 2003 09:59:02 -0800
Message-ID: <3E3421E5.4359257E@exesolutions.com>


Glen A Stromquist wrote:

> DA Morgan wrote:
> > Glen A Stromquist wrote:
> >
> >
> >>I am having a "frustrating" time with a database restructure, and am
> >>ready to restore back to its previous state but thought I'd try the
> >>group and see if anyone has a suggestion of what to try next.
> >>
> >>Here is the scenario, an upgrade to a client app requires a database
> >>restructure, which runs thru an executable and accesses a dozen or so
> >>sql scripts, but also does some table updates etc. outside of these
> >>scripts. The restructure executable craps out while updating quite a
> >>large table, watching from dba studio it takes about 25 min to do a full
> >>table scan then gets about 14% thru the sort operation. The sql being
> >>ran is nothing more that setting a value of 1 to a new column in the
> >>large table. Unfortunatly this sql is nowhere to be found in the scripts
> >>and must be run somewhere from within the executable, or I'd try and run
> >>it manually and comment it out from the script. The vendors support
> >>person tells me that the scripts have to be run from within the
> >>restruct executable, so that rules out running them one at a time.
> >>Unfortunatly they also dont work weekends, so I'm looking at restoring
> >>the backup I just took and discussing it more on monday with them :-(
> >>
> >>On my end I've created a monster rollback seg and put all others
> >>offline, disabled archivelog on the db and turned logging off for the
> >>table(s) it seems to be crapping out on. Not sure what else to try next
> >>that may coax this thru before I go home tonight.
> >>
> >>ideas?
> >
> >
> > I'd go home. And make a mental note that you owe it to the c.d.o. group to
> > name names so that we know which vendor it is.
> >
> > Thanks.
> >
> > Daniel Morgan
> >
>
> Yeah I'm ready to, just increased the sort area and sga size and am
> trying it again. As I'm writing this I'm watching the update to the
> culprit table almost complete. Funny thing is I ran the sql from sqlplus
> that seems to be stalling the restruct and it ran in a few seconds.
>
> The vendor is rockwell/entek and the app is called odyssey, its a
> vibration analysys program we use, and the restruct usually runs quite
> smooth.
>
> Well,it just crapped out again, but this time got one step further.
> Think I'll do a restore, go home and look forward to calling their
> support on monday.

Thanks.

Daniel Morgan Received on Sun Jan 26 2003 - 11:59:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US