All, how can I find out which user has this OS PID in oracle and where is he loggind in from.
oracle 2858 1 0 Nov 28 ? 0:00 oracleprod (LOCAL=NO)
this proc has been running to long.