There is not enough information to make an intelligent guess. For all
we know, it's not even your Oracle instance that's eating up your CPU.
See the top processes at the OS level during those peak times and
check if Oracle (just one big process in WindowsNT or several
processes in Unix flavors) is actually the culprit. Use any OS
monitoring tool available to you. Let's start there.
Would also help if you could provide OS/DB/HW configuration.
And btw, 400,000 inserted rows isn't really that big a number by most
standards.
"Oeleboele" <oe*********@zeron.be> wrote in message news:<10***************@seven.kulnet.kuleuven.ac.b e>...
the situation :
A few days ago I inserted a lot of records (400.000) into my database, since
then I sometimes experience low cpu-power (those moments last around 2
hours) Even when no users are logged into my database.
Is it possible oracle organizes maintenance and takes 30-40% of my cpu ?
(every half hour a small boost in HD-activity)
Before it did not suffer such a loss in cpu-power.
So how can I prevent it ? with some kind of setting ?
tnx in advance
Greetz
Guy Cretskens