Is it possible to get more information about the program using an Oracle database except from the exe-name? I would like to have the exes version number and/or hash code or something else that allows me to uniquely distinguish one exe-file-version from another.
I don't necessary need to find this info in program code, an admin tool like Toad och Sql Developer would do fine.
Are you able to change the exe-s in question (ie is in an internal app)?
If so, you could set the version number using the DBMS_APPLICATION_INFO package...
The only way I know to reliably get the info you want is to find the OS process ID (v$session) and then use a ps or something like taskmanager.exe to get detail from the client systems OS.
It sounds cumbersome but is scriptable if you have suffient rights on the client app's hosts.