Oracle Database Discussions

Hi all,

11.2.0.3.10

aix 6

Using topas:

I am monitoring CPU usage on our db server to identify process with high consumption.

I got this output:

Name            PID  CPU%  PgSp Owner           PageIn       24  PAGING SPACE

tnslsnr    46858258   7.8  14.4 oracle          PageOut    1384  Size,MB   16384

oracle     66977894   5.9  13.8 oracle          Sios       1408  % Used      0

oracle     37224624   3.4  13.8 oracle                           % Free    100

oracle     58654834   2.4  15.6 oracle          NFS (calls/sec)

oracle     50069562   2.3  15.6 oracle          SerV2         0  WPAR Activ     0

oracle     61407260   2.1  15.3 oracle          CliV2         0  WPAR Total     0

oracle     55836820   2.1  14.2 oracle          SerV3         0  Press: "h"-help

oracle     64487450   2.0  15.0 oracle          CliV3         0         "q"-quit

oracle     50921644   1.9  14.6 oracle

Why is that the listener is taking high CPU? How can I tune it?

Thanks,

mk