Oracle/solaris monitoring commands
Problem - An application running on Oracle 8.1.7 on Sun Solaris keeps freezing when user clicks save on application. By rebooting Unix box problem is resolved.
1) What can I look at on the Oracle side.
2) Is there anything that will show what command is being executed before the freeze.
3) How can I see cpu usage, disk io,virtual memory statistics, and processes for CPU and memory usage,network bandwidth usage, can view the entire kernel statistics tree on solaris
Let me know thanks
Please Try vmstat,iostat and sar utilities of solaris to monitor your problem. If u need to to find out if there is a CPU bottleneck in your solaris Server use vmstat and moniter the FIRST column.....
And use man pages to get more about these utilities....
and get some book, even you run those commands I doubt you can understand the output
you can use top, it will comes with solaris companion CD.
Sun Certified Sys. Admin
THere's also a good UOracle 9i Unix Administration Handbook which will be of help.
OCP 8i, 9i DBA
Click Here to Expand Forum to Full Width