Oh I've run into THIS before....you are in a sticky technical AND political situation I am sure.
It is really not that complex. I'll bet they (your DBAs) have already been told you that the app is horribly designed and it was a mistake and that the hardware is under powered canned "dataserver install" was poorly laid out. The vendor says everything is fine and are basically silent but willing to send in expensive consultants. You don't trust you DBA's. They are pissed at you and the vendor. (imagine that) Now you are stuck with hearing exactly what you didn't want to hear. The DBA's (If they are Oracle DBA's) have done everything they can and now you are on a fishing expedition because you don't trust your DBAs...you probably have been glazing over when ever you hear them talk about issues with this system...because of that they have washed their hands of it. They can't help you if you don't all sit down and listen and respect each other. I'll put got $20 bucks that if I came in and sat down with them for ten minutes I'd find out they were sharp competent people who have been given the crap because of this lousy application. So why don't you send your DBAs in here and let them tell the folks on this board what they have done thus far and maybe there will be some good come out if it. Also expect that apps purchased two years ago are going to royally suck for the most part as the software industry was a giant scam at that time. Frankly if you have multiple users on citrix attaching to oracle expect poor performance. Think about it. A Citrix server with dozens of users using the same resources to display an entire desktop across the network....Have you determined if it is app performance or oracle? What this tells me is this is a client server app licensed to sacrifice cost versus performance. You bought the Citrix version to save money no doubt. Now you are stuck. Either way you have fell for the "sell them the sizzle give them the bacon later" software bait and switch. Do queries typically run faster on a stand alone install of the client than the Citrix? Do the queries run by the app run the same or faster when executed through say sqlplus... How far flung is this Citrix app do you have remote users? In remote offices? What kind of bandwidth do you have? How much data is pumped between the database and the client in a typical connection? Sorry if a came off a bit frank, but If I were you I would go back and listen to your DBA's again. This time more closely because I am sure you left a lot of other information out. Stop listening to the Citrix and Logician marketing hype and listen to your people. Software vendors could care less how well your app runs as long as they get their stinking money. They are in the business first to SELL SOFTWARE, always remember that. You have to get everybody working together, accept the situation, set some new expectations and hold the vendor partially accountable if you are going to move forward on this problem. If you indeed can say: "When I push this button it take ten minutes to get the data" and the same query takes just as long from sqlplus then you POSSIBLY have a database issue, a program design issue or both. Good luck. Brad Odland -----Original Message----- [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 12: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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).