Saira That is exactly my point. How do you think they did the port? I would pretty much guarantee that they took their existing Informix version and made the minimum changes necessary to get the Oracle port going. Hopefully they have a manual for their Informix version with a chapter on the database interface. Get that and digest it in detail as I described earlier. Then look into your Oracle database and any application configuration files and look for stuff that is similar and different. Most of it should match their manual, but you may detect some changes they have made. This puts you in a good position to do two things: 1) develop tuning ideas that will work given the limitations 2) talk to the vendor's staff using words and concepts that are familiar to them. And if they don't even have a chapter on their older Informix version, well, you can probably have a personal phone call with their database developer.
Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Friday, September 26, 2003 11:15 AM To: Multiple recipients of list ORACLE-L Dennis, The ERP vendor started off using Informix and ported their application to Oracle. We are 1 of 2 Oracle installations and they do not have much Oracle expertise in their company - they don't provide any administrative type manuals for the SA or DBA with respect to their products. I wish they would write an Oracle chapter or at least release an internal document which would explain all this. I do think that with their new release, they will be providing some tips for tuning so maybe I can just hold off until then. The on-line forum is a great idea and there is one in which we actively participate. Thanks, Saira -----Original Message----- DENNIS WILLIAMS Sent: September 25, 2003 5:15 PM To: Multiple recipients of list ORACLE-L eff Saira Here is my tip. Every vendor must take an approach and if they support many databases there will be some compromises in their architecture. The vendor probably has a chapter in a manual about how they interface with Oracle. Read this, but don't skim it like most of us do because we have way too much to read. No, ponder each word and try online experiments to try and learn what every detail means. In a former life I worked for a vendor and I wrote that Oracle chapter. For some reason it is hard to write that sort of thing so everyone can understand it. Once you really understand the vendor's approach, you are miles ahead in understanding your tuning alternatives. Also if it is an ERP vendor, there is probably an online user forum somewhere and you can get a lot of specific advice there. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Thursday, September 25, 2003 3:35 PM To: Multiple recipients of list ORACLE-L efforts? List, I begin with an apology for repeating something that has probably been asked before in different words. We use an integrated ERP/WMS/Query application provided by a vendor but we do not have the ability to change any code. How do I know that my Oracle database is running optimally (if there is such a thing)? Obviously I cannot rewrite queries in the application code (which is 4GL code BTW). So what other aspects of the database can I change/tune? I can definitely see some costly SQL statements when I feel curious and want to check what's happening on the database. But isn't cost all relative? Are there any recommendations for articles, white papers, books on how to tune the database for a third party application? Also, I will be attending the DBA/Developer Day in Toronto on Monday October 6. I am looking forward to the sessions by Tim Gorman, Tim Quinlan and Michael Abbey. Anyone else attending this conference? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin 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: DENNIS WILLIAMS 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: Saira Somani-Mendelin 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: DENNIS WILLIAMS 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).
