Home » RDBMS Server » Server Administration » How to control CPU Utilization ?
How to control CPU Utilization ? [message #56333] Wed, 19 March 2003 15:15 Go to next message
bvg
Messages: 3
Registered: March 2003
Junior Member
We are running Oracle 8.1.7.4 with Parallel Server Option. All our data loads are pretty fast because of this. But, during the load of two processes, the CPU is shooting upto to 80%. Is there any way I can control this without compromising on the load time ?

Also, I checked the table in dba_tables and the degree is 1 for this table. Does it help in any way if I increase this degree to 12 ?

Any help is greately appreciated.

Thanks in advance.

Report message to a moderator

Re: How to control CPU Utilization ? [message #56377 is a reply to message #56333] Tue, 25 March 2003 17:40 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
No. Why you want to set it up to 12. That means degree of parallelism - 12. With 2 CPU's there will be more time spend to schedule the whole 12 parallel processes to run than to do some query processing..

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Query about Rollback Segment
Next Topic: IP address change.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:41:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.