Oracle/network traffic problems
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle/network traffic problems

  1. #1
    Join Date
    Jan 2002
    Posts
    38
    A lot of our users have been complaining about slow process. I need some way of seeing, or ruling out Oracle as to the cause of our slowness. We run analyze nightly, and there are about 20-30 users. Is there a good performance monitor tool out there. I need to rule oracle out as the bottle neck. Thanks for any help

  2. #2
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    You can try to select their username, machine name(host_id) off v$session then ping all those hosts output to a file and see how long it takes to ping a specific box. If its more then 200ms then you have a network problem.

    Jigar
    "High Salaries = Happiness = Project Success."

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Look at your box, is the CPU pegged?

    Are the disks 100% busy?

    Look at your SGA, does it have good hit ratio?

    Are the SQL statements tuned correctly?

    This is a good performance tuning method:
    http://technet.oracle.com/deploy/per...rf_method1.pdf

    This is a good for the price performance monitoring package:
    http://technet.oracle.com/deploy/per.../statspack.pdf
    http://technet.oracle.com/deploy/per...G_dialeris.pdf
    http://technet.oracle.com/deploy/per...ng_otn_new.pdf
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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