Database Administration (MOSC)

MOSC Banner

How to find session of the Oracle EBS rwrun process ?

edited Sep 11, 2012 10:22AM in Database Administration (MOSC) 2 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center