Database Tuning (MOSC)

MOSC Banner

"oracle" user using more CPU memory causing intermittent connection issue

edited Aug 13, 2013 10:17AM in Database Tuning (MOSC) 8 commentsAnswered
Hi Experts,
  I am new to Solaris & Oracle runnign on it. Can someone let me know  if "oracle" user  is really  using so much memory and   is the problem for intermittent connections to end user. Our OS team adivces user its due to more memory consumed
  by "oracle" user process as per below query .
 
     PID USERNAME  SIZE   RSS STATE  PRI NICE      TIME  CPU PROCESS/NLWP
 17578 mqm        17M 4744K sleep   10    0  10:29:01  19% amqcrsta_nd/3
 17420 nechmgr    54M   10M sleep   59    0   4:58:41  10% amqzlaa0_nd/9
 17591 nechmgr    18M 8680K cpu2    21    0   5:11:58 9.8% logdbd/1
 17606 mqm        17M 3680K sleep   59    0   0:34:43 1.1% amqcrsta_nd/3
 17580 mqm        17M 3664K sleep   59    0   0:34:39 1.1% amqcrsta_nd/3
 17577 nechmgr    36M   27M sleep   39    0   0:26:27 0.8% distrib/1
 17588 nechmgr    19M   10M sleep   59    0   0:18:41 0.7% logdbd/1

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