Re: oracle cpu usage

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 3 Oct 2002 11:32:10 +0100
Message-ID: <anh6b5$sff$1$830fa7a5@news.demon.co.uk>

There are various possibilities:

One of the jobs that smon does (I can't remember which one at the moment) kicks in every hour.

You may have a forced redo log switch (e.g. with archive_lag_target set to 3600 which causes a checkpoint flush every hour.

You may have your job queue processes set to wake up and check for jobs every hour.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9   (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Pinto wrote in message ...


>Hello,

>In our testbed where we are testing our application, i can notice

>periodic spikes in oracle cpu usage. the spikes happen rougly once

>every 1 hour. i have monitored the cpu usage of all the applications

>that are accessing this database and found no corresponding increase

>in any of them.

>how can i identify what is causing this spike ?

>os is win2k and oracle version is 8.1.7

>Thanks and regards,

>Pinto.

Received on Thu Oct 03 2002 - 05:32:10 CDT