DSXchange

Hi,

Can anyone explain me the difference between OCI, ODBC and Oracle Enterprise stages? I know how to use these stages. But I am not sure what happens in the back ground process of Oracle Enterprise stage (which is used only in PX) and OCI stages. Is there any performance difference in them? How does Oracle Enterprise Stage differ from OCI? I am asking about the back ground processes differ.

Any info can be useful!!!

Thanks in advance,
Srikanth

$DATABASE Enterprise stage is the stage that connects to that database and runs in Enterprise Edition (that is, parallel jobs).

OCI is a stage type that uses the Oracle Client Interface software to connect to Oracle.

ODBC is a stage type that uses an ODBC driver to connect to a data source. You need to configure data sources by editing a file (UNIX) or registry entries using ODBC Administrator (Windows).

Thank you Ray!