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.
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.
Is there any log file when you do the upgrade? you could possibly see the log file.
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you all for your input, but specially schwertner for taking the time to make it so detailed.