Re: How to monitor db usage

Hi Ken:

I'm not sure what you want but maybe:

-You can view the open sessions on the session manager/lock manager/instance manger(my dba alwyas clicks on a icon, I dont exactly know what he starts.). This is a oracle server tool
-To see se query's performed you can set the "SQLTRACE" option to true. This can be done either in the oraXXX.ini file for all the sessions that connect to the database, or you can set it from your session (But i don't know how to do that in in VB5). Oracle will create a trace file in a directory on the server. You can check that ascii file or process it with tkprof* (tkprof73.exe for oracle 7.3).

If you exit a application the session is closed, so no open handles can be left open afterwards at the server. However if you do not close properly, some data may be rolled back instead of commited. If vb5 is 32 bit (it is?) closing the application cleans all data after you, doesn't it?

Ken Macpherson wrote:

> I just want to monitor incoming queries on the database.
>
> I have a VB5 app which performs remote queries via recordset on a unix
> oracle db.
>
> I want to check that my app is cleaning up after itself correctly and not
> leaving open handles etc.
>
> Can anyone suggest how to do this (a command like top would be nice).
Received on Wed Oct 14 1998 - 15:29:20 CEST