I have problems like this with old 2.4 kernel - RH AS 2.1
Problems occurs when big io. and configured huge values of min/max -
readahead.
In this case I'm also have huge sys time.
Also, problems like this possible, if you use inderect_data_buffers or
NAS storage, software raid (md).

Please run vmstat 5, and copy/paste results.

Another way for this problems is
your application use dedicated connections and very often open new sessions.
Please check your listener.log. If so, please try to configure via
shared connection.

Andrew Edunov wrote:
>> Ok, lets see if it is the oracle processes are consuming all the CPU.
>>
>> Two ways of doing this (without requiring the diagnostics pack) is
>> either statspack or
>> a select from v$sysstat.
>> The latter is probably the quickest:
>>
>> From SQL*Plus (logged in as sysdba) do:
>>
>> set time on
>> select name, value from v$sysstat where statistic#=12;
>>
>> then wait a minute or two
>>
>> then reexecute last sql:
>>  
>
> SQL> set time on
> 12:50:50 SQL> select name, value from v$sysstat where statistic#=12;
>
> NAME                                            VALUE
> ---------------------------------------------------------------- ----------
> CPU used by this session                             18525610
>
> 12:51:01 SQL> /
>
> NAME                                            VALUE
> ---------------------------------------------------------------- ----------
> CPU used by this session                             18525610
>
> 12:52:55 SQL>
>
> Best regards,
> Andrew.
>
>
>  

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting