Re: Need help on oracle 8i db

It's task manager that says it's the oracle proces that takes 30-40%

OS :Windows 2000
DB : Oracle 8.1.5
hd : Eide Barracuda Seagate 7200 udma

no 400.000 is not that much.. but since than I experience those troubles. (there is still enough room on hd => 14gigs)

"Romeo Olympia" <rolympia_at_hotmail.com> schreef in bericht news:42fc55dc.0406151831.48acc10b_at_posting.google.com...
> 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 - 08:20:29 CEST