Toad World® Forums

Inspect SGA Job - Can additional criteria be added to connection identity?

We have several application servers that are hitting the database. The applications are similar on the servers, but specifics clients of ours are accessing the db through one of them. Sometimes I need to capture activity from a specific server. The TERMINAL parameter for all servers is just unknown but the machine has the server hostname in it. We also utilize registering some applications and store identity in CLIENT_INFO, MODULE, and ACTION fields in the v$session info. Can these additional parameters be added to the CONNECTION IDENTITY ??

Thank you very much for interest in our product.

Currently, the Inspector Add Job wizard does provide MODULE as one of the SQL filter condition. But the value is retrieved from V$SQLAREA instead of V$SESSION. Your suggestion is good indeed. We will consider adding more SQL filter condition to the Connection Identify section in our future release.

Thanks,
Kelvin