How to find session of the Oracle EBS rwrun process ?
Hi,
From our Oracle Apps server, I found several rwrun processes which use large memory :
-bash-3.00$ prstat -s size -n 10
PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP
11489 appprod 1100M 849M sleep 29 10 0:33:14 0.6% rwrun/13
11508 appprod 1056M 805M cpu94 0 10 0:30:05 0.6% rwrun/13
11488 appprod 1028M 777M cpu112 0 10 0:30:15 0.6% rwrun/13
11487 appprod 1016M 765M cpu66 0 10 0:31:31 0.6% rwrun/13
11619 appprod 620M 369M cpu101 0 10 0:25:56 0.5% rwrun/13
11541 appprod 588M 336M sleep 29 10 0:24:52 0.3% rwrun/13
9234 appprod 504M 253M sleep 29 10 0:17:02 0.3% rwrun/13
27242 appprod 442M 201M cpu69 0 10 0:05:22 0.8% rwrun/13
23845 appprod 432M 182M sleep 29 10 0:08:08 0.3% rwrun/13
How can I found, which sid or concurrent request which related to the rwrun PID ?
I try running this query to find the session info but it return no rows.
0