Re: Need help on oracle 8i db

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" <oeleboeleke_at_zeron.be> wrote in message news:<1087336730.147921_at_seven.kulnet.kuleuven.ac.be>...
> 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
Received on Wed Jun 16 2004 - 04:31:03 CEST