| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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_<n>=true. Did not try them myself.
>
> Alex Hillman
>
> -----Original Message-----
> From: Dash, Saroj (CAP,CEF) [mailto:Saroj.Dash_at_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_at_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_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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: teci_at_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_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_01C04444.2365C170 Content-Type: text/html; charset="iso-8859-1" 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=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2651.75"> <TITLE>RE: Improve the Performance</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>I tried _make_sql_run_faster =3D true, and it = works</FONT> </P> <P><FONT SIZE=3D2>Hahaha</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Joseph S. Testa [<A = HREF=3D"mailto:teci_at_oracle-dba.com">mailto:teci_at_oracle-dba.com</A>]</FON= T> <BR><FONT SIZE=3D2>Sent: Wednesday, November 01, 2000 1:16 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: Improve the Performance</FONT> </P> <BR> <P><FONT SIZE=3D2>here is the parameters(sorry for the re-run for some = of you).</FONT> </P> <P><FONT SIZE=3D2>Oracle 8.0 _make_sql_run_faster =3D true</FONT> <BR><FONT SIZE=3D2>Oracle 8.1 _make_sql_run_faster=3D1 .. 10</FONT> <BR><FONT SIZE=3D2>pick a value from 1 to 10 to make the sql run = faster</FONT> <BR><FONT SIZE=3D2>Oracle 8.2(or 9i) _make_sql_run_faster =3D = unlimited &nb= sp; no more</FONT> <BR><FONT SIZE=3D2>tuning needed, auto tuning and real quick.</FONT> </P> <P><FONT SIZE=3D2>This is a joke for you newbies.</FONT> </P> <P><FONT SIZE=3D2>joe</FONT> </P> <BR> <P><FONT SIZE=3D2>Alex Hillman wrote:</FONT> </P> <P><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> I remember from previous list postings = something about undocumented</FONT> <BR><FONT SIZE=3D2>> parameters _sql_run_faster=3Dtrue or more = advanced</FONT> <BR><FONT SIZE=3D2>> _sql_run_faster_<n>=3Dtrue. Did not try = them myself.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Alex Hillman</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> -----Original Message-----</FONT> <BR><FONT SIZE=3D2>> From: Dash, Saroj (CAP,CEF) [<A = HREF=3D"mailto:Saroj.Dash_at_gecapital.com">mailto:Saroj.Dash_at_gecapital.com= </A>]</FONT> <BR><FONT SIZE=3D2>> Sent: Tuesday, October 31, 2000 9:00 PM</FONT> <BR><FONT SIZE=3D2>> To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>> Subject: Improve the Performance</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Hi,</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> In a web related application = executing a query it takes lots of</FONT> <BR><FONT SIZE=3D2>> time.Performance is very poor it seems.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> So please suggest me to do the performance good = what are the points to</FONT> <BR><FONT SIZE=3D2>> be</FONT> <BR><FONT SIZE=3D2>> done or rectified to improve the = application.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> The question is : How to improve the = performance of a web based</FONT> <BR><FONT SIZE=3D2>> application</FONT> <BR><FONT SIZE=3D2>> and as well as database .</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> tell me the points to be done in application = side and database side.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Saroj.</FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Author: Dash, Saroj (CAP,CEF)</FONT> <BR><FONT SIZE=3D2>> INET: = Saroj.Dash_at_gecapital.com</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information (like subscribing).</FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Joseph S. Testa</FONT> <BR><FONT SIZE=3D2> INET: teci_at_oracle-dba.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Wed Nov 01 2000 - 14:41:40 CST
 |
 |