RE: Improve the Performance

We always had trouble with these defaults:

    _crash_on_update=y
    _hang_on_query=y
    _allow_recovery=n
         _random_errors=y
 

They've been caused most of the problems in our past apps. At least management thinks fixing major problems is as simple as changing some parameters and rebooting. Sometimes these take upgrades to personnel to remedy.

-----Original Message-----
From: Nguyen, Tu [mailto:TuNguyen_at_houston.reed-hycalog.slb.com] Sent: Wednesday, November 01, 2000 2:42 PM To: Multiple recipients of list ORACLE-L Subject: RE: Improve the Performance

I tried _make_sql_run_faster = true, and it works

Hahaha

-----Original Message-----
From: Joseph S. Testa [ mailto:teci_at_oracle-dba.com <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
<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
<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
<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