RE: Performance tuning in complex environment

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Thu, 11 Dec 2003 12:19:26 -0800
Message-ID: <F001.005D9921.20031211121926@fatcity.com>

OK. Before we go blaming Oracle DB, you need to look at the entire picture.

Are other applications within the environment affected by slow performance?
What other apps are running on the network?
Have any network-related diagnostics been performed to ensure that Network bottlenecks are not causing the issue.
What is your disk configuration look like? Mirroring/Striping, etc.
How large/small are the transactions?

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation

Direct:	(313) 227-4350
Mobile:	(248) 408-2918
Email:	Stephen.Karniotis_at_Compuware.com 
Web:	www.compuware.com

-----Original Message-----
Avnish.Rastogi_at_providence.org

Sent:	Thursday, December 11, 2003 2:29 PM
To:	Multiple recipients of list ORACLE-L
Subject:	RE: Performance tuning in complex environment

Not really sure what happened and why we decided to that. I was involved in the beginning of project and remembered that PM was mentioning about talking to another Logician client who were facing same issues.

-----Original Message-----
Jamadagni, Rajendra
Sent: Thursday, December 11, 2003 10:55 AM To: Multiple recipients of list ORACLE-L

Ummm ... what was the problem that prompted you guys to replace citrix servers?

Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
[mailto:Avnish.Rastogi_at_providence.org]
Sent: Thursday, December 11, 2003 1:35 PM To: Multiple recipients of list ORACLE-L

Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues.

Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers.
In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator.

DISCLAIMER:
This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <Avnish.Rastogi_at_providence.org
INET: Avnish.Rastogi_at_providence.org

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.

**********5
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jamadagni, Rajendra
INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Karniotis, Stephen
INET: Stephen_Karniotis_at_compuware.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------