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>

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

</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] 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?

<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>

Oliver Artelt, System- und = Datenbankadministration
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

------
   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_at_cubeoffice.de = # web: <A = HREF=3D"http://www.cubeoffice.de" =
TARGET=3D"_blank">http://www.cubeoffice.de</A> <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

------

<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>

<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

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 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 Received on Tue Sep 26 2000 - 21:09:03 CDT