RE: SPEED-UP OPERATION

From: Jain, Akshay <Akshay.Jain_at_cit.com>
Date: Fri, 2 Jun 2000 11:14:51 -0400
Message-Id: <10516.107564@fatcity.com>

My $0.02:

There are at least three important aspects to a well running application system on Oracle:

Good SQL and data structures
A well tuned and configured Oracle instance
Good management of multiple users in an OLTP environment.

For (1), Please refer to a good SQL tuning book like "Oracle SQL High Performance Tuning"
by Guy Harrison. You can do a trace of the SQL on your instance and do a TKProf to see if you are doing excessive full table scans, or if bad queries are going at too many data blocks.

For (2), a "utlbstat, utlestat" will produce a report summarizing the performance
of your instance in general. The issue is configuration for good disk access,
and good SGA configuration. Again, the gurus on this list can help once you have this report. (Refer to Kevin Loney's book on Oracle instance tuning).

For (3), this is where system designers come in. If users are getting needlessly
serialized and lock up large sets of data and if you have many users concurrently
accessing data for modification, then problems in locking are going to go deep
and cannot be quickly resolved. But if you know that you have done 1 and 2, then
investigating 3 will be a good analysis of why the system is still slow.

Akshay Jain

Newcourt-CIT
Tel. (416) 507-5385
mailto:Akshay.Jain_at_cit.com

-----Original Message-----
From: drichard_at_mtlindia.com [mailto:drichard_at_mtlindia.com] Sent: Friday, June 02, 2000 5:09 AM
To: Multiple recipients of list ORACLE-L Subject: SPEED-UP OPERATION

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 ?

Thanks
Richard

-- 
Author: 
  INET: drichard_at_mtlindia.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

Received on Fri Jun 02 2000 - 10:14:51 CDT