That sounds horrible.
I'd guess that your rollback segments,redo logs and things like sort area
size etc are inappropriately set. If you can post the init.ora for your db.
Having said all that with a 6gb db I'd be tempted to go down the export
import route.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Helder Gräf" <helder_graef_at_controlmatic.de> wrote in message
news:fa09d4ac.0112170739.6af70671_at_posting.google.com...
> Hello,
>
> I'm just a newbie on Oracle 8i administration, but have here a serious
> problem with upgrading from 8.1.6.1 to 8.1.7.1.
>
> We have an HP-UX L3000 server with 8GB RAM, 3x550 PA8600 CPU's, and FC
> VA7400 AutoRaid-System.
>
> The upgrade script u0801060.sql is now running for more than 80 hrs.
> Average CPU utilization is about 50% on one processor. HDD utilization
> is about 50% and we still have wio of about 20%!!!
>
> The latest patch bunles from HP are September 2001.
> Database size is about 6GB.
>
> Any ideas how to track down the wio? Anyone had the same problem? Do I
> something wrong?
>
> Thanks in advance
>
> Helder Gräf
Received on Thu Dec 20 2001 - 03:36:46 CST
