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

Thread: Oracle/network traffic problems

  1. #1
    Join Date
    Jan 2002
    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
    Chicago IL
    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.

    "High Salaries = Happiness = Project Success."

  3. #3
    Join Date
    Nov 2000
    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:

    This is a good for the price performance monitoring package:
    Jeff Hunter
    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