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 -----------------------------------------------------------------