Slow down of server activity???greenspun.com : LUSENET : DBAzine : One Thread |
Scenario:I have an application (Visual Basic - VB) that uses ODBC to connect to my Oracle server 8.1.6 using Oracle drivers. The application works fine until I open the DBA Studio or TOAD(Tools for Oracle for Application Developers which piggy backs on Oracle) which then slows my application down. I have performed various tests confirming that the Client machine that is running the VB application does not hve any memory issues related to the application.
However, I am not able to see if there are memory leaks on the Oracle server because I don't know how to check for memory performance issues.
Question: I was wanting to know how to do performance tuning and Monitoring to detect why there is a slow down and is it Oracle's fault?
-- Vernon (Kercher@adsdb.com), October 02, 2002