| 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
Don't forget the following:
_voltage_developer=10000 # for kicking off a cartesian join and
wondering why it kills the server.
_voltage_user=1000 # for asking why they can't link a 10-million
row table into MS Access.
_voltage_DBA=10 # for reminding myself to not forget to
recreate that stupid public synonym.
_voltage_manager=1000000 # for making me explain why not to use MS SQL
Server again.
Of course, these are all invoked by either database triggers, or by a simple "alter system discipline" command.
and finally, the undocumented v$view:
v$resume # useful for post-incomplete recoveries...
<ORACLE-L_at_fat
city.com> AT To: Multiple recipients of list ORACLE-L
MEMCPSMTP <ORACLE-L_at_fatcity.com> AT MEMCPSMTP_at_MEMCMail
cc: (bcc: Jim Hawkins/STP/MEMC)
11/01/00 Subject: RE: Improve the Performance
12:42 PM
I tried _make_sql_run_faster = true, and it works
Hahaha
-----Original Message-----
Sent: Wednesday, November 01, 2000 1:16 PM
To: Multiple recipients of list ORACLE-L
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). <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2651.75"> <TITLE>RE: Improve the Performance</TITLE> </HEAD> <BODY> <P><FONT SIZE=2>I tried _make_sql_run_faster = true, and it works</FONT> </P> <P><FONT SIZE=2>Hahaha</FONT> </P> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>From: Joseph S. Testa [<A HREF="mailto:teci_at_oracle-dba.com ">mailto:teci_at_oracle-dba.com</A>]</FONT> <BR><FONT SIZE=2>Sent: Wednesday, November 01, 2000 1:16 PM</FONT> <BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>Subject: Re: Improve the Performance</FONT> </P> <BR> <P><FONT SIZE=2>here is the parameters(sorry for the re-run for some of you).</FONT> </P> <P><FONT SIZE=2>Oracle 8.0 _make_sql_run_faster = true</FONT> <BR><FONT SIZE=2>Oracle 8.1 _make_sql_run_faster=1 .. 10</FONT> <BR><FONT SIZE=2>pick a value from 1 to 10 to make the sql run faster</FONT> <BR><FONT SIZE=2>Oracle 8.2(or 9i) _make_sql_run_faster = unlimited no more</FONT> <BR><FONT SIZE=2>tuning needed, auto tuning and real quick.</FONT> </P> <P><FONT SIZE=2>This is a joke for you newbies.</FONT> </P> <P><FONT SIZE=2>joe</FONT> </P> <BR> <P><FONT SIZE=2>Alex Hillman wrote:</FONT> </P> <P><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> I remember from previous list postings something about undocumented</FONT> <BR><FONT SIZE=2>> parameters _sql_run_faster=true or more advanced</FONT> <BR><FONT SIZE=2>> _sql_run_faster_<n>=true. Did not try them myself.</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> Alex Hillman</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> -----Original Message-----</FONT> <BR><FONT SIZE=2>> From: Dash, Saroj (CAP,CEF) [<A HREF=" mailto:Saroj.Dash_at_gecapital.com ">mailto:Saroj.Dash_at_gecapital.com</A>]</FONT> <BR><FONT SIZE=2>> Sent: Tuesday, October 31, 2000 9:00 PM</FONT> <BR><FONT SIZE=2>> To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>> Subject: Improve the Performance</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> Hi,</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> In a web related application executing a query it takes lots of</FONT> <BR><FONT SIZE=2>> time.Performance is very poor it seems.</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> So please suggest me to do the performance good what are the points to</FONT> <BR><FONT SIZE=2>> be</FONT> <BR><FONT SIZE=2>> done or rectified to improve the application.</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> The question is : How to improve the performance of a web based</FONT> <BR><FONT SIZE=2>> application</FONT> <BR><FONT SIZE=2>> and as well as database .</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> tell me the points to be done in application side and database side.</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> Saroj.</FONT> <BR><FONT SIZE=2>> --</FONT> <BR><FONT SIZE=2>> Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT> <BR><FONT SIZE=2>> --</FONT> <BR><FONT SIZE=2>> Author: Dash, Saroj (CAP,CEF)</FONT> <BR><FONT SIZE=2>> INET: Saroj.Dash_at_gecapital.com</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>> San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>> --------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>> To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>> the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>> (or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT SIZE=2>> also send the HELP command for other information (like subscribing).</FONT> </P> <P><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT> <BR><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Author: Joseph S. Testa</FONT> <BR><FONT SIZE=2> INET: teci_at_oracle-dba.com</FONT> </P> <P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>(or theReceived on Wed Nov 01 2000 - 15:10:51 CST
 |
 |