I usually run top on my sun unix box to see whats running and how much load there is on the box. I find manytimes i get a process in oraclet or oraclep which has taken 15minutes of cpu and a cpu load of 45%. How to i figure why what that process is doing and which user is running that process in oracle.?
running:
ORacle 8i with 11i apps. unix

thanks
Jigar