Oracle/solaris monitoring commands
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Oracle/solaris monitoring commands

  1. #1
    Join Date
    Nov 2002
    Posts
    16

    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

    Bal

  2. #2
    Join Date
    Nov 2002
    Location
    India
    Posts
    4

    Lightbulb

    Dear Friend,

    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....


    Zacharias

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    and get some book, even you run those commands I doubt you can understand the output

  4. #4
    Join Date
    Jul 2000
    Posts
    119
    Here is a good link for solaris
    http://sunsolve.sun.com/pub-cgi/retr...0test%20memory

    HTH
    OCP 8.0, 8i, 9i

  5. #5
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    you can use top, it will comes with solaris companion CD.
    Chan
    OCP7.3/8.0/8i/9i
    Sun Certified Sys. Admin

  6. #6
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    THere's also a good UOracle 9i Unix Administration Handbook which will be of help.

    http://www.amazon.com/exec/obidos/tg...books&n=507846
    OCP 8i, 9i DBA
    Brisbane Australia

  7. #7
    Join Date
    May 2002
    Posts
    2,645
    Bookpool price is $30.50.
    http://www.bookpool.com/.x/m4d5smty1...Go.x=13&Go.y=7

    Amazon price is $34.99.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width