Hi there,

We are running Oracle8i Production on 4CPU Sun-Solaris platform.

Tonight, the Oracle SMON process show strangness. It consumes a lot of CPU resources.

The PID 1625 is the SMON process.

Is it possible to reduce the rate of SMON execution ? (As I know, it will be run every 5 minutes)

Moreover, when the SMON is heavily running, it will increase total SESSIONs too. As a result, the Oracle will run of sessions and work terribly slow.

We tried to restart Oracle several time, but it did not help.

load averages: 8.39, 12.43, 14.49 23:50:48
539 processes: 532 sleeping, 2 running, 5 on cpu
CPU states: 0.2% idle, 84.8% user, 14.5% kernel, 0.5% iowait, 0.0% swap
Memory: 4096M real, 63M free, 1993M swap in use, 3210M swap free

PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
1625 oracle 1 59 0 308M 284M cpu3 7:03 21.04% oracle
4626 oracle 1 0 0 2960K 2024K cpu0 0:17 5.61% top
2772 oracle 1 59 0 309M 289M cpu2 0:11 2.60% oracle
4509 oracle 1 20 0 313M 293M sleep 0:03 1.90% oracle
2682 oracle 1 2 0 309M 289M sleep 0:04 1.43% oracle
4369 oracle 1 52 0 308M 288M sleep 0:04 1.30% oracle
1808 oracle 1 59 0 313M 293M sleep 0:07 1.11% oracle
3560 oracle 1 59 0 309M 289M cpu1 0:03 0.98% oracle
1933 oracle 1 59 0 309M 289M sleep 0:08 0.92% oracle
4484 oracle 1 59 0 308M 288M sleep 0:02 0.92% oracle
4467 oracle 1 59 0 309M 289M sleep 0:04 0.87% oracle
2110 oracle 1 59 0 312M 292M sleep 0:10 0.77% oracle
1724 oracle 1 59 0 309M 289M sleep 0:07 0.74% oracle
4643 oracle 1 59 0 308M 288M sleep 0:02 0.73% oracle
2601 oracle 1 51 0 313M 293M sleep 0:02 0.70% oracle