Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: SPEED-UP OPERATION
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
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