I was wondering how to track the oracle process inside the database if you knwo the OS process ID using "top" or "ps -ef" command.
We have one session eating up 60% of CPU resources and trying to track down it's path in the database and its activities inside the database.
TIA