Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle Transparent Gateway Tuning

Oracle Transparent Gateway Tuning

From: <vdelrosario_at_my-dejanews.com>
Date: Tue, 06 Oct 1998 16:14:40 GMT
Message-ID: <6vdflg$d2$1@nnrp1.dejanews.com>


Does anyone know of any books, white papers, or web pages, basically any resources that would aid in the tuning of the Oracle Transparent Gateway for DB/2 for AS/400. Queries such as simple select statements take much too long to execute. I am basically interested in both Oracle and AS/400 side tuning tips that may aleviate the slow down. We have determined that the slow down is not due to network traffic. By themselves, Queries on the AS/400 and Oracle side are fine. Once the Gateway is thrown into the mix.... well SLOW!  I am surprised that there is not many resources other than opening up a TAR with Oracle.

Does anyone have any pointers or recommendations for books on the Oracle Transparent Gateway for DB/2 for MVS. (Going from an F50 RS/6000 box with oracle 7.1.3 to DB/2 3.1 on MVS) I desperately need tuning advice and information. I have a handful of queries that take way too long. I am interested in parameters on the Oracle side that may help, how to tune the statements, ( i.e. tune them for DB/2 or tune them for Oracle or doesn't it matter) - and possible flaws in the system and how to get around them. Oracle has conceded that doing a join of tables, some on one side, some on the other is enormously slow, because the entire DB/2 table is brought over to execute the join. Why? There seems to be an amazing absence of information on the subject.

Thanks in advance
Regards,
Vince Del Rosario
Obvious Professional Services

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Oct 06 1998 - 11:14:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US