We use a Windows2000-System with 3 processor. Most busy is one of this three
processors. What can I do, to share the resources more symmetrical. Is this
only depending of the operating system or can i manipulate the behavior of
the system on the oracle-site?

Georg Walk

depending on version and licensing you can set parallel option

parallel_max_servers derived from cpu_count
parallel_automatic_tuning <true,false
and you can even set the parallel exec at table level

keep in mind that you apps can handle that kind of parallelism otherwise
you may run the deadlock situations

--
Posted via http://dbforums.com

On Wed, 9 Jul 2003 17:03:33 +0200, "Georg Walk" <Georg.Walk (AT) cai (DOT) de>
wrote:

Look up the notes on NT architecture on Metalink


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

A little bit more information ..... you can do a lot but we need more info.

What version oracle, what version Win 2K (server or pro), how much mem,


what have you done with the W2K res kit to alleviate the problem. What have
you done with Oracle to analyze the problem ?

Why is it busy ?
"Georg Walk" <Georg.Walk (AT) cai (DOT) de> wrote

Informations about the system:
Orcle Version 8.1.7.; Windows 2000 Server
following the systeminfomation
Systeminformationsbericht erstellt am: 02.07.2003 11:11:11
[Systemübersicht]

Element Wert
Betriebssystemname Microsoft Windows 2000 Server
Version 5.0.2195 Service Pack 2 Build 2195
Betriebssystemhersteller Microsoft Corporation
Systemname DBSERVER-ORACLE
Systemhersteller Compaq
Systemmodell ProLiant ML570
Systemtyp X86-basierter PC
Prozessor x86 Family 6 Model 10 Stepping 1 GenuineIntel ~702 MHz
Prozessor x86 Family 6 Model 10 Stepping 1 GenuineIntel ~702 MHz
Prozessor x86 Family 6 Model 10 Stepping 1 GenuineIntel ~702 MHz
BIOS-Version 04/05/01
Windows-Verzeichnis C:\WINNT
Systemverzeichnis C:\WINNT\System32
Startgerät \Device\Harddisk0\Partition1
Gebietsschema Deutschland
Benutzername XXXXXXXXXXXXXXXXXXX
Zeitzone Westeuropäische Sommerzeit
Gesamter realer Speicher 2.096.668 KB
Verfügbarer realer Speicher 752.396 KB
Gesamter virtueller Speicher 8.230.208 KB
Verfügbarer virtueller Speicher 5.703.804 KB
Größe der Auslagerungsdatei 6.133.540 KB
Auslagerungsdatei E:\pagefile.sys

I am not so familiar with the W2K res kit; so give me a tip what are the
first step to evaluate the problem. What is the best way to look on the
performance parameters in teh oracle db. I found a lot of V$...-infos. But
which should I take first?

Georg Walk

"Telemachus" <telemachus (AT) ulysseswillreturn (DOT) net> schrieb im Newsbeitrag
news:WE9Pa.22339$pK2.34213 (AT) news (DOT) indigo.ie...

On Thu, 10 Jul 2003 17:57:48 +0200, "Georg Walk" <Georg.Walk (AT) cai (DOT) de>
wrote:


Just visit Metalink if that's not too much for you. IIRC the Oracle
Press book on Oracle and NT also has details.


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address