RE: oracle 8I performanance testing

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 29 Jul 2004 08:42:06 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00B0A@EXCHMN3>

Prakash

You should purchase a copy of Cary's book "Optimizing Oracle Performance".

If you are new to Oracle, facing a significant performance problem, you will probably end up paying someone to help you understand and resolve your performance problems. The problem is how to know whose method to trust. Cary's book does the best job of any available resource for understanding the underlying issues, which will help you evaluate the people that will offer to provide you help. As you will be able to see from the sample chapter, Cary's book is written in a clear easy-to-understand manner.

Dennis Williams
DBA
Lifetouch, Inc.

"We all want progress, but if you're on the wrong road, progress means doing an about-turn and walking back to the right road; in that case, the man who turns back soonest is the most progressive." -- C.S. Lewis

-----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
user actions.
Assess those response time profiles, searching for any wasted time =
=3D
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
=3D
too poor), then quantify the number of seconds that could be saved by =3D upgrading a hardware component.
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_at_freelists.org =3D
[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,
=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_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:42:30 CDT