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


Moderation questions? read the FAQ