Need help on oracle 8i db

[Oeleboele]

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

[Romeo Olympia]

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

[Oeleboele]

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
cpu : Intel P4 2ghz
mem : 1 gig

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

"Romeo Olympia" <ro******@hotmail.com> schreef in bericht
news:42**************************@posting.google.c om...

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