RE: oracle 8I performanance testing
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Jul 2004 08:41:05 -0500
Prakash,
It's a pretty long story. Start by visiting
http://www.oreilly.com/catalog/optoraclep/index.html. There you can read
Chapter 1 an excerpt from Chapter 12, free of charge.
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 =
Charlotte
- SQL Optimization 101: 7/26 Washington DC, 8/16 Minneapolis, 9/20 =
Hartford
- Hotsos Symposium 2005: March 6-10 Dallas
- Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Balchandra A. Modak
Sent: Thursday, July 29, 2004 8:30 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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
=3D3D
user
actions.
2. Assess those response time profiles, searching for any wasted time =
=3D
=3D3D
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
=3D3D
too
poor), then quantify the number of seconds that could be saved by =3D3D
upgrading
a hardware component.
4. If the projected benefit outweighs the projected cost, then move =
=3D3D
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 =3D3D
Charlotte
- SQL Optimization 101: 7/26 Washington DC, 8/16 Minneapolis, 9/20 =3D3D
Hartford
- Hotsos Symposium 2005: March 6-10 Dallas
- Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =3D3D
[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,
=3D3D20
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.
=3D3D20
Our management ask me the strong reason to upgrade. =3D3D20
=3D3D20
Can anybody pls give me IDEA to check the performance of server and
produce any document on that to management
=3D3D20
=3D3D20
RGDS
=3D3D20
Prakash
=3D3D20
----------------------------------------------------------------
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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
