difference between oracle oci 8i and 9i

kjaouhari · Post by **kjaouhari** » Mon Nov 20, 2006 3:20 am

Hi all,

I use oracle oci for a simple extraction.

do you think there is a difference of performance between oracle oci 8i and 9i.

Because if it's yes (even for a simple extraction) I will install the oracle oci 9i.

Thanks in advance.

Prashantoncyber · Post by **Prashantoncyber** » Mon Nov 20, 2006 3:30 am

With respect to datastage,for simple extraction you wont find any difference performance wise.
However oracle 9i has more features & facility with database standpoint......

BTY.....wht is your requirement? This will help to give more precise advice

kjaouhari · Post by **kjaouhari** » Mon Nov 20, 2006 3:37 am

Thanks,

my requiement is just a SELECT on 2 tables and wih conversion on date, I try to optimize this because the tables are very big.

ray.wurlod · Post by **ray.wurlod** » Mon Nov 20, 2006 7:20 am

It still has to depend on what you're doing. You need to read the information about what's changed in Oracle 9i (the "i" stands for "internet"). I doubt that very much has been done for SELECT performance. Make sure your joining columns are indexed, so that the join can be resolved in the indices.

chulett · Post by **chulett** » Mon Nov 20, 2006 8:16 am

First question from me would be - what version of the Oracle database are you working with? 8i? 9i? A mixture of both?

kjaouhari · Post by **kjaouhari** » Tue Nov 21, 2006 5:44 am

The database source is on 8i and the database destination is 9i.

chulett · Post by **chulett** » Tue Nov 21, 2006 8:14 am

Your 'problem' is going to be the fact that DataStage really only supports one client version at a time. So best to stick with the 8i stage, leverage the 8i client and use it to access both the 8i and 9i databases.

kjaouhari · Post by **kjaouhari** » Tue Nov 21, 2006 9:06 am

Thanks , it's what I did ...