Like to know the SQL Query for the unix process number. : LUSENET : DBAzine : One Thread

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 (, September 09, 2002

Moderation questions? read the FAQ