Message-Id: <10667.120808@fatcity.com> From: Alex Hillman Date: Wed, 1 Nov 2000 10:42:26 -0500 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_01C0441A.574BB560 Content-Type: text/plain; charset="iso-8859-1" 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). ------_=_NextPart_001_01C0441A.574BB560 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Improve the Performance

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 =