need help on a Oracle 8i db

#1

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

#2

"Oeleboele" <oeleboeleke (AT) zeron (DOT) be> wrote

Quote:

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

No, Oracle does no such thing.

Jim

#3

any idea on what he could do ?
because nobody is connected.. and the oracle-process still takes 30-40% of
the cpu.

"Jim Kennedy" <kennedy-downwithspammersfamily (AT) attbi (DOT) net> schreef in bericht
news:QQOzc.111954$Ly.57978 (AT) attbi_s01 (DOT) ..

Quote:

"Oeleboele" <oeleboeleke (AT) zeron (DOT) be> wrote in message
news:1087336763.259436 (AT) seven (DOT) 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

No, Oracle does no such thing.
Jim

#4

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

and all this started since my last insert of only 400.000records

"Oeleboele" <oeleboeleke (AT) zeron (DOT) be> schreef in bericht
news:1087366396.217202 (AT) seven (DOT) kulnet.kuleuven.ac.be...

Quote:

any idea on what he could do ?
because nobody is connected.. and the oracle-process still takes 30-40% of
the cpu.

"Jim Kennedy" <kennedy-downwithspammersfamily (AT) attbi (DOT) net> schreef in
bericht
news:QQOzc.111954$Ly.57978 (AT) attbi_s01 (DOT) ..

"Oeleboele" <oeleboeleke (AT) zeron (DOT) be> wrote in message
news:1087336763.259436 (AT) seven (DOT) 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

No, Oracle does no such thing.
Jim

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

need help on a Oracle 8i db

comp.database.oracle comp.database.oracle

need help on a Oracle 8i db - 06-15-2004 , 04:58 PM

Re: need help on a Oracle 8i db - 06-15-2004 , 10:08 PM

Re: need help on a Oracle 8i db - 06-16-2004 , 01:11 AM

Re: need help on a Oracle 8i db - 06-16-2004 , 01:59 AM