Re: load balancing on a multi-processorsysstem

From: Georg Walk <Georg.Walk_at_cai.de>
Date: Thu, 10 Jul 2003 17:57:48 +0200
Message-ID: <3f0d89ca$1_1@news.ecore.net>

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.net> schrieb im Newsbeitrag news:WE9Pa.22339$pK2.34213_at_news.indigo.ie...
> 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.de> wrote in message
> news:3f0c2b99$1_1_at_news.ecore.net...
> > 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
> >
> >
>
>
Received on Thu Jul 10 2003 - 10:57:48 CDT