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.
Received on Sat Jan 25 2003 - 20:00:18 CST
