Message-Id: <10667.120862@fatcity.com> From: "Nguyen, Tu" Date: Wed, 1 Nov 2000 14:41:40 -0600 Subject: RE: Improve the Performance 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_01C04444.2365C170 Content-Type: text/plain; charset="iso-8859-1" I tried _make_sql_run_faster = true, and it works Hahaha -----Original Message----- From: Joseph S. Testa [mailto:teci@oracle-dba.com] Sent: Wednesday, November 01, 2000 1:16 PM To: Multiple recipients of list ORACLE-L Subject: Re: Improve the Performance here is the parameters(sorry for the re-run for some of you). Oracle 8.0 _make_sql_run_faster = true Oracle 8.1 _make_sql_run_faster=1 .. 10 pick a value from 1 to 10 to make the sql run faster Oracle 8.2(or 9i) _make_sql_run_faster = unlimited no more tuning needed, auto tuning and real quick. This is a joke for you newbies. joe Alex Hillman wrote: > > > I remember from previous list postings something about undocumented > parameters _sql_run_faster=true or more advanced > _sql_run_faster_=true. Did not try them myself. > > Alex Hillman > > -----Original Message----- > From: Dash, Saroj (CAP,CEF) [mailto:Saroj.Dash@gecapital.com] > Sent: Tuesday, October 31, 2000 9:00 PM > To: Multiple recipients of list ORACLE-L > Subject: Improve the Performance > > Hi, > > In a web related application executing a query it takes lots of > time.Performance is very poor it seems. > > So please suggest me to do the performance good what are the points to > be > done or rectified to improve the application. > > The question is : How to improve the performance of a web based > application > and as well as database . > > tell me the points to be done in application side and database side. > > Saroj. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dash, Saroj (CAP,CEF) > INET: Saroj.Dash@gecapital.com > > 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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: teci@oracle-dba.com 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@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_01C04444.2365C170 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Improve the Performance

I tried _make_sql_run_faster =3D true, and it = works

Hahaha

-----Original Message-----
From: Joseph S. Testa [mailto:teci@oracle-dba.com]
Sent: Wednesday, November 01, 2000 1:16 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Improve the Performance


here is the parameters(sorry for the re-run for some = of you).

Oracle 8.0 _make_sql_run_faster =3D true
Oracle 8.1 _make_sql_run_faster=3D1 .. 10
pick a value from 1 to 10 to make the sql run = faster
Oracle 8.2(or 9i) _make_sql_run_faster =3D = unlimited          &nb= sp;    no more
tuning needed, auto tuning and real quick.

This is a joke for you newbies.

joe


Alex Hillman wrote:

>
>
> I remember from previous list postings = something about undocumented
> parameters _sql_run_faster=3Dtrue or more = advanced
> _sql_run_faster_<n>=3Dtrue. Did not try = them myself.
>
> Alex Hillman
>
> -----Original Message-----
> From: Dash, Saroj (CAP,CEF) [mailto:Saroj.Dash@gecapital.com= ]
> Sent: Tuesday, October 31, 2000 9:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Improve the Performance
>
> Hi,
>
>   In a web related application = executing a query it takes lots of
> time.Performance is very poor it seems.
>
> So please suggest me to do the performance good = what are the points to
> be
> done or rectified to improve the = application.
>
> The question is : How to improve the = performance of a web based
> application
> and as well as database .
>
> tell me the points to be done in application = side and database side.
>
> Saroj.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dash, Saroj  (CAP,CEF)
>   INET: = Saroj.Dash@gecapital.com
>
> 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@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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph S. Testa
  INET: teci@oracle-dba.com

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