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
Diff between OCI, ODBC and Oracle Enterprise Stages
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
$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).
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.