Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle Transparent Gateway Tuning
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