Re: oracle high cpu

From: <>
Date: Thu, 07 Aug 2008 23:30:22 +0200
Message-ID: <>

On Thu, 07 Aug 2008 22:34:59 +0200, FrenKy <> wrote:

>hi *,
>oracle 11, solaris 10. 4cpu machine 8GB mem/CPU.
>Oracle comes up to ~30% cpu from time to time and it stays there with
>that CPU usage untill i do init 6.
>Nothing I can thing of accounts to that usage (no sql queries at time it
>goes to 30% cpu)
>How can I check what accounts to this high cpu usage?

30 percent is way too low to pay attention to it. Oracle should run on a dedicated server.
Apart from that the usual Solaris utilities apply, as you can query v$sysstat (Statistic descriptions are in v$statname)

Sybrand Bakker
Senior Oracle DBA
Received on Thu Aug 07 2008 - 16:30:22 CDT

Original text of this message