> 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