RE: oracle 8I performanance testing

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Thu, 29 Jul 2004 08:41:05 -0500
Message-ID: <013501c47571$b59e9640$6501a8c0@CVMLAP02>

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_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Balchandra A. Modak
Sent: Thursday, July 29, 2004 8:30 AM
To: oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Cary Millsap Sent: Thursday, July 29, 2004 5:27 PM
To: oracle-l_at_freelists.org
Subject: RE: oracle 8I performanance testing

Prakash,

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

Profile the response time of each of the business's most important =
=3D
=3D3D
user actions.
Assess those response time profiles, searching for any wasted time =
=3D
=3D3D
that can be removed inexpensively (typically by means other than hardware upgrades).
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.
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_at_freelists.org =3D3D [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Balchandra A. Modak
Sent: Thursday, July 29, 2004 3:49 AM
To: oracle-l_at_freelists.org
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_at_freelists.org 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_at_freelists.org
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_at_freelists.org
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_at_freelists.org
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
-----------------------------------------------------------------

Received on Thu Jul 29 2004 - 08:37:58 CDT