Re[2]: SPEED-UP OPERATION

From: <dgoulet_at_vicr.com>
Date: Fri, 2 Jun 2000 08:30:05 -0400
Message-Id: <10516.107532@fatcity.com>

Database/application tuning is a 80/20 proposal. You'll only get a 20% bang for the buck out of the database, while there is a 80% bang by tuning the application namely the SQL being executed. Therefore is your management & end users expect things to run way better by tuning the database, their in for one heck of a shock and you for one heck of a headache. A well tuned database cannot make up for a badly written application, PERIOD.

Brush off your resume, you'll need it.

Dick Goulet
Senior Oracle DBA
Vicor Corporation

____________________Reply Separator____________________

Subject: Re: SPEED-UP OPERATION
Author: Andreas Jung <ajung_at_sz-sb.de>
Date: 6/2/00 3:28 AM

On Fri, Jun 02, 2000 at 01:09:11AM -0800, drichard_at_mtlindia.com wrote:
>
> Dear Experts
>
> I have been asked by the Management and Database Users to speed up the
> application. For that I would like to know what are all the definitions in
the
> back-end
> can be modified to increase the Speed of all queries.
>
> We are using Oracle7 Workgroup Server Release 7.3.2.2.1 on
> Windows NT4 Box.
>
> Please give me few effective hints on what I have to study and implement
> on the Database ?

Take a look at the tuning and performance section of your documentation. Oracle has hundreds of screws that are reponsible for performance.

Maybe you should run the Orasnap utility (http://www.stewartmc.com/oracle/orasnap). This gives you a very close overview to all parts of your
database.

Andreas

-- 
Author: Andreas Jung
  INET: ajung_at_sz-sb.de

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

Received on Fri Jun 02 2000 - 07:30:05 CDT