Link to home
Start Free TrialLog in
Avatar of fidoly
fidoly

asked on

Getting upgrade progress information

Hi all,

I am upgrading a database from 8i to 9i running under Solaris.  The database is about 50GB and I want to know what the process is doing instead of just trusting the progress bar, which seems to get stuck for long periods of times without any changes.

Is there anything that can tell me what the upgrade is doing?  I really need to monitor that the upgrade is progressing and it is not stuck in a loop or something.

Many thanks,

Fidoly.
Avatar of Acton Wang
Acton Wang
Flag of United States of America image

Is there any log file when you do the upgrade? you could possibly see the log file.

Avatar of MohanKNair
MohanKNair

Using monotoring tools check CPU and disk activities.

vmstat for CPU, memory utilization , and disk-I/O
iostat to determine if there is a disk bottleneck
netstat to monitor critical network activity
sar, or system activity reporter is most useful for capacity planning and trend analysis

ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of fidoly

ASKER

Thank you all for your input, but specially schwertner for taking the time to make it so detailed.