Re: oracle high cpu
From: <sybrandb_at_hccnet.nl>
Date: Thu, 07 Aug 2008 23:30:22 +0200
Message-ID: <b8qm945l6ophk4vecnl7j62hd988nvleg4@4ax.com>
Date: Thu, 07 Aug 2008 23:30:22 +0200
Message-ID: <b8qm945l6ophk4vecnl7j62hd988nvleg4@4ax.com>
On Thu, 07 Aug 2008 22:34:59 +0200, FrenKy <ime_at_prezime.com> 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 DBAReceived on Thu Aug 07 2008 - 16:30:22 CDT