RE: Improve the Performance

From: Kirsh, Gary <gary.kirsh_at_gs.com>
Date: Fri, 3 Nov 2000 09:32:40 -0500
Message-Id: <10669.121062@fatcity.com>

I'm probably violating my confidentiality agreement with Oracle by = posting
some of these internal use only parameters, but I see it as a public service:

LOG_ENTRY_PREBUILD_THRESHOLD =3D 0
LOG_CABIN =3D VERMONT
AUTO_SELF_OPTIMIZATION =3D ON
MIRRORS =3D YES
SMOKE =3D ON Gary

Gary Kirsh
Next Extent, Inc.

-----Original Message-----
From: ddorr.cs_at_clearstream.com [mailto:ddorr.cs_at_clearstream.com] Sent: Friday, November 03, 2000 7:46 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Improve the Performance

##### WARNING ! ##### this parameter is only working on *nix platforms : it's simply ignored = on
Windoze systems !

> ----------
> From: Anderson, Brian[SMTP:andersob_at_mail.dartnet.peachnet.edu]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, November 02, 2000 23:16
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Improve the Performance

>=20

> You must be thinking of _dont_crash =3D true.

>=20


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

>=20
>=20
>=20


> 	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.

>=20


> 	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"

>=20


> 	Alex Hillman=20

>=20


> 	-----Original Message-----=20

> 	From: Hatzistavrou Giannis [ 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

>=20
>=20


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

>=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.=20

> 	> 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>]=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>=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=20

> 	--=20

> 	Author: Hatzistavrou Giannis=20

> 	  INET: j.hatzistavrou_at_telesoft.gr=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
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author:=20

INET: ddorr.cs_at_clearstream.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 Received on Fri Nov 03 2000 - 08:32:40 CST