Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: performance client/server on same/diff machines

RE: performance client/server on same/diff machines

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Tue, 26 Sep 2000 19:09:03 -0700
Message-Id: <10631.117936@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C02827.E8A57A40
Content-Type: text/plain

Since there are no users on the production machine, right now is a good time to look at the application programming. See what the SQL statements are doing and if you can improve them any. Also, this is the time where you anticipate I/O and lay it out as best as possible. At this stage tuning the SGA is useless.

When it goes live, then, tune accordingly.

Regards,
Satar

> -----Original Message-----
> From: Oliver Artelt [SMTP:oli_at_md.transnet.de]
> Sent: Wednesday, September 27, 2000 2:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: performance client/server on same/diff machines
>
>
> Hello everyone,
>
> this one is a little bit more discussable than a one-sentence-question.
> A customer develops itself a www-app with oracle on the one and apache-php
> on
> the other hand. He writes a skript to test the performance of his work.
> (BTW
> this test inserts via apache-php-oci8 48000 rows in a table and measures
> the
> necessary time. The test don't matches their business, but let them...)
> O.K.
> their developing system is one machine running server and client, linux,
> Pentium 400 MHz, 192meg RAM. The production system is a penguin for the
> client to 2x500 MHz Pentium, 1 gig RAM, the production server is a sun,
> sun
> os 5.7, 1 gig ram, 2 x 600 MHz (sorry I don't know the model name),
> running
> 81500 64 bit; 100MBit between them. The customer doesn't understand that
> the
> test on his machine runs 3 mins and the production system needs 12 mins
> for
> that. The ora-server is normal installed but not tuned (It runs on raw
> disks
> and uses 200 meg ram for sga). I think tuning should be done when their
> website runs and the load increases. The machines are mostly idle and
> contains only a few data.
>
> O.K. has anybody an idea why the the server-client system is so slow. Too
> much or less RAM? Metalink? That's normal? Fast Ethernet?
>
> thnx
> oli.
> ---
>
> Oliver Artelt, System- und Datenbankadministration
> ---------------------------------------------------------------
> cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
> telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
> email: oli@cubeoffice.de # web: http://www.cubeoffice.de
> ---------------------------------------------------------------
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Oliver Artelt
> INET: oli_at_md.transnet.de
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C02827.E8A57A40
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">
<TITLE>RE: performance client/server on same/diff machines</TITLE>
</HEAD>
<BODY>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Since there are no = users on the production machine, right now is a good time to look at = the application programming. See what the SQL statements are doing and = if you can improve them any. Also, this is the time where you = anticipate I/O and lay it out as best as possible. At this stage tuning = the SGA is useless.<BR>
</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">When it goes live, = then, tune accordingly.</FONT>
</P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards,<BR> Satar</FONT>

</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =
SIZE=3D1 FACE=3D"Arial">Oliver Artelt [SMTP:oli_at_md.transnet.de]</FONT> <BR><B><FONT SIZE=3D1 FACE=3D"Arial">Sent:&nbsp;&nbsp;</FONT></B> <FONT = SIZE=3D1 FACE=3D"Arial">Wednesday, September 27, 2000 2:20 AM</FONT> <BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT SIZE=3D1 = FACE=3D"Arial">Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT>= </B> <FONT SIZE=3D1 FACE=3D"Arial">performance client/server on = same/diff machines</FONT>
</P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">Hello everyone,</FONT> </P>

<P><FONT SIZE=3D2 FACE=3D"Arial">this one is a little bit more = discussable than a one-sentence-question.</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">A customer develops itself a www-app = with oracle on the one and apache-php on </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">the other hand. He writes a skript to = test the performance of his work. (BTW </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">this test inserts via apache-php-oci8 = 48000 rows in a table and measures the </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">necessary time. The test don't = matches their business, but let them...) O.K. </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">their developing system is one = machine running server and client, linux, </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Pentium 400 MHz, 192meg RAM. The = production system is a penguin for the </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">client to 2x500 MHz Pentium, 1 gig = RAM, the production server is a sun, sun </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">os 5.7, 1 gig ram, 2 x 600 MHz (sorry = I don't know the model name), running </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">81500 64 bit; 100MBit between them. = The customer doesn't understand that the </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">test on his machine runs 3 mins and = the production system needs 12 mins for </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">that. The ora-server is normal = installed but not tuned (It runs on raw disks </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">and uses 200 meg ram for sga). I = think tuning should be done when their </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">website runs and the load increases. = The machines are mostly idle and </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">contains only a few data. </FONT> </P>

<P><FONT SIZE=3D2 FACE=3D"Arial">O.K. has anybody an idea why the the = server-client system is so slow. Too </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">much or less RAM? Metalink? That's = normal? Fast Ethernet?</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">thnx</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">oli.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">---</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Oliver Artelt, System- und = Datenbankadministration</FONT>
<BR><FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=
------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; cubeoffice GmbH &amp; Co.KG # = jordanstrasse 7 # 39112 magdeburg</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">telefon: +49 (0)391 6 11 28 10 # = telefax: +49 (0)391 6 11 28 19</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp; email: oli_at_cubeoffice.de = # web:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A = HREF=3D"http://www.cubeoffice.de" =
TARGET=3D"_blank">http://www.cubeoffice.de</A></FONT></U> <BR><FONT SIZE=3D2 =
FACE=3D"Arial">---------------------------------------------------------=
------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L =
FAQ:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT></U>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Oliver Artelt</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =
oli_at_md.transnet.de</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Fat City Network = Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) = 538-5051</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">San Diego, = California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=
-----------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">To REMOVE yourself from this mailing = list, send an E-Mail message</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">the message BODY, include a line = containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">(or the name of mailing list you want = to be removed from).&nbsp; You may</FONT> Received on Tue Sep 26 2000 - 21:09:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US