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