473,320 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Need help on oracle 8i db

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

Jul 19 '05 #1
2 1946
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

Jul 19 '05 #2
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

Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jan Bols | last post by:
I've been trying to install Oracle 8.1.7 on a fresh Mandrake 9.1 O.S for days, but I'm still not able to get it running. I've tried several install instructions that I found on the internet but no...
7
by: Galina | last post by:
Hello I am going to copy a data from MS Access table into Oracle table. One of fields is memo type and data in this field range from 1 character to 551 long string. Do I need to create a field...
0
by: Steven Green | last post by:
I need some help to get a training grant. If you are responsible for hiring Oracle professionals please read on. I want to become an Oracle DBA and am seeking to take a DBA certificate program....
5
by: mr.iali | last post by:
Hi Everyone I would like to get into software developent using a programming language like c++, java or pl/sql for oracle. I have no idea where to start from. Which language is there more...
3
by: Bob.Henkel | last post by:
I write this to tell you why we won't use postgresql even though we wish we could at a large company. Don't get me wrong I love postgresql in many ways and for many reasons , but fact is fact. If...
1
by: tristant | last post by:
Hi All, We want to develope Windows and Web .NET application on Oracle 9i on AIX. Also we will use Crystal Report for reporting. I have question about the what Visual Studio.NET edition do we...
92
by: Ray | last post by:
I just moved to another company that's mainly a Java/.NET shop. I was happy to find out that there's a movement from the grassroot to try to convince the boss to use a dynamic language for our...
0
by: NSD | last post by:
Which Oracle program to use for adminitration and book-keeping Hello there, I am new to Oracle and I need to know how I can insert my company's data (administration and book - keeping) into an...
21
by: nihad.nasim | last post by:
Hi there, I have a database in Access that I need on the web. The web page should connect to the database and write records for certain tables and view records for others. I want to know a...
5
by: vamsioracle | last post by:
Hi Folks I have written a code to send emails from oracle. Below is the code. I have registered this is Apps and scheduled the concurrent program to run every day. Now i want implement logic, such...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.