I am looking for the query where I can submit the unix process number and get the username and SQL Query it is running.

I have few unix processes running which are CPU bound with parent process number as 1 from more nearly 2 weeks, moreover the idle CPU on the server is most of the time 0%.

Thanks Chetan

-- Chetan Vithlani (chetan.vithlani@convergys.com), September 09, 2002