Re: smon is hogging CPU resources

From: Alexander Skwar <alexander_at_skwar.name>
Date: Mon, 30 Oct 2006 16:16:18 +0100
Message-ID: <1601666.Emzv8HZjIL@work.message-center.info>

Alexander Skwar <alexander_at_skwar.name>:

> How can I find out what's going on there?

I now have the issue, that I "hardly" can login to the database with "sqlplus '/ as sysdba'" anymore. With "hardly", I mean, that it takes about 5 minutes until I'm logged in. Having a look at top a few minutes ago, I saw:

CPU TTY     PID USERNAME PRI NI   SIZE    RES STATE    TIME %WCPU  %CPU COMMAND
 1   ?    27245 oracle   156 20   130M  1736K sleep   10:20 48.90 48.82 ora_snp0_DEDB
 1   ?    21542 oracle   156 20   130M  1708K sleep    0:33 30.36 30.14 oracleDEDB
 0   ?    21147 oracle   205 20   130M  1836K run      0:46 17.39 17.36 oracleDEDB

 1 pts/12 20027 ccm_root 152 20   800M   204M run      0:49  4.42  4.41 java  1   ?    27249 oracle   156 20   130M  1764K sleep    4:27  1.96  1.95 ora_snp2_DEDB

So, snp0 and snp2 are also CPU intense.

I tried to shutdown the database with "shutdown" on the SQL*Plus prompt. Up to now, it took like 10 minutes and the database is still up. It never took so long to shut it down. And smon is eating CPU again like crazy:

 0 ? 27234 oracle 230 20 130M 1572K run 109:43 99.54 99.37 ora_smon_DEDB

Confused,

Alexander Skwar

-- 
Two wrongs don't make a right, but they make a good excuse.
                -- Thomas Szasz

Received on Mon Oct 30 2006 - 09:16:18 CST