Unanswered: how to find oracle database name from windows pid
I am running two databases on one machine.
one of the databases is taking almost 90% of the cpu time ( as shown by windows task manager).
However, I am not able to determine which database is the one taking all the resources. Can anyone please tell me how to find that out.
One way could be if there was some method by which i could find the name of the database using the pid depicted in the task manager corresponding to the oracle.exe process.