RE: oracle 8I performanance testing

Thankx for the reply Cary Millsap,

Can u pls explain me step by step how can I do that coz I'm very much
new to oracle.

Thanks & RGDS

Prakash


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Cary Millsap
Sent: Thursday, July 29, 2004 5:27 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: oracle 8I performanance testing

Prakash,

What my staff do as a matter of routine is the following:

1. Profile the response time of each of the business's most important =
=3D
user
actions.

2. Assess those response time profiles, searching for any wasted time =
=3D
that
can be removed inexpensively (typically by means other than hardware
upgrades).

3. If response time is still too large (that is, if performance is still
=3D
too
poor), then quantify the number of seconds that could be saved by =3D
upgrading
a hardware component.

4. If the projected benefit outweighs the projected cost, then move =3D
forward
with the upgrade. (Which in most cases, presumably, will involve a
pre-production testing phase.)

See pages 1-69 of "Optimizing Oracle Performance" for more details.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:
- Performance Diagnosis 101: 8/10 Boston, 9/14 San Francisco, 10/5 =3D
Charlotte
- SQL Optimization 101: 7/26 Washington DC, 8/16 Minneapolis, 9/20 =3D
Hartford
- Hotsos Symposium 2005: March 6-10 Dallas
- Visit www.hotsos.com for schedule details...


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =3D
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Balchandra A. Modak
Sent: Thursday, July 29, 2004 3:49 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: oracle 8I performanance testing

Hi all,
=3D20
 I'm using Orale 8i on unixware ,H/w is 1gb  ram ,,  Xeon 500Mhz Duel
processor ,  IBM netfinity 5500
On Oracle we r using  Etravel application , all Users r complaining
that  application is very slow, so we did indexing ,still application is
very slow . Our application vender is saying that Oracle server is slow
and u need to upgrade the Hardware.
=3D20
Our management ask me the strong reason  to upgrade. =3D20
=3D20
Can anybody pls give me IDEA to check the performance of server and
produce any document on that to management
=3D20
=3D20
RGDS
=3D20
Prakash
=3D20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: