RE: Improve the Performance

From: Anderson, Brian <andersob_at_mail.dartnet.peachnet.edu>
Date: Thu, 2 Nov 2000 17:03:23 -0500
Message-Id: <10668.121007@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_01C04518.B7F544D0
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

You must be thinking of _dont_crash =3D true.

-----Original Message-----
From: Alex Hillman [mailto:alex_hillman_at_physia.com] Sent: Thursday, November 02, 2000 10:26 AM To: Multiple recipients of list ORACLE-L Subject: RE: Improve the Performance

I hope (maybe I am wrong ) that my answer was a repetition of old joke = from
the list because the question was very similar to the old post answer = on
which was this joke.

Even better post than "How to improve performance?" would be like "I am = new
to Oracle, how to make it work that there never would be any problem at = all"

Alex Hillman=20

-----Original Message-----=20
From: Hatzistavrou Giannis [ mailto:j.hatzistavrou_at_telesoft.gr <mailto:j.hatzistavrou_at_telesoft.gr> ]=20 Sent: Thursday, November 02, 2000 7:21 AM=20 To: Multiple recipients of list ORACLE-L=20 Subject: RE: Improve the Performance=20

The old joke hits back!!!!!!!!=20

> -----Original Message-----=20
> From: Alex Hillman [SMTP:alex_hillman_at_physia.com]=20
> Sent: =D4=E5=F4=DC=F1=F4=E7, 1 =CD=EF=E5=EC=E2=F1=DF=EF=F5 2000 5:51 =
=EC=EC=20
> To: Multiple recipients of list ORACLE-L=20
> Subject: RE: Improve the Performance=20

>=20

> I remember from previous list postings something about undocumented=20
> parameters _sql_run_faster=3Dtrue or more advanced =
_sql_run_faster_<n>=3Dtrue.

> Did not try them myself.=20

>=20

> Alex Hillman=20

>=20

> -----Original Message-----=20
> From: Dash, Saroj (CAP,CEF) [ < mailto:Saroj.Dash_at_gecapital.com
<mailto:Saroj.Dash_at_gecapital.com> >]=20
> Sent: Tuesday, October 31, 2000 9:00 PM=20
> To: Multiple recipients of list ORACLE-L=20
> Subject: Improve the Performance=20

>=20
>=20

> Hi,=20

>=20

> In a web related application executing a query it takes lots of=20
> time.Performance is very poor it seems.=20
>=20
> So please suggest me to do the performance good what are the points =
to be=20
> done or rectified to improve the application.=20

>=20

> The question is : How to improve the performance of a web based=20
> application=20
> and as well as database .=20

>=20

> tell me the points to be done in application side and database side.=20

>=20

> Saroj.=20
> --=20
> Please see the official ORACLE-L FAQ: < http://www.orafaq.com
<http://www.orafaq.com> >=20
> --=20
> Author: Dash, Saroj (CAP,CEF)=20
> INET: Saroj.Dash_at_gecapital.com=20

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051=20

> San Diego, California        -- Public Internet access / Mailing =

Lists=20


> --------------------------------------------------------------------=20

> To REMOVE yourself from this mailing list, send an E-Mail message=20
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20
> the message BODY, include a line containing: UNSUB ORACLE-L=20
> (or the name of mailing list you want to be removed from). You may=20
> also send the HELP command for other information (like subscribing).=20
>=20
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> =20
--=20
Author: Hatzistavrou Giannis=20
INET: j.hatzistavrou_at_telesoft.gr=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051=20
San Diego, California        -- Public Internet access / Mailing Lists=20
--------------------------------------------------------------------=20

To REMOVE yourself from this mailing list, send an E-Mail message=20 to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20 the message BODY, include a line containing: UNSUB ORACLE-L=20 (or the name of mailing list you want to be removed from). You may=20 also send the HELP command for other information (like subscribing).=20

------_=_NextPart_001_01C04518.B7F544D0
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<TITLE>RE: Improve the Performance</TITLE>

<META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D990271222-02112000><FONT face=3DArial =

color=3D#0000ff size=3D2>You=20
must be thinking of _dont_crash =3D true.</DIV> <BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px"> <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft>-----Original Message----- From: Alex Hillman=20 [mailto:alex_hillman_at_physia.com] Sent: Thursday, November = 02, 2000=20
 10:26 AM To: Multiple recipients of list = ORACLE-L Subject:=20
 RE: Improve the Performance </DIV> I hope (maybe I am wrong ) that my answer was a = repetition of=20
 old joke from the list because the question was very similar to the = old post=20
 answer on which was this joke. Even better post than "How to improve performance?" = would be=20
 like "I am new to Oracle, how to make it work that there never would = be any=20
 problem at all"
 Alex Hillman -----Original Message----- From:=20
 Hatzistavrou Giannis [<A=20
 =
href=3D"mailto:j.hatzistavrou_at_telesoft.gr">mailto:j.hatzistavrou_at_telesof= t.gr</A>]=20
 Sent: Thursday, November 02, 2000 7:21 AM = <FONT=20
 size=3D2>To: Multiple recipients of list ORACLE-L <FONT=20 size=3D2>Subject: RE: Improve the Performance The old joke hits back!!!!!!!! > -----Original Message----- >=20
 From: Alex Hillman [SMTP:alex_hillman_at_physia.com] >=20
 Sent: =D4=E5=F4=DC=F1=F4=E7, 1 =CD=EF=E5=EC=E2=F1=DF=EF=F5 2000 5:51 = =EC=EC >=20 To:   Multiple recipients of list ORACLE-L <FONT =

size=3D2>> Subject:      RE: Improve the=20 Performance > > I=20
 remember from previous list postings something about = undocumented=20
 > parameters _sql_run_faster=3Dtrue or more = advanced=20
 _sql_run_faster_<n>=3Dtrue. > Did = not try them=20
 myself. > > = Alex Hillman=20
 > > = -----Original=20
 Message----- > From: Dash, Saroj = (CAP,CEF) [ <<A=20
 =
href=3D"mailto:Saroj.Dash_at_gecapital.com">mailto:Saroj.Dash_at_gecapital.com= </A>>]=20
 > Sent: Tuesday, October 31, 2000 9:00 = PM=20
 > To: Multiple recipients of list = ORACLE-L=20
 > Subject: Improve the Performance = <FONT=20
 size=3D2>> > <FONT =

size=3D2>&gt; Hi,=20
  </FONT><BR><FONT size=3D2>&gt; </FONT><BR><FONT =
size=3D2>&gt;&nbsp;&nbsp; In a web=20

related application executing a query it takes lots of =

</FONT><BR><FONT=20
  size=3D2>&gt; time.Performance is very poor it seems. =
</FONT><BR><FONT=20
  size=3D2>&gt; </FONT><BR><FONT size=3D2>&gt; So please suggest me to =

do the=20
 performance good what are the points to be > done=20
 or rectified to improve the application. >=20
 > The question is : How to improve the = performance=20
 of a web based > application = <FONT=20
 size=3D2>> and as well as database . >=20
 > tell me the points to be done in = application side=20
 and database side. > >=20
 Saroj. > -- > Please see=20
 the official ORACLE-L FAQ: <<A target=3D_blank=20 href=3D"http://www.orafaq.com">http://www.orafaq.com</A>> = <FONT=20
 size=3D2>> -- > Author: Dash, = Saroj =20
 (CAP,CEF) >   INET:=20 Saroj.Dash_at_gecapital.com > = <FONT=20
 size=3D2>> Fat City Network Services    -- (858)=20 538-5051  FAX: (858) 538-5051 > San = Diego,=20
 California        -- Public = Internet access=20
 / Mailing Lists >=20

  --------------------------------------------------------------------=20

> To REMOVE yourself from this mailing = list, send=20
 an E-Mail message > to: = ListGuru_at_fatcity.com (note=20
 EXACT spelling of 'ListGuru') and in > = the message=20
 BODY, include a line containing: UNSUB ORACLE-L >=20
 (or the name of mailing list you want to be removed from).  You = may=20
 > also send the HELP command for other = information=20
 (like subscribing). > --=20
 Please see the official ORACLE-L FAQ: <A = target=3D_blank=20
 href=3D"http://www.orafaq.com">http://www.orafaq.com</A> = <FONT=20
 size=3D2>-- Author: Hatzistavrou = Giannis=20
   INET: j.hatzistavrou_at_telesoft.gr = 
 Fat City Network Services    -- = (858)=20
 538-5051  FAX: (858) 538-5051 San = Diego,=20
 California        -- Public = Internet access=20
 / Mailing Lists <FONT=20
 =

size=3D2>---------------------------------------------------------------=

-----=20
 To REMOVE yourself from this mailing list, send an = E-Mail=20
 message to: ListGuru_at_fatcity.com (note = EXACT spelling=20
 of 'ListGuru') and in the message BODY, = include a line=20
 containing: UNSUB ORACLE-L (or the name of = Received on Thu Nov 02 2000 - 16:03:23 CST